On 6/20/06, Domas Mituzas <midom.lists(a)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.
--
Rick DeNatale
IPMS/USA Region 12 Coordinator
http://ipmsr12.denhaven2.com/
Visit the Project Mercury Wiki Site
http://www.mercuryspacecraft.com/