MySQL Forums
Forum List  »  Replication

How to disable replication of create/drop trigger/event
Posted by: Michael Moench
Date: January 06, 2009 07:29AM

Hi, I'm running a master/slave replication. My master has some triggers on tables which are replicated to the slave. The slave is using different triggers on the same tables to do some calculations when the data gets changed on the master.
The problem I'm facing now is that the drop and create trigger command is replicated from the master to the slave each time I change my triggers on the master. Which overwrites the special triggers of the slave.

Is it possible to disable the replication of special SQL-commands like the create/drop trigger command?
I'd also like to disable the replication of create/drop event commands: I don't want the events from my master running on my slave. I've to stop the replication each time I want to change the events/triggers on my master server.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to disable replication of create/drop trigger/event
4501
January 06, 2009 07:29AM


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.