Linking Multiple Db And Dump

[Anon]

I am wondering if there is a way to link multiple mysql servers together so they dump and update each other?

I am wanting to creat mirrors for my site maybe using 30 php servers and 3 db servers

10 hits goes to db 1
10 hits goes to db 2
ect..

Is there way to keep the 3 db's updated with each other?

[crimaniak]

two-way replication is possible. But you need to think about:

1. Which tables exactly need two-way replication
   For every such table:
2. You need the special field with serverID in the primary key OR start auto-increment key from different positions: 1st server - zero, 2nd server - 1 million, and so on. Keys must be unique.
3. If records can be deleted from such tables you need delete logs and you need to think how to prevent collisions like: 1st delete it, then second edit and try to replicate.

[Anon]

Ahh Interesting.

Thanks just getting an idea if this can be done..

Will carry this conversation on a bit in a month when im going to start the project.

Thanks Crimaniak