Hello Jeetendra,
Jeetendra Mirchandani wrote:
Is it possible to replicate only DML statements? I don't want an
operator error of "drop table" to replicate to the slave
I use 5.0.x
ps: please cc me on the reply
Regards,
Jeetu
There is no good, there is no bad, there's just what happened. Dance with it.
Unfortunately, no. The SLAVE_SQL thread used by replication cannot be
restricted to perform only DML statements.
What some users have organized is script that will intentionally delay a
slave by periodically executing START SLAVE UNTIL... commands to
intentionally keep the slave at least 5,10, 15, or 60 minutes behind the
master. This gives you a window of opportunity to intercept these
commands in the replication stream before they have a chance to take
effect.
This is not a script that MySQL has written so I cannot link you to any
versions of it.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
