MySQL Forge

Resources for the MySQL Community

Categories: Contributing | Development | MySQLUniversity

MySQL Galera Multi-Master Replication

← Back to MySQL University main page

[edit] MySQL Galera Multi-Master Replication

• Date and time: February 11, 2010, 14:00 UTC
• Presenter: Seppo Jaakola & Alex Yurchenko, Codership Oy
• Host: Stefan Hinz
• Session recording (video & audio stream)
• Presentation slides
• Abstract: Galera provides synchronous multi-master replication and uses a certification-based replication method for replicating transaction write sets in a DBMS cluster. The replication method requires close co-operation with database transaction processing and DMBS must support a specific replication API to be compatible with Galera.
  Codership has integrated Galera replication in the InnoDB storage engine, and the resulting MySQL/Galera cluster product has been published as a production-ready GA release in December 2009. The MySQL/Galera release 0.7 is available on the Codership and Launchpad sites.
  In the presentation we will go through following agenda:
  1. Overview of certification based replication method
     • how it works
     • what it is good for, good and bad use cases
  2. Replication API (wsrep API: https://launchpad.net/wsrep)
     • presenting the calls and callbacks in the API
     • how DDL replication is supported
  3. wsrep API integration in MySQL
     • how Galera library is organized
     • showing the integration points in MySQL source code
     • prioritized transaction implementation
  4. Benchmark results
     • our experiments with Galera cluster
     • some results from: sysbench, DBT2 and 100% insert test
  5. Galera R&D status and road map
     • status of current release
     • content of next 0.8 release (~Apr 2010)
     • longer term future plans