Is there a way to setup MySQL replication so that CREATE TABLE and ALTER TABLE statements get replicated but INSERT, DELETE and UPDATE statements do not?

I've got replication working fine and have several tables that are ignored as per the requirements. But we have a requirement that the slaves have an empty copy of the ignored table. We create those empty copies before we start replicating. Since the table is ignored, table structure changes don't get passed down from the master to the slave's empty copy.

I know it's a strange requirement.


i'm afraid you cannot get it done with the built-in mysql replication.

but.. you can still use it and have some cron job that finds alter-statements in the master's binlog and applies them to the slave.

  • I didn't think so. But the cron job is a great idea. I'll have to see what I can do with that. – Ed Manet Oct 4 '12 at 17:14
  • use mysqlbinlog to parse the last logs; 'wite down' name of last parsed file and at the beginning of your cron script force creation of a new log by running "flush logs" – pQd Oct 4 '12 at 17:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.