There are some variables that can affect the replication behavior and
sometimes cause some big troubles. In this post I’m going to talk about
read_buffer_size and how this variable together with max_allowed_packet
can break your replication.
The setup is a master-master replication with the following values:
max_allowed_packet = 32M
read_buffer_size = 100M