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!

We're looking for an enthusiastic International Inside Sales Representative (preferably in North American / European timezones) to join our small and driven sales team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely; in fact, it will need to be done remotely, we all work from home ;-)

Severalnines is a self-funded startup with a dozen employees; headquartered in Stockholm, Sweden and with a globally distributed, home-office based team. We provide automation and management software for database clusters. Our ClusterControl product is the leading database automation platform for database clusters and is used by thousands of companies.

We were …

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, regardless of what actually is the latest version available in the software provider’s repository. There are several ways to achieve this:
* download specific version packages manually and then install them,
* have custom local repository mirror where you decide when and which version gets there, and just update …

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:

• file storage
• web server
• database server
• load balancer

We will use five servers. ownCloud will run on three separate servers with MySQL Galera Cluster 5.6 and GlusterFS running on RHEL 6.5 64bit. ownCloud supports GlusterFS as primary storage. ClusterControl will be co-located with one of the two load balancers to monitor and manage …

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:

• file storage
• web server
• database server
• load balancer

We will use five servers. ownCloud will run on three separate servers with MySQL Galera Cluster 5.6 and GlusterFS running on RHEL 6.5 64bit. ownCloud supports GlusterFS as primary storage. ClusterControl will be co-located …

Even if new tools from the Percona Toolkit can do a more extensive or a better job, "mysqladmin" has the advantage to be included on the Debian/Ubuntu packages of MySQL, MariaDB (and probably Percona Server as well) and to be simple of use and to understand without outputting tons of unnecessary informations.

I forked the latest version of it (3.5) to fix some bugs and add stats/infos about many new functionalities present on newer versions of MySQL but also some specific to XtraDB, to MariaDB and also TokuDB stats while still being fully compatible with older versions of MySQL.

You can find the latest version at : https://github.com/jb-boin/mariadb/blob/5.5.30/debian/additions/mysqlreport
To have more infos about it and the changelog : https://mariadb.atlassian.net/browse/MDEV-573

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 5.5, it supports full-text indexes and Oracle ends support of 5.5 this year.

Oracle distributes MySQL releases via YUM repository. Installing MySQL from the YUM repository is a good idea because YUM takes care of …

I was sad that it is over with Hack MySQL. It's features where very helpful to me especially in code testing.

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 across a diversity of platforms and technoligies. We are excited to announce our latest step is enhanced per-process metrics support for monitoring FreeBSD.

What does this mean? Quite simply, you can now enjoy the unparalleled insight we offer for Linux if you are using FreeBSD. This includes CPU, memory, I/O …

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 own tools, but I think I was the first to develop, document, and publish general-purpose MySQL tools. If I wasn't the first then it's a tie with Baron Schwartz, creator of Maatkit. In 2008 he hired me at …