MySQL Forums
Forum List  »  Replication

Load data from master drops tables
Posted by: Peter Dunham
Date: December 22, 2004 09:18AM

I have a database distributed across 2 machines.

Machine A writes to x tables and replicates those statements to B
Machine B writes to y tables and replicates those statements to A

NB. not all tables on A exist on B and vice-versa.

This all works fine, but in the case of problems, if I issue a load data from master on Machine A, it successfully updates the tables from Machine B, but also deletes on the tables on Machine A that are not on Machine B. Not desirable.

I've submitted this as a bug but does anyone know of any workarounds/alternatives.

Thanks

Peter

Options: ReplyQuote


Subject
Views
Written By
Posted
Load data from master drops tables
3962
December 22, 2004 09:18AM
2763
December 22, 2004 10:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.