Multi-Master MySQL

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 session will discuss precisely that, as well as the tools and pitfalls.

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

Duration: 
30 minutes

Speaker: arjen

arjen

(photo of Arjen with his daughter)

Arjen is Exec.Director at Open Query, based from Brisbane Australia. He likes spending time with his daughter, travelling, walking and camping. He also loves to cook, and growing his own herbs and veggies.

Ohyes, and Open Query does MySQL magic for you: remote support/DBA, OQGRAPH engine.... but Arjen would like you too to enjoy your free time, so he and his gang help you design well and prevent trouble, rather than play "fire department".

Are you attending LCA?: 
I am attending Linux.conf.au
Member for
43 weeks 1 day

Who is Tweeting about DrupalSouth?

Subscribe to DrupalSouth


Twitter logo

Enter your email address: