maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

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/