On 6/20/06, Domas Mituzas midom.lists@gmail.com wrote:
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.
even then you don't want to use multiple masters. unless you really really know what you're doing. if you know mediawiki that well, you might probably assist with coding.
So where did I imply that you should use multiple masters? Or even that I knew mediawiki that well? All I did was point out that the OP's concern only came up if there were multiple masters, and then to suggest that single master replication was the way to go if you wanted replication at all.
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.
well, you can do backups from innodb without stopping or locking the master. and yes, you can load balance, and the code for that is already inside MediaWiki.
Which, if I understand Brion's latest post correctly uses single master replication, as I suggested.