MySQL Forums
Forum List  »  Docs

Re: Replication without deletes and drops
Posted by: Federico Razzoli
Date: October 12, 2004 07:01AM

Logs make possible to exactly recreate a db before a wrong DELETE or DROP.

It is not possible to log all statements except for DROPs or DELETEs. Even theorically. Try thinking the following case:

INSERT INTO a (id, name) VALUES (1, 'george');
DELETE FROM a WHERE id=1;
INSERT INTO a (id, name) VALUES (1, 'bill');

You can't disable DELETE replication but, if you could, the second INSERT would return an error on the slave and data would be different.

Options: ReplyQuote


Subject
Views
Written By
Posted
3934
September 24, 2004 10:42AM
Re: Replication without deletes and drops
2982
October 12, 2004 07:01AM


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.