Tag - Jay Janssen

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

MySQL Tutorials: A time to learn at Percona Live 2015

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 2015’s event will be no exception.
Percona Live 2015 runs April 13-16 in Santa Clara, Calif. and the first day is dedicated to […]

Read more

Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant

Introducing Consul
I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable.  If you’ve 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 store (a […]

Read more