Author - Jay Janssen

Bypassing SST in Percona XtraDB Cluster with binary logs

In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available to use.
In this post, I want to present another methodology […]

Read more

Bypassing SST in Percona XtraDB Cluster with incremental backups

Beware the SST
In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with multiple Terabytes of data can be quite […]

Read more

TOI wsrep_RSU_method in PXC 5.6.24 and up

I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat.  Prior to this release, the variable was GLOBAL only, meaning to use it you would:

Shell

mysql> set GLOBAL wsrep_OSU_method=’RSU’;
mysql> ALTER TABLE …
mysql> set GLOBAL wsrep_OSU_method=’TOI’;

123

mysql> set GLOBAL wsrep_OSU_method=’RSU’;mysql> ALTER TABLE …mysql> set GLOBAL wsrep_OSU_method=’TOI’;

This had the (possibly […]

Read more

innodb_buffer_pool_size – Is 80% of RAM the right amount?

innodb_buffer_pool_size

It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems ingrained in many a DBA’s minds.  The MySQL manual to this day refers to this rule, so who can blame the DBA? […]

Read more

Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

Background on Backup Locks
I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in

Read more