MySQL5 Repliction seconds slower

MySQL & MariaDB Other MySQL® Questions
1

Hi there,

I have two high end servers configured with MySQL5 and server A replicates to server B. Both servers are used for read-queries.

Now we discovered that most of the time the replication is around 2 á 4 secs behind the master. So when a query is insert on server A, it takes almost 4 secs to replicate to server B.

Is there any way to speed up the replication?!

Thanks~!
Onno.

2

Are both servers configured identically? Same number of spindles, same amount of RAM, same CPUs, same, indeces, same (roughly) mysql config, etc, and no non-mysql workload on the mirror?

Is the mirror handling more reads than the master?

3

Dear MWallace,

Both servers are completely identical. There is no non-mysql workload on the mirror and the configs are the same.

As attachement I added the ‘show status’ from both hosts.

Thanks!

4

Hm. Could you please also send the results of:
show slave status\G
show variables;
iostat 5 (for maybe 5 iterations)
free
ps -ef

for each server?

5

Dear mwallace,

Sorry for the late reaction, but I attached the two stats of both servers. I kinda isolated the problem. It seems to be cause by the reads on the second server. I think it has something to do with locking. Because when we redirect all queries to db01, replication is better.

Thanks for your time again.
Onno.