MySQL – Disabling Binary Logging for INSERT and UPDATE
I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…
Read moreMySQL – Best way to speed up Slave replication
The number one thing that you can do to speed up Slave Replication is to set innodb_flush_log_at_trx_commit=0 in your my.cnf file. This will make the transactions less recoverable on your…
Read more