3

I'm running a simple MySQL replication scenario MASTER ➙ BLACKHOLE ➙ SLAVE, replicating only a number of tables via replicate-do-table on BLACKHOLE and SLAVE. Now I would like to add several more tables (that already exist and filled with data on MASTER) to existing replication, with minimum downtime on MASTER and SLAVE. I have general understanding of steps to undertake in order to have a consistent snapshot (lock master tables, stop replication, dump&source etc), but this process includes 10+ steps and prone to human mistakes, especially if we set up more slaves in future.

Question: is there an easier option to add new table(s) to replication? Like using

mysqldump --master-data ...

and then somehow start replication of a particular table from a certain binlog position?

Thank you.

RolandoMySQLDBA
185k34 gold badges327 silver badges541 bronze badges
asked Oct 19, 2012 at 15:44

1 Answer 1

2

Are you using InnoDB? Xtrabackup will allow you to do "hot" or "online" copies of your running master.

Propagate the backup made via xtrabackup to the slave. There is no need to disrupt the relay (blackhole) server, just add the extra tables to be replicated to the relay server config before you "START SLAVE" on your slave.

answered Nov 28, 2012 at 12:06

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.