Re: How fast is replication?
Not to mention, the time it takes to perform the SQL statement on the slave. This is especially true for innodb, and updates in particular. We have numerous episodes where the slave is 30 minutes or more behind the master. Even though the slave has read all of the master's binary log information, and stored them locally in the relay logs, the server still has to apply those transactions. The problem really shows when there are queries running against the slave as well, and that's when the updates slow down.
Partha Dutta
partha.dutta@gmail.com
Subject
Views
Written By
Posted
2145
March 18, 2006 09:43PM
1508
March 19, 2006 07:26PM
1477
March 20, 2006 03:28AM
Re: How fast is replication?
1356
March 21, 2006 07:58AM
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.