Galera Replication, multi-master synchronous replication for MySQL

Seppo Jaakola presents Galera at the 2009 OpenSQLCamp Europe, part of FrOSCon.

From the official conference description at http://programm.froscon.org/2009/events/440.en.html

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.

Codership: http://www.codership.com/
Integration in MySQL: https://launchpad.net/codership-mysql
wsrep API: https://launchpad.net/wsrep

Category:

Science & Technology

Tags:

• Seppo Jaakola
• froscon
• opensqlcamp
• replication
• synchronous
• cluster
• innodb
• multi-master

[Vidofile]

What is going on with the fighter strafing runs in the background?