MySQL Dual Master Setups with MMM

Arjen Lentz (Open Query), Walter Heck (Open Query)
Average rating: *....
(1.83, 6 ratings)

Implementing multi-master setups with MySQL is fairly trivial in basic terms, but for an effective environment much more is involved. There are some tools (such as MMM, Multi-Master MySQL Manager) that can help, but there’s still a lot to think of and each deployment is different. So why would you wish to bother, given all these complications? This tutorial will explore precisely that, as well as various tools for management, loadbalancing and failover, and their pitfalls. Some ideas that seems good don’t always work so well in the real world, and we’ll explore that too.

Since each master has to execute the writes from the other anyway, so we’re not doing it for write scaling. Sharding is a more effective way to handle that. Instead, multi-master MySQL can be used to ease failover, as well as enable a range of maintenance tasks. It can deliver a system that, even with major upgrades or structural changes, does not require any down time. We all hate that “this website is undergoing maintenance”, and it’s bad for business. So let’s avoid it.

Photo of Arjen Lentz

Arjen Lentz

Open Query

Arjen initially started with C programming, but has since branched out to other stuff that blends geekness with more human interaction.

Arjen was employee #25 at MySQL AB (2001-2007), dealing with Documentation, Community Relations, Training, Support, Licensing, and acting as Program Chair for the 2005 and 2006 MySQL Users Conferences. He also co-authored the 2nd edition of O’Reilly’s popular “High Performance MySQL” book.

Arjen founded Open Query, delivering affordable remote and on-site MySQL support and training. He also does some coding again with the OQGRAPH engine, and his work on OurDelta (Builds for MySQL & MariaDB).

Outside work Arjen likes spending time with his daughter, bushwalking, camping, and dabbles in organic gardening.

Photo of Walter Heck

Walter Heck

Open Query

Walter Heck (IRC: walterheck) has been working in IT since he came out of college in 2001. First as a Delphi-programmer, always working on database driven applications. He gained a lot of experience with different database backends like Oracle and MS SQL Server.

When he wanted to switch gears back in 2007 he decided that MySQL was going to be his new focal point. Ever since, he has been studying MySQL, while using it wherever possible.When Walter is not on his computer working, you might find him in your local neighbourhood store, as he is traveling around the world and loves to visit new, simple places to watch people live their lives and learn about their cultures.

Walter has presented at various FOSS conferences around the world, like FrOSCon 2009 in Germany and Foss.my 2009 in Malaysia.

  • 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.