EmergencyEMERGENCY? Get 24/7 Help Now!

More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar)

 | February 19, 2015 |  Posted In: MySQL, Percona XtraBackup

In a previous post, titled “Multi-threaded replication with MySQL 5.6: Use GTIDs,” I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Let’s see now how to perform the day-to-day operations when MTS and GTIDs are both enabled. (I’ll also be presenting a related webinar next week titled “Multi-threaded Replication […]

Read More

Online GTID rollout now available in Percona Server 5.6

 | February 10, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server

Global Transaction IDs (GTIDs) are one of my favorite features of MySQL 5.6. The main limitation is that you must stop all the servers at the same time to allow GTID-replication. Not everyone can afford to take a downtime so this requirement has been a showstopper for many people. Starting with Percona Server 5.6.22-72.0 enabling […]

Read More

Making HAProxy 1.5 replication lag aware in MySQL

 | December 18, 2014 |  Posted In: haproxy, Insight for DBAs, MySQL, Percona Toolkit, Percona XtraDB Cluster

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 […]

Read More

Schema changes in MySQL for OpenStack Trove users

 | November 24, 2014 |  Posted In: MySQL, OpenStack, Trove

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? Let’s 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 […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.