I have a question about MySQL replication: can I set the slave DBs to only poll the master DB for information once every 10 seconds?
Our MySQL master DB is under fairly heavy load. By default, MySQL replicates in almost real time, which means that each slave DB is polling the master DB for changes many times in one second. I don't want the master DB to be bogged down by the update / delete load as well as the constant requests of slaves to get the latest changes.
In our situation, we don't need the slave DB to be synced in real-time to the master. The slaves can each afford to be 10 seconds behind the master and the clients who are using the slave DBs won't even notice. Is there a way I can set the slaves to poll the master every 10 seconds instead of in real-time?
Note: setting the MASTER_DELAY=N setting will not work
The MASTER_DELAY setting tells the slave to intentionally stay N seconds behind the master. However, it doesn't affect how often the slave polls the master for changes. In my case, setting the MASTER_DELAY setting won't do any good bc I want the slaves to poll the master less, not more.