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?!