Re: Delay in MySQL Replication
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
Subject
Views
Written By
Posted
2494
August 27, 2012 09:58AM
Re: Delay in MySQL Replication
1168
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.