Replication lagging in VM
Hello,
We have master-slave setup as below:
Master-Physical server
Slave1---Physical server
Slave2---VM
Slave3---VM
We are facing lag issues only on VM slaves. Mysql version is same on both master and slaves. But on VM slaves, we are facing lag. We have checked from storage,OS,Network level but everything seems to be ok.
When we change innodb-flush-log-at-trx-commit from 1 to 0, the lag on VM slaves decreases rapidly. innodb-flush-log-at-trx-commit was set to its original value of 1 right from the begining, only recently we are seeing this issue.
Need help whether above variable is causing any bottleneck.
Subject
Views
Written By
Posted
Replication lagging in VM
1251
February 17, 2016 11:47AM
1100
February 21, 2016 07:03PM
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.