MySQL Replication Advanced Techniques

Giuseppe Maxia (Continuent)
Tutorial
Location: Ballroom E
Average rating: ****.
(4.80, 5 ratings)

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:
  • How to make a more resilient system with replication;
  • how to improve performance of several heavy operations with the help of replication;
  • how to set up a quick replication scenario to test the above techniques;
  • Which tools and applications they can look at for further improvement.
Photo of Giuseppe Maxia

Giuseppe Maxia

Continuent

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.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

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).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts