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 10 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 Consulting Lead there specializing in Percona XtraDB Cluster and High Availability architectures.
He tweets at @jayjanssen
