MySQL multi-master config ?
Hi folks, Anyone know of anyone using this sort of config in production ? http://onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html It's basically exploiting the auto_increment and auto_increment_offset server settings in news MySQL to avoid ID clashes between servers, and then config them to each replicate the other. It's one of those things that sounds useful, but sounds like it might have a lot of opportunity to do interesting unexpected things to your data.. Thoughts ? cheers, Chris -- Chris Samuel : http://www.csamuel.org/ : Melbourne, VIC
Hi Chris ----- Original Message -----
Anyone know of anyone using this sort of config in production ?
http://onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
It's basically exploiting the auto_increment and auto_increment_offset server settings in news MySQL to avoid ID clashes between servers, and then config them to each replicate the other.
It's one of those things that sounds useful, but sounds like it might have a lot of opportunity to do interesting unexpected things to your data..
We use those settings in our common dual-master setups. Having more than two masters (creating a circle) becomes messy if one server fails, so we never use that. With two masters, we have one active for the app even though the other is fully functional. We can do maintenance on it, add an index or do other stuff (with extra commands so it doesn't log/replicate - then we switch masters and do the same on the other server), or even briefly shutdown for an upgrade. That's all very useful. Having dual masters doesn't scale writes, because a write on the one server needs to be written on the other anyway. So loadbalancing makes no sense. Obviously, for read tasks, slaves are the way to go and they can be loadbalanced. For controlling the multi-master environment we use the MySQL-MMM tool. Some love it, some hate it... we know it well and so it's fine for us and our clients are happy with what it delivers. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://Upstarta.biz Personal blog at http://lentz.com.au/blog/
On 07/12/11 15:44, Arjen Lentz wrote:
Hi Chris
Hi Arjen, Thanks so much for your considered words, makes it sound a lot safer. :-) Any obvious gotchas when considering whether or not this might be a viable path forward for an existing master/slave replication setup ? cheers! Chris -- Chris Samuel : http://www.csamuel.org/ : Melbourne, VIC
Hi Chris
Thanks so much for your considered words, makes it sound a lot safer. :-)
Any obvious gotchas when considering whether or not this might be a viable path forward for an existing master/slave replication setup ?
We do whole tutorials and training on it, so it's a bit much for wrapping in a message. If this is a business thing, I'd suggest getting us to install and maintain the setup. Then you can focus on your main gig. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://Upstarta.biz Personal blog at http://lentz.com.au/blog/
participants (2)
-
Arjen Lentz -
Chris Samuel