Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 3 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.