MySQL High Availability: Power, Magic, and Usability

Database Administration
4 December 10:30 - 11:20 @ Orchard 2

There are many recipes for achieving high availability with MySQL. One of the most powerful tools is Continuent Tungsten, which provides management and connectivity on top of asynchronous replication, giving users a transparent view of clusters. Tungsten clusters are self-healing (they can react to failure automatically and promote slaves to masters without manual input) and transparent: applications connecting to these clusters don’t need to know anything about their composition, and connection is routed to the active members in case of a failure. Tungsten clusters are also user-friendly. The installer provides several topologies and endless customization. This is HA that leverages the most-advanced technology in this field.
Tools of this kind need to be tested ruthlessly, to make sure that they behave as designed. The tools developed to test Tungsten clusters are almost as technologically beautiful as the cluster itself.
The session includes a self-generated interactive demo, illustrating the power and advanced technology in Tungsten tools. It will show in practice how a cluster can recover from most accidents, including a whole site failure.

Speakers

Giuseppe Maxia
QA Director, Continuent, Inc
Speaker Biography: 
QA Director at Continuent I am active member of the MySQL community and long timer open source enthusiast. During the past 25 years I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team.


Slides