Replication for backup

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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Replication for backup

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/mysql?unsub=gcdmg-mysql-2@m.gmane.org