Comments on Master-Master Replication With MySQL 5 On Fedora 8
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.
2 Comment(s)
Comments
I have looked on the forum, but no help. What do you use to get the code in, what program/software are you connecting to your SQL database with?
If you are on Linux, you can use a terminal. If you are on Windows, you can use an SSH client such as PuTTY (it's available for Linux as well):
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html