MySQL Lists are EOL. Please join:

List:Replication« Previous MessageNext Message »
From:Daniel Donckers Date:January 25 2007 2:56pm
Subject:RE: Multiple Masters to a Single Slave Server
View as plain text  
If you aren't looking for a merged copy you can just start multiple
instances on different ports with separate data stores (different
directory for each process).  The replication for each slave processes
would take place normally.

MySQL 5.1 is supposed to support the "Star" topology where One Slave
replicates from Multiple Master servers but this is not in general
release yet and is not advised for production environments.

There are some references on the net for doing this with a single data
store shared between multiple slave processes in 5.0.x.
Multiple Masters with One Slave:,12230,12230
Circular Replication:
MySQL Documentation - mysqld_multi:

This should get you started.

Daniel J. Donckers

-----Original Message-----
From: Blue Wave Software [mailto:justin@stripped] 
Sent: Thursday, January 25, 2007 3:02 AM
To: replication@stripped
Subject: Multiple Masters to a Single Slave Server


I have a client with three branches running the same program and having
MYSQL server running at each branch. What they would like to do is have
branch replicate to an offsite server as a backup. Has anyone done
similar to this? 



              Justin Elward


Blue Wave Software Pty Limited



Ph. +61 2 4320 6090 (Central Coast - Office)

Ph. +61 2 4915 7064 (Newcastle)

Ph. +61 2 8208 5982 (Sydney)


Fx. +61 2 4320 6092 




This message is proprietary to Blue Wave Software Pty Limited (BWS) and
intended solely for the use of the individual or individuals to whom it
addressed. It may contain privileged or confidential information and
not be circulated with out informing BWS prior or used for any purpose
than for what it is intended. If you have received this message in
please notify the originator immediately. If you are not the intended
recipient, you are notified that you are strictly prohibited from using,
copying, altering, or disclosing the contents of this message. BWS
no responsibility (except where required under Australian law) for loss
damage arising from the use or misuse of the information transmitted by
email including damage from virus."



*** This email and any files transmitted with it are confidential
and intended solely for the individual or entity to whom they are
addressed. If you have received this email in error destroy it
immediately. ******************************************************
**************** Wal-Mart Confidential ****************************

Multiple Masters to a Single Slave ServerBlue Wave Software25 Jan
  • RE: Multiple Masters to a Single Slave ServerDaniel Donckers25 Jan