MySQL Forums
Forum List  »  Replication

Is ROW replication format optimized to skip duplicated rows in the log?
Posted by: Marc Canaleta
Date: October 31, 2012 10:13AM

Hi,

Our application has only one table that contains a user_id as a primary key, and a blob object with its data. Rows are updated frequently. If we use statement replication, the slave will not catch the primary because of the heavy load.

I am wondering if using row replication will be better. The question is: Does ROW replication skip duplicated rows in the log? So if the slave is 5 minutes behind the master, and during that 5 minutes there are 20 updates to the same row, will the slave skip 19 updates and apply only the last one?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Is ROW replication format optimized to skip duplicated rows in the log?
1778
October 31, 2012 10:13AM


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.