public marks

PUBLIC MARKS with tags tutorial & applications

2008

Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch | HowtoForge - Linux Howtos and Tutorials

by camel & 1 other (via)
This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication (which is explained here) is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1. 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.

2007

2006

PUBLIC TAGS related to tag tutorial

media +   media_image +   photoshop +  

Active users

camel
last mark : 20/11/2008 16:02

Xavier Lacot
last mark : 13/05/2008 07:08

webs
last mark : 30/09/2007 18:48

jasonbentley
last mark : 09/09/2006 08:18

zoom2au
last mark : 18/06/2006 23:28

josefigueira
last mark : 25/05/2006 21:26