Master-Master Replication With MySQL 5 On Fedora 8
View original post
Master-Master Replication With MySQL 5 On Fedora 8
This document describes how to set up master-master replication with
MySQL 5 on Fedora 8. 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.
Related posts
View source postFiled under Fedora |
Leave a Reply