On 6/20/06, Gregory Szorc gregory.szorc@gmail.com wrote:
On 6/20/06, Swoop docuswear@yahoo.com 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).
For those of you who do operate in a MySQL replicated environment, how do you deal with this?
http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html
That's only applicable to MySql 5.0+ As I read the docs, autoincrement fields are only an issue if you have multiple replication MASTERS.
So you can have one or more slave servers which replicate a single master, and do things like load balancing queries across all the servers, and taking backups from a suspended slave without stopping or locking the master. Updates and inserts have to go to the single master.