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

[Gregory Szorc]

On 6/20/06, Swoop <docuswear at 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?
>
> -s



http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html