Brion Vibber wrote:
Swoop wrote:
MediaWiki uses auto-incrementing fields for some of its primary keys. This is a no-no when operating in a MySQL replicated environment, due to the likelihood of multiple servers generating the same primary key number (should the servers lose connectivity).
There's only one master, so only one place generating keys.
I should point out that MySQL has no support for conflict management in multi-master replication; basically nobody should ever do it unless they know exactly what they're doing.
Stick with single-master replication only. Never, ever write to a slave.
-- brion vibber (brion @ pobox.com)