How to disable replication of create/drop trigger/event
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.
Subject
Views
Written By
Posted
How to disable replication of create/drop trigger/event
4616
January 06, 2009 07:29AM
2346
January 15, 2009 10:40AM
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.