MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: disable trigger in master alone without propagating to slave
Posted by: Peter Brawley
Date: May 19, 2022 10:49AM

MySQL does not (yet?) support ALTER TRIGGER ... ENABLE | DISABLE.

You can create a stored procedure or function which sets & gets a declared variable as desired, and code triggers to call it.

Re replication & triggers, see https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
disable trigger in master alone without propagating to slave
manee mur
May 19, 2022 03:35AM
Re: disable trigger in master alone without propagating to slave
Peter Brawley
May 19, 2022 10:49AM
Re: disable trigger in master alone without propagating to slave
manee mur
May 19, 2022 12:09PM
Re: disable trigger in master alone without propagating to slave
Peter Brawley
May 19, 2022 01:12PM


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.