HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular master-slaves setup to spread the read load across [&]

The post Making HAProxy 1.5 replication lag aware in MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/18/making-haproxy-1-5-replication-lag-aware-in-mysql/

I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post Im going to talk about one important InnoDB limitation that you should consider. InnoDB is a multiversion concurrency control (MVCC) storage [&]

The post InnoDBs multi-versioning handling can be Achilles’ heel appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/17/innodbs-multi-versioning-handling-can-be-achilles-heel/

I attended the OpenStack Paris summit last month (Percona had a booth there). It was my first opportunity to meet face-to-face with this thriving community of developers and users. Im proud that Percona is part of this open source family and look forward to reconnecting with many of the developers and users I met in [&]

The post OpenStack Live tutorials & sessions to bring OpenStack users up to speed appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/16/openstack-live-tutorials-sessions-to-bring-openstack-users-up-to-speed/

The many hours of intensive tutorials, led by some of the top minds in MySQL, have always been a major draw each year to the Percona Live MySQL Conference and Expo. And 2015s event will be no exception. Percona Live 2015 runs April 13-16 in Santa Clara, Calif. and the first day is dedicated to [&]

The post MySQL Tutorials: A time to learn at Percona Live 2015 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/15/mysql-tutorials-time-learn-percona-live-2015/

Percona is glad to announce the release of Percona XtraBackup 2.2.7 on December 10, 2014. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered [&]

The post Percona XtraBackup 2.2.7 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/10/percona-xtrabackup-2-2-7-now-available/

Disclaimer: Do this at your own risk! It doesnt apply if youre using Pluggable authentication and certainly wont be usable if/when MySQL system tables are stored on InnoDB What is the situation? The situation is the classic need to recover MySQL root password but you cannot restart MySQL (because it is the master production server, [&]

The post Recover MySQL root password without restarting MySQL (no downtime!) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/10/recover-mysql-root-password-without-restarting-mysql-no-downtime/

On behalf of the OpenStack Live Conference Committee, I am excited to announce the sneak peek schedule for the inaugural OpenStack Live 2015 Conference! This new annual conference, running in parallel with the already established Percona Live MySQL Conference and Expo, will feature one day of tutorials followed by a full day of breakout sessions April 13-14, in [&]

The post OpenStack Live 2015: Sneak peak of the April conference appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/09/openstack-live-2015-sneak-peak-april-conference/

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server also [&]

The post MySQL 5.6 Transportable Tablespaces best practices appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/09/mysql-5-6-transportable-tablespaces-best-practices/

Have you ever experienced a situation where one moment you can connect to the MySQL database and the next moment  you cannot, only to be able to connect again a second later? As you may know one cannot open infinite connections with MySQL. Theres a practical limit and more often than not it is imposed [&]

The post What happens when your application cannot open yet another connection to MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/08/what-happens-when-your-application-cannot-open-yet-another-connection-to-mysql/

Introducing Consul Im always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable.  If youve heard of Vagrant, you know their work. I recently became interested in a newer project they have called Consul.  Consul is a bit hard to describe.  It is (in part): Highly consistent metadata [&]

The post Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/05/streamlined-pxc-anything-testing-consul-vagrant/

Fact: MySQL is the most commonly used database in OpenStack deployments. Of course that includes a number of MySQL variants  standard MySQL by Oracle, MariaDB, Percona Server, MySQL Galera, Percona XtraDB Cluster, etc. However, there are many misconceptions and myths around the pros and cons of these MySQL flavors. Join me and my friend [&]

The post MySQL and OpenStack deep dive: Dec. 10 webinar appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/04/mysql-and-openstack-deep-dive-dec-10-webinar-free/

You know you’ll be there so why not save some $$ by registering now for the Percona Live MySQL Conference & Expo 2015 (April 13-16 in Santa Clara, Calif.). Super Saver registration discounts are available through Dec. 14 at 11:30 p.m. PST. (Thats just 10 days away!) What to expect this year? The Percona Live [&]

The post Sneak peek at the Percona Live MySQL Conference & Expo 2015 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/04/sneak-peek-at-the-percona-live-mysql-conference-expo-2015/

One new feature in Percona XtraDB Cluster (PXC) in recent releases was the inclusion of the ability for an existing cluster to auto-bootstrap after an all-node-down event.  Suppose you lose power on all nodes simultaneously or something else similar happens to your cluster. Traditionally, this meant manually re-bootstrapping the cluster, but not any more. How it [&]

The post Auto-bootstrapping an all-down cluster with Percona XtraDB Cluster appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/03/auto-bootstrapping-an-all-down-cluster-with-percona-xtradb-cluster/

This post is a follow-up to my November 19 webinar, Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA, during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at the over-stretched DBA, identified as the MySQL DBA short of time or an [&]

The post Tips from the trenches for over-extended MySQL DBAs appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/02/tips-from-the-trenches-for-over-extended-mysql-dbas/

By default in MySQL 5.6, each time MySQL is started (regular start or crash recovery), it iterates through all the binlog files when GTIDs are not enabled. This can take a very long time if you have a large number of binary log files. MySQL and Percona Server 5.6.21+ have a fix with the simplified-binlog-gtid-recovery [&]

The post Faster restarts for MySQL and Percona Server 5.6.21+ appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/01/faster-restarts-for-mysql-and-percona-server-5-6-21/

Often enough I find MySQL benchmark results where the difference between results is 1% or even less and some conclusions are drawn. Now it is not that 1% is not important  especially when youre developing the product you should care about those 1% improvements or regressions because they tend to add up. However with [&]

The post MySQL benchmarking: Know your baseline variance! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/26/mysql-benchmarking-know-your-baseline-variance/

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on Novmeber 25th 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.10 and CentOS 7 users can download, install, and upgrade Percona XtraDB Cluster 5.6 from Percona’s software repositories. Based on [&]

The post Percona XtraDB Cluster 5.6.21-25.8 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/25/percona-xtradb-cluster-5-6-21-25-8-now-available/

I log into a lot of different servers running MySQL and one of the first things I do is create a file in my home directory called .my.cnf with my credentials to that local mysql instance: [crayon-548514f0cae27899869443/] This means I dont have to type my password in every time, nor am I tempted to include [&]

The post (More) Secure local passwords in MySQL 5.6 and up appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/25/more-secure-local-passwords-in-mysql-5-6-and-up/

Percona is glad to announce the release of Percona Server 5.6.21-70.1 on November 24, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.21, including all the bug fixes in it, Percona Server 5.6.21-70.1 is the current GA release in the Percona Server 5.6 series. Percona Server is [&]

The post Percona Server 5.6.21-70.1 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/24/percona-server-5-6-21-70-1-now-available/

People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations while minimizing the impact on the database server? Lets explore the options that can allow online schema changes. Summary With MySQL 5.5, pt-online-schema-change from Percona Toolkit is your best option for large tables while regular [&]

The post Schema changes in MySQL for OpenStack Trove users appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/24/schema-changes-in-mysql-for-openstack-trove-users/