Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I already have replication set up for, say, dbname. I want to add a new replicated table. I created the tables on both master and slave. I entered replicate-do-table=dbname.tablename to my.cnf on slave.

To reload my.cnf the server needs to be restarted, and since lots of queries are coming I don't want to lose any of them.

Is there a way that I can add a new table to be replicated on the fly?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

No, there is no way that you can add tables to replication on the fly.

You can read it in the docs:

Others, such as the --replicate-* options, can be set only when the slave server starts.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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