Migrating to Percona XtraDB cluster

Replication and High Availability Strategies
25 April 11:00am - 11:50am @ Ballroom B

A lot of people are interested in XtraDB Cluster as a replacement for conventional MySQL master/slave architectures to eliminate replication lag and finally achieve a highly-available masterless cluster of MySQL servers. But what would migration look like?

This talk will go over a high-level overview of XtraDB cluster, as well as operational concerns, possible migration paths, key configuration tuning variables, and generally everything you'll need to migrate from an existing Master/Slave environment into XtraDB cluster. This talk will primarily be an operational discussion, it will not cover in-depth details on how the cluster works.

This talk will cover such questions as:

  • What are the requirements for running XtraDB Cluster?
  • Will I have to reload all my tables?
  • How does configuration for the cluster differ from configuring a stand-alone Innodb server?
  • How should my application interact with the Cluster?
  • Can I use XtraDB cluster if I only have two MySQL servers currently?
  • How can I move to the Cluster and keep downtime to a minimum?
  • How can I migrate to XtraDB cluster gradually?

Speakers

Jay Janssen
Consulting Lead, Percona
Biography: 
Jay Janssen started using MySQL over 13 years ago, but honed his skills during 7 years at Yahoo as a High Availability Consultant specializing in MySQL. He joined Percona in 2011 and is a Managing Consultant there specializing in Percona XtraDB Cluster and High Availability architectures. He tweets at @jayjanssen

Slides