MySQL Forums
Forum List  »  Quality Assurance

Re: Delay in MySQL Replication
Posted by: Scott Nemes
Date: August 27, 2012 11:27AM

Your best bet will be to try setting the innodb_flush_log_at_trx_commmit setting on the slave to either 2 or 0 (http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit). Make sure to read the information in the manual prior to changing that setting as it is then possible to lose about a second of data during MySQL / OS failure depending on what you set it to. But since this is on a slave, that is likely acceptable.

Also verify that sync_binlog is set to 0 (the default) on your slave (http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_sync_binlog).

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Views
Written By
Posted
2262
August 27, 2012 09:58AM
Re: Delay in MySQL Replication
1146
August 27, 2012 11:27AM


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.