High Availability Tools for use with MySQL

Replication and High Availability Strategies
2 April 11:30AM - 12:20PM @ Ballroom C

Experience level: 
Beginner
Duration: 
50 minutes conference
Vips, TCP proxies, NATing proxies, Layer 7 Load balancers, DNS entries, smoke signals. Every good HA architecture will abstract the physical connection information between the application and the database and make failover as transparent as possible, but what's the best way? This talk will attempt to survey the vast landscape of HA tools/methods, whether designed for MySQL or not. Criteria evaluated for each method will include atomicity of failover, switchover vs failover, health checking, performance, load balancing and much more. Note that this talk will not focus so much on how the database itself fails over, but how the application to database connection can be failed over with it. Slides can be viewed and downloaded from: http://bit.ly/mysql-ha-tools


Speakers

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