Your Account

Community

Topics (Sources)

More

View story

Setting Up Master-Master Replication With MySQL 5 On Debian Etch
27 / 3
http://www.howtoforge.com/mysql5_master_master_replication_d...
Submitted by falko 55 months, 3 weeks, 6 days, 8 hours ago
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 do not 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.
Add your comment

If you already have an account, sign in:

Email address:
Password:

If you don't, just complete these fields: (or join coRank for free)

Your name:
Your site: (optional)

Your comment:

(You have up to 5000 characters left)

Can you see the 5 most prominent letters/numbers in this image? (case insensitive)

Please enter them here:

« go back

Home | Terms of Service | Privacy Policy | Help & FAQ | About coRank | Contact us

© coRank 2007-2010