0

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.

Ed Manet
  • 532
  • 1
  • 5
  • 17

1 Answers1

1

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.

pQd
  • 29,981
  • 6
  • 66
  • 109
  • 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 04 '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 04 '12 at 17:20