Droping a table on the master, but keeping it on the slave
Posted by:
Imri Zvik
Date: December 14, 2005 05:10AM
Hi!
I have a syslog server that logs into a local MySQL server (Server A), and another machine with a MySQL server (Server B), that replicates from the syslog's MySQL server.
now, I am logging to tables with the following naming format: syslog-<DATE>.
I want each day, to drop yesterday's table from the syslog server (Master Server A), but keep it on the slave (Server B).
Is there a way to tell the slave to ignore specific commands (such as DROP TABLE)?
Subject
Views
Written By
Posted
Droping a table on the master, but keeping it on the slave
2381
December 14, 2005 05:10AM
1468
December 14, 2005 05:30AM
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.