froscon2009 - 1.0

FrOSCon
Free and Open Source Software Conference

Referenten
Seppo Jaakola
Programm
Tag Day 2 (2009-08-23)
Raum C120/OpenSQLCamp
Beginn 15:15
Dauer 01:00
Info
ID 440
Veranstaltungstyp Vortrag
Track OpenSQLCamp
Sprache der Veranstaltung englisch
Feedback

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.