GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

MySQL5 Repliction seconds slower

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL5 Repliction seconds slower

    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?

    Comment


    • #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!

      Comment


      • #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?

        Comment


        • #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.

          Comment

          Working...
          X