On 6/20/06, Gregory Szorc <gregory.szorc(a)gmail.com> wrote:
On 6/20/06, Swoop <docuswear(a)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.
--
Rick DeNatale
IPMS/USA Region 12 Coordinator
http://ipmsr12.denhaven2.com/
Visit the Project Mercury Wiki Site
http://www.mercuryspacecraft.com/