I am not sure if this is possible or not but I have 3 servers.
Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has database C_database
Currently Server A and B are in sync perfectly. Now I want to sync the database C_database between server B and Server C.
Server B has this my.cnf
### server-id = 2 log_bin = /var/log/mysql/mysql-bin.log binlog_do_db = A_dataBase binlog-do-db = B_database relay-log = /var/log/mysql/slave-relay.log relay-log-index = /var/log/mysql/slave-relay-log.index #####
This is the command I ran on Server B to set server A up
CHANGE MASTER TO MASTER_HOST = 'serverA_ip', MASTER_USER = 'username', MASTER_PASSWORD = 'userpassword', MASTER_LOG_FILE = 'mysql-bin.000007', MASTER_LOG_POS = 107;
Now my question is how to setup the sync of C_database between server C and B? Keeping in mind that I already have syncing working between A and B