[Maria-discuss] New Question: Multi Master Replication
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/
AskMonty KB <noreply@askmonty.org> writes:
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.
The obvious guess is that the new master has DROP TABLE t1300,t13 in its binlog. If this is the problem, then it can be solved by for example changing the replication position to skip those events, or maybe by using replication filters. - Kristian.
participants (2)
-
AskMonty KB
-
Kristian Nielsen