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.
Subject
Views
Written By
Posted
2791
November 11, 2014 08:38AM
1206
November 12, 2014 12:40AM
1333
November 12, 2014 09:19AM
1185
November 12, 2014 03:42PM
1267
November 13, 2014 06:45PM
1140
November 14, 2014 12:59PM
1135
November 15, 2014 10:47AM
1092
November 24, 2014 04:49AM
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.