[Mediawiki-l] How Do You Deal With MySQL Replication?

[Brion Vibber]

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.

-- brion vibber (brion @ pobox.com)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 249 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20060620/86119688/attachment.pgp