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
my.cnf on slave.
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?