Author: Bobby Language: text
Description: MySQL Replication Woes Timestamp: 2018-01-11 14:02:34 -0500
View raw paste Reply
  1. I have a quick MySQL question here. Basically I've setup a standard Master-Slave replication. Then form my web-server I'm sending all 'writes' to the Master and all of the 'reads' to the Slave in order to distribute the load.
  2.  
  3. The problem is that during some larger deletes on the master, the tables on the slave get locked and the slave lag goes through the roof.. During this time all of my selects that have been sent to the slave are just sitting there and waiting for the table to unlock while the master is just fine.
  4.  
  5. This basically locks out my whole web application.
  6.  
  7. My main guess here would be to switch to InnoDB but I was wondering if you have any other suggestions that I could implement.
  8.  
  9. Thanks again for the great show!
View raw paste Reply