Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

MySQL5 Repliction seconds slower

onnoonno EntrantInactive User Role Beginner
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.

Comments

  • mwallacemwallace Contributor Inactive User Role Beginner
    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?
  • onnoonno Entrant Inactive User Role Beginner
    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!
  • mwallacemwallace Contributor Inactive User Role Beginner
    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?
  • onnoonno Entrant Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.