
7 Dec
2011
7 Dec
'11
4:27 a.m.
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