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:
http://forums.mysql.com/read.php?26,12230,12230
Circular Replication:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication
..html
MySQL Documentation - mysqld_multi:
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html

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
a
MYSQL server running at each branch. What they would like to do is have
each
branch replicate to an offsite server as a backup. Has anyone done
something
similar to this? 

 

Regards,

              Justin Elward

 

Blue Wave Software Pty Limited

justin@stripped

 

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 

 

------------------------------------------------------------------------
----
-------------------

DISCLAIMER: 

This message is proprietary to Blue Wave Software Pty Limited (BWS) and
is
intended solely for the use of the individual or individuals to whom it
is
addressed. It may contain privileged or confidential information and
should
not be circulated with out informing BWS prior or used for any purpose
other
than for what it is intended. If you have received this message in
error,
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
accepts
no responsibility (except where required under Australian law) for loss
or
damage arising from the use or misuse of the information transmitted by
this
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 ****************************
******************************************

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