maria-discuss team mailing list archive

Thread
Date

Re: New Question: Multi Master Replication

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>
Date: Thu, 27 Mar 2014 08:26:29 +0100
In-reply-to: <20140326213503.21385.57730@kb01.mariadb.com> (AskMonty KB's message of "Wed, 26 Mar 2014 21:35:03 -0000")
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)

AskMonty KB <noreply@xxxxxxxxxxxx> 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.

References

New Question: Multi Master Replication
From: AskMonty KB, 2014-03-26