Galera - Synchronous Multi-master Replication For InnoDB

Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Replication and Scale-Out
Location: Ballroom A
Average rating: ***..
(3.20, 5 ratings)

Galera is synchronous multi-master replication method, using certification based technology for conflict resolution. This replication method brings nice features like:

  • High Availability
    Transaction commit will be synchronously enforced in every server
    in the cluster. This gives “no commit lost” guarantee for the
    cluster.
  • Performance
    Galera replicates RBR (row based replication) events and this has
    proven out to be very efficient. Galera can scale even with SQL
    work load which is 100% writes.
  • Transparency
    Clients connect directly to one of the MySQL/InnoDB servers in
    the cluster and experience close to native InnoDB behavior.

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.
MySQL/Galera release 0.7 is open source and is available in Codership and launchpad sites.

The presentation will give on overview of Galera replication and show how Galera can be taken in production and managed. Presentation has following agenda:

1. Galera Replication Overview

  • Galera cluster architecture, Replication API
  • What type of work load Galera replication is good for
  • How DDL replication works

2. Replication use cases

  • Possible replication topologies
  • Galera in cloud
  • WAN replication with Galera

3. Client connectivity

  • Options for connecting to Galera cluster
  • Load balancer options
  • Transparency walk through – differences with native MySQL

4. Management

  • Installing Galera cluster
  • Options for managing and monitoring Galera cluster
  • Galera statistics explained

5. Benchmark results

  • Our experiments with Galera cluster
  • Some results from: sysbench, DBT2 and 100% insert tests

6. Project status and road map

  • Status of current release
  • Feedback from the community
  • Road map

Seppo Jaakola

Codership

Master of Science in software engineering (HUT)

20 years experience in software engineering and R&D management in various organizations. Experience from:

  • DBMS research and engine development
  • Distributed computing, networking
  • Data security, firewall, network management

Current position as partner and CEO at Codership providing consultation for MySQL users and implementing high performance replication solutions for MySQL and PostgreSQL databases. Previous employments include:

  • Continuent – R&D for MySQL clustering solutions
  • Stonesoft – developing firewall and IPS clusters, DBMS R&D
  • Logica – developing traffic information systems
Photo of Alexey Yurchenko

Alexey Yurchenko

Codership

Alex started his career in DBMS clustering development in 2003 at Continuent, where he was hooked up on synchronous replication. After that he joined R&D team at Meshcom Inc, learning the ways of mesh networking, embedded SW development and Scrum process management. There he got this crazy idea that running a software company can be fun and joined as a partner in Codership, specializing in group communication system development.

In his former life he held a Masters Degree in Astronomy from SUNY at Stony Brook and worked as a software engineer at Budker Institute for Nuclear Physics .

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/22/2010 6:37am PDT

Video for this presentation is at www.youtube.com/watch?v=SL5...

Mike Pattison
04/14/2010 11:23pm PDT

The most interesting new product at the conference by far

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

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

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.