MySQL Forums
Forum List  »  Replication

Re: is it possible replicate with mysql5..5
Posted by: Rick James
Date: July 02, 2011 11:32PM

> If you remmember me, i am who was discussed about DeadLock in transactions, a weak ago. Do slave garantee write all updates, or it is possible to loss some data?
Since no one else is writing, it _should_ be possible to abort (ROLLBACK?) the SELECT that conflicts with a transaction that comes through Replication. I can't be more definite than that.

Semi-sync? A simple web search came up with
http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
That, and related pages, should be the definitive explanation. (I have not done it myself; I see it as a half-solution.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: is it possible replicate with mysql5..5
787
July 02, 2011 11:32PM


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.