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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
2
  • I didn't think so. But the cron job is a great idea. I'll have to see what I can do with that. Commented Oct 4, 2012 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" Commented Oct 4, 2012 at 17:20

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.