MySQL replication is the backbone of web scalability. Yet, it is not well understood beyond its basics principles. This tutorial wants to guide demanding DBAs and developers through the path of advanced replication techniques. After a quick refresh of the replication basics, this tutorial will plunge into several techniques to perform failover and failback operations, both scheduled and as a reaction to failure. We will cover the manual procedure, several tools that can make the task easier, and third parties patches or frameworks that can achieve the purpose even more easily. Then, we will illustrate some techniques that can enhance the performance of the system by combining replication with other technologies, such as partitioning, engine changes, user defined functions, and some scripting glue.What the attendees will learn in this tutorial:
Giuseppe Maxia, a.k.a. “The Data Charmer” works as QA Director at Continuent.
He’s an active member of the MySQL community and long timer open source enthusiast.
During the past decades he has 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.
Works in cyberspace, with a virtual team.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts