MySQL Forums
Forum List  »  Replication

Parallel replication performance
Posted by: Magnus Jäverberg
Date: October 29, 2015 09:48AM

Hi!

I use row based replication, and in some (rather rare) circumstances the slave lags behind. Since I use a mechanical disk and the cpu load is low I assume that the disk is the bottleneck.

However, when enabling parallel replication the performance doubled. This surprised me, and seems to indicates that mysql didn’t manage to fully utilize the disk with one thread. Can anyone help me shed some light on this?

/Magnus Jäverberg

Options: ReplyQuote


Subject
Views
Written By
Posted
Parallel replication performance
1550
October 29, 2015 09:48AM
872
October 30, 2015 02:37PM
854
November 26, 2015 09:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.