MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: How to make Mysql Replication faster
Posted by: Rick James
Date: November 12, 2014 09:19AM

> slave parallel workers in Mysql-5.6

Yeah, that is a drawback of Oracle's parallel slave threads. Their "group commit" helps some. RBR (Row Based Replication) may be better than SBR.

MariaDB does the parallel workers differently. Galera is possibly the best.

Galera can be added on to MySQL, or you can get it built into Percona XtraDB Cluster or MariaDB 10.

Galera allows writing to multiple masters, but keeps the drawbacks of such under control. Etc. Etc.

Go with Galera. Here are the minor issues you need to know in the code:
http://mysql.rjweb.org/doc.php/galera

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to make Mysql Replication faster
2792
Sunil Divyeshvar
November 11, 2014 08:38AM
Re: How to make Mysql Replication faster
1207
Sunil Divyeshvar
November 12, 2014 12:40AM
Re: How to make Mysql Replication faster
1334
Rick James
November 12, 2014 09:19AM
Re: How to make Mysql Replication faster
1187
Sunil Divyeshvar
November 12, 2014 03:42PM
Re: How to make Mysql Replication faster
1268
Rick James
November 13, 2014 06:45PM
Re: How to make Mysql Replication faster
1141
Sunil Divyeshvar
November 14, 2014 12:59PM
Re: How to make Mysql Replication faster
1138
Rick James
November 15, 2014 10:47AM
Re: How to make Mysql Replication faster
1093
Sunil Divyeshvar
November 24, 2014 04:49AM
Re: How to make Mysql Replication faster
1121
Rick James
November 26, 2014 11:07AM


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.