Re: Pointers about replication

2007-03-07 Thread Marcus Bointon
On 7 Mar 2007, at 06:39, Cabbar Duzayak wrote: I am particularly interested in master-to-master replication (not even sure if this is possible with mysql) and/or real-world usage scenarios/examples as to how much load it can handle, how reliable it is, etc? I've had some success with it. I fo

Re: Pointers about replication

2007-03-07 Thread Adrian Bruce
Hi Multi-master replication is safely possible with MySQL 5.0 when they introduced auto_increment_increment and auto_increment_offset variables. Before this it was possible to run into problems with auto increment columns generating non-unique numbers between servers. Try the following link

Pointers about replication

2007-03-06 Thread Cabbar Duzayak
Hi All, Would it be possible to provide some advanced pointers (articles/books/tutorials/sites) for learning more about replication? I am particularly interested in master-to-master replication (not even sure if this is possible with mysql) and/or real-world usage scenarios/examples as to how mu