The Ultimate Guide to High Availability with MariaDB

Comments - MariaDB Replication: trigger not executed in slave table if master table contains any triggers

5 years, 4 months ago Andrei Elkin
Re: MariaDB Replication: trigger not executed in slave table if master table contains any triggers [Answer]

None of the slave triggers get executed unless I drop the original delete trigger in master. If master table does not contain any triggers then the slave-only triggers work just fine.

Sorry, I could not get the meaning. Do you mean that when you tried creating a trigger on the slave this sort of error happened?

ERROR 1235 (42000): This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table'

As to enable on slave only some of the triggers, like in your use case those that are only define for the slave side, the answer is NO.

Feel free to suggest a feature request on Jira and also describe in details suspiciously looking 'None of the slave triggers get executed unless I drop the original delete trigger in master'.

Thank you for your questions!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.