MySQL Forums
Forum List  »  Replication

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.

Options: ReplyQuote


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