Hello,

A new question has been asked in "MariaDB Documentation" by eddow:
--------------------------------
Greetings,
I am attempting to set up Multi Master Replication.  So far, I have been able 
to set up multiple masters and data is replicated to one slave.  This works 
great.

What I am having a problem with is if I add a new master.  When I add the 
master the data in the slave table is truncated and only the data from the new 
master is replicated.  I loose all my old data in the slave.

Example:  


Master 1300: 

+----------------+

| name           |

+----------------+

 t1300



Master 13:  

+----------------+

| name           |

+----------------+

 t13            

+----------------+




Slave:

+----------------+

| name           |

+----------------+

 t1300     

 t13              

+----------------+


On the slave I do this:
change master 't68' to master_host='10.79.84.149', 
master_user='replication_user', master_port=3306;

start slave t1300;

select * from name;

Slave:

+----------------+

| name           |

+----------------+

 t68            

+----------------+


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

To view or answer this question please visit: 
http://mariadb.com/kb/en/multi-master-replication/

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to