Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, June 6, 2012    Jay Janssen

Migrating To Percona XtraDB Cluster

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?

Slides: Download Here

 


About the Author

Jay Janssen

Jay came to Percona in 2011 after working 7 years for Yahoo working in a variety of fields including High Availability architectures, MySQL training, tool building, global server load balancing, multi-datacenter environments, operationalization, and monitoring. Jay holds a B.S. of Computer Science from Rochester Institute of Technology. He and his wife live with their four children in upstate New York.