Wednesday, August 29, 2018

MySQL replication: most important config parameters for performance on slave server

If your concern is about performance and you don't care about losing a small chunck of data(usually 1 second) in case of server crashes, I would change the follow variables:
A good option is to read this Percona article, it's a general overview to how optimize innodb, it will work for your master and also to your slave.
If you are planning to upgrade to the percona server which implement features from MySQL 5.6, I would recommend that you increase the number of slave sql threads slave-parallel-workers

No comments:

Post a Comment