MySQL Forums
Forum List  »  Replication

Re: conflict resolution
Posted by: Aftab Khan
Date: June 30, 2012 10:44AM

"Conflict resolution" - XtraDB Percona Cluster - it supports “virtually synchronous replication”, not real “synchronous replication”. This means updates may commit on master earlier than on slave host; And if you do read from the slave, you may read data, that has not changes yet. However, such reads can be blocked until slave is back insync with master by using variable wsrep_causal_reads=ON.
if you plan to use Multi-Master capabilities of XtraDB Cluster, and run write transactions on several nodes, you may need to make sure you handle response on “COMMIT” query.

NDB cluster- conflict resoultion, the technique as James has mentioned, applicable in the case of MySQL cluster replication, see
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-conflict-resolution.html

Options: ReplyQuote


Subject
Views
Written By
Posted
2358
June 25, 2012 08:31AM
935
June 29, 2012 08:08AM
886
July 01, 2012 02:55AM
978
June 29, 2012 08:31AM
1398
June 30, 2012 09:40AM
Re: conflict resolution
1172
June 30, 2012 10:44AM


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.