27 Mar
2014
27 Mar
'14
8:26 a.m.
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.