Re: Replication Slave update question
Posted by:
Aftab Khan
Date: August 31, 2012 10:20AM
>What I am wondering is - with autocommit turned off - is the replication slave smart enough to actually do a commit ? Would the commit statement run at the master be part of the log statements being applied ?
Transaction is only written to the binlog when it is complete. So, when you start a transaction on a master database, run update query, and close it. When these events propagate onto replication slave, since MySQL replication (upto 5.5) is a single threaded, it is possible that replication wasn't in sync (i.e Seconds_Behind_Master: > 0) at the time when you ran 'SELECT' to verify the update?
Subject
Views
Written By
Posted
2817
August 30, 2012 12:56PM
1085
August 31, 2012 04:43AM
1076
August 31, 2012 09:02AM
Re: Replication Slave update question
1119
August 31, 2012 10:20AM
1161
August 31, 2012 06:53PM
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.