0

I have One Mysql master server and Slave server running on ec2. The replication is working fine. Now I need to make some changes. I need to add new slave server to the current replication loop.

Is it possible to add new tables and database which is not existing on master server on newly created slave.

Is this affect master server ? or broke the replication ?

We are not using this slave server for fail-over. Need to analyses live data and store to another database.

Server version: 5.5.48 MySQL Community Server

1 Answer 1

0

If you're not planning to switch master and you're sure the tables / databases are never going to exist in the master, you can have them without breaking replication. I have a setup like that running for some years now and working just fine.

1
  • I'm creating new slave server from existing slave server's image and planning to add database to new slave which doesn't existing on master, no making any change on master. I want make sure it will affect master server/db crash.
    – adminz
    Jul 13, 2017 at 21:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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