dear all, I need your direction about archiving mysql data.
the scenario is: mysql on host A with dbname DB1 has the INSERT 90% and select 10% activities. mysql on host B with dbname DB2 as an archiver database of DB1 database. on DB1 the data will be purged daily on midnight. I need all the data is transferred to DB2 (my be with replication) but don't want transfer DELETE & DROP statement into it. I heard about mk-archiver, but it seem not good from the performance perspective. Is there a way to archive the data by utilizing replication with DML (DELETE) and DDL (DROP) filtered? -- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]