Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 91 to 100 of 33896 10 Older Entries
What defaults would you like to see changed in MySQL 5.7?
Employee +1 Vote Up -0Vote Down

In MySQL 5.6, one of the most well received changes was improving the default configuration to be safer, and easier to use.

We are seeking community feedback for improvements that can be made to the default configuration in MySQL 5.7. Please leave a comment, or get in touch with me via email.

For elimination of confusion, please state both the setting you would like changed, and the new desired value.

Thanks!

Using YUM to install specific MySQL/Percona Server versions
+1 Vote Up -0Vote Down

Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be several reasons for that, where I think the most common is when a new version should spend some time in testing or a staging environment before getting to production. In theory each new version is supposed to be better as usually it contains a handful of bug fixes and even new or improved functionality. However there is also a risk of some regression or a new bug introduction as a side effect of code changes.

Quite often DBAs want the same MySQL version to be installed on all database instances, …

  [Read more...]
High Availability File Sync and Share - Deploying ownCloud with Galera Cluster for MySQL and GlusterFS
+0 Vote Up -0Vote Down

January 5, 2015 By Severalnines

Cloud storage is hot. Dropbox, Apple iCloud, Google Drive, Microsoft SkyDrive and Amazon Cloud Drive all offer cloud sharing platforms where you can store documents in the cloud and access them from all your devices. For enterprises who require full control, ownCloud is an open source solution that allows files to be stored on-premises and/or a backend cloud. 

 

In this blog post, we’ll show you how to deploy a high availability setup using ownCloud Community Edition. We will need to set up redundancy in each of the following layers:

  [Read more...]
Xtrabackup and MySQL 5.6 on Amazon instance
+0 Vote Up -0Vote Down

Have you ever tried to install Xtrabackup on Amazon EC2 instance with Oracle’s MySQL 5.6? Dependencies hell strikes when you ask pretty common and reasonable thing – run the GA version of MySQL and backup it with the most popular open-source tool – XtraBackup. From this post you will learn how to resolve the conflicts and make everybody happy.

mysql55-libs conflicts with mysql-community-libs-5.6.22

A fresh Amazon Linux AMI, 2014.09 EC2 instance comes with MySQL 5.5.40 in amzn-updates repository. Today MySQL 5.5 turns five years old. It’s a good and stable version. But many people want to run MySQL 5.6, because it’s better than …

  [Read more...]
Enhanced Support for Per-Process Metrics on FreeBSD
+0 Vote Up -0Vote Down

VividCortex has always tracked process activity to help monitor and explain database performance, and recent enhancements to the Top Processes feature provide even more clarity. Often, processes impact one another in unexpected ways, and monitoring both MySQL and system resource utilization at high resolution is the only way to pinpoint those instances.

As we develop the product, our goal is to bring users deeper analysis of everything in the system through a unified interface …

  [Read more...]
Hack MySQL has been retired
+0 Vote Up -0Vote Down

After 10 years HackMySQL.com has been retired. The tools are archived at github.com/daniel-nichter/hackmysql.com

I began writing MySQL tools in 2004 because at the time there were none except for mysqldumpslow. I was a Unix sysadmin in a large datacenter, so I worked on many different servers and MySQL instances. Tools for any sufficiently complex system are a necessity. Imagine a car mechanic trying to work without basic tools like an oil filter wrench, torque wrench, or belt tensioner. That's what work with MySQL was like in 2004. Certainly, many people made their …

  [Read more...]
Log Buffer #404, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

With new year already in fast gear, bloggers are sparing no stone unturned to come up with innovative ideas. This Log Buffer edition is keeping pace with them as always.

Oracle:

While playing with 12c Scott tried the upgrade to the DEFAULT column syntax that now allows sequences.

This is an age old question and of course the answer depends on how you say “SQL”.

Happy New Year! …

  [Read more...]
The MySQL Query Cache: How it works, plus workload impacts (good and bad)
+1 Vote Up -0Vote Down

Query caching is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how it works as it has the potential to cause significant performance improvements – or a slowdown – of your workload.

The MySQL query cache is a global one shared among the sessions. It caches the select query along with the result set, which enables the identical selects to execute faster as the data fetches from the in memory. It is important to have everything identical, no new comments, spaces, or most significantly differences in the WHERE clause. Basically when you trigger …

  [Read more...]
Popular Programming Languages
+0 Vote Up -0Vote Down

First of all, Happy New Year!

IEEE Spectrum published a ranking of the most popular programming languages. Computational journalist Nick Diakopoulos wrote the article. While it may surprise some, I wasn’t surprised to find SQL in the top ten.

Nick weighted and combined 12 metrics from 10 sources (including IEEE Xplore, Google, and GitHub) to rank the most popular programming languages.

  • Compiled …
  [Read more...]
Using a CRL with MySQL
+0 Vote Up -0Vote Down

So assume you just uploaded the certificate you use to identify yourself to the MySQL server to Github or some other place it doesn't belong...and there is no undelete.

First: Don't panic.
Often a password is required besides a certificate to connect to the server. So someone with the certificate can't use it without the password. The certificate itself might be protected by a password, but that's really rare. Also access to MySQL and/or your account should be limited to certain IP's.






  [Read more...]
10 Newer Entries Showing entries 91 to 100 of 33896 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.