MySQL Forums
Forum List  »  Replication

Re: How to make Mysql Replication faster
Posted by: Rick James
Date: November 26, 2014 11:07AM

> -- Have you looked at Engine=Blackhole in a relay? That _may_ give you another place to apply the trigger(s).
> Engine=Blackhole , means slave side table's engine=blackhole ? no we required data on slave.

No, I mean adding a "Relay" between the Master and the Slave:
Master --> Relay (with Blackhole) --> Slave (with real engine)
Blackhole is extremely lightweight since it does not store anything, but it will pass it on to anything that is a Slave to it. And it will execute Triggers.
I suspect you could have SBR in the first link and RBR in the second.

> We dont want to block/slow-down any insert on master so we are not doing any manipulation activity on master so...

But you are willing to slow down the Slave? Maybe even to the point of not being able to keep up?

There is no free lunch. I think you need to figure out how to speed things up on the Master. Would you like to discuss the details of what you are doing, including the activity on the Master and in the Triggers.

Options: ReplyQuote


Subject
Views
Written By
Posted
1333
November 12, 2014 09:19AM
1267
November 13, 2014 06:45PM
1135
November 15, 2014 10:47AM
Re: How to make Mysql Replication faster
1120
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.