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
| Thread |
|---|
| • Replication for backup | Jeetendra Mirchandani | 21 Feb 2010 |
| • Re: Replication for backup | Shawn Green | 2 Mar 2010 |
