Re: How to make Mysql Replication faster
Posted by:
Rick James
Date: November 13, 2014 06:45PM
Let's discuss _your_ "triggers" further. What are they doing? Do you need triggers on the Master? Or on the Slave? Or both? If both, are they the same trigger?
"Normal" trigger usage is to do the trigger only on the Master, and have the _effect_ of the trigger propagated to the Slave. That works nicely with either SBR (if you don't install the trigger on the Slave), or RBR (in which case the trigger won't fire on the Slave).
Galera sort of does not have the Master/Slave concept, except that every node is both.
Galera must use RBR. Certain DDLs (ALTER) are done via a SBR-like mechanism.
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
Re: How to make Mysql Replication faster
1267
November 13, 2014 06:45PM
1140
November 14, 2014 12:59PM
1135
November 15, 2014 10:47AM
1092
November 24, 2014 04:49AM
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.