EmergencyEMERGENCY? Get 24/7 Help Now!

High Availability with mysqlnd_ms on Percona XtraDB Cluster

 | July 16, 2014 |  Posted In: High-availability, Insight for Developers, MySQL, Percona XtraDB Cluster

This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used […]

Read More

Simple MySQL Master HA with mysqlnd_ms

 | July 14, 2014 |  Posted In: Insight for Developers, MySQL

I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing without needing to change anything from your application. But do […]

Read More

Encrypted and incremental MySQL backups with Percona XtraBackup

 | April 24, 2014 |  Posted In: MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona Software, Percona XtraBackup

We’ve recently received a number of questions on how to implement incremental MySQL backups alongside encryption with Percona XtraBackup. Some users thought it was not initially possible because with the default --encrypt options with XtraBackup, all files will be encrypted, but alas, that is not the case. This is where the option --extra-lsn-dir becomes useful, […]

Read More

Another reason why SQL_SLAVE_SKIP_COUNTER is bad in MySQL

 | July 23, 2013 |  Posted In: MySQL

It is everywhere in the world of MySQL that if your replication is broken because an event caused a duplicate key or a row was not found and it cannot be updated or deleted, then you can use ‘ STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; ‘ and be done with it. In some cases this is fine and you can repair the […]

Read More

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

 | May 1, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these […]

Read More

Distro Packages, Pre-built Binaries or Compile Your Own MySQL

 | September 4, 2012 |  Posted In: MySQL

I’ve been helping customers deploy and maintain MySQL (and variants) for the last couple of years and it has always been interesting to hear customer thoughts on how they want their servers installed. It has also been asked many times not only by our support and consulting customers, but widely from different forums and blogs […]

Read More