Setting Up Master-Master Replication With MySQL 5 On Debian Etch
Oct 25, 2007, 06:00 (0 Talkback[s])
(Other stories by Falko Timme)
"Since version 5, MySQL comes with built-in support for
master-master replication, solving the problem that can happen with
self-generated keys. In former MySQL versions, the problem with
master-master replication was that conflicts arose immediately if
node A and node B both inserted an auto-incrementing key on the
same table. The advantages of master-master replication over the
traditional master-slave replication are that you don't have to
modify your applications to make write accesses only to the master,
and that it is easier to provide high-availability because if the
master fails, you still have the other master..."
Complete Story
Related Story:
HowtoForge:
MySQL Master Master Replication(Oct 10, 2006)
