froscon2009 - 1.0

Free and Open Source Software Conference

Seppo Jaakola
Day Day 2 (2009-08-23)
Room C120/OpenSQLCamp
Start time 15:15
Duration 01:00
ID 440
Event type Lecture
Track OpenSQLCamp
Language used for presentation English

Galera Replication

multi-master synchronous replication for MySQL

Galera is generic replication service, which has been integrated with MySQL providing multi-master synchronous MySQL/InnoDB clustering solution. Galera replication gives:

  • good performance even with write intensive work loads
  • high availability (due to synchronous replication)
  • transparency for client connections

Galera replication uses certification based replication method, which gives good performance even with write intensive work loads. In the presentation, we will show the concept and architecture of MySQL/Galera clustering solution. Galera integration with DBMS engines happens through wsrep API (write set replication API) and we will describe the state and goals of wsrep and Galera projects.

We have benchmarked MySQL/Galera with several benchmarks and results show remarkable performance gain. The presentation shows results from Sysbench, DBT2 benchmark runs. We have evaluated MySQL/Galera under Drupal and eZ Publish CMS systems and will show results from jmeter benchmark against Drupal cluster.