MySQL Forums
Forum List  »  Replication

How to make Mysql Replication faster
Posted by: Sunil Divyeshvar
Date: November 11, 2014 08:38AM

Hello,

Please suggest is there any other way through with i can make mysql replication faster ?

-- I am working on very heavy transactional system, on master we are executing lots of queries through multiple thread so our slave server always lag behind.

-- I am facing lot issues on production servers due to slave lag behind and i also searching for some good alternatives of mysql single thread replication.

-- I know about the parallel thread(slave parallel workers in Mysql-5.6) of replication but as all the tables are in one schema we are not able to get the benefit of that variable.


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
How to make Mysql Replication faster
2792
November 11, 2014 08:38AM
1337
November 12, 2014 09:19AM
1268
November 13, 2014 06:45PM
1138
November 15, 2014 10:47AM
1121
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.