Hi buddies how are you, now am using replication for mysql database from one server to other
Master-slave replication, using this article https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql
but this not satisfied my needs, I have multiple server and all their databased replication to single slave server
to be more accurate, I have servers A, B ,C I want to replicate their databses to server D
from which I learned the command to select the master server is by:
CHANGE MASTER TO MASTER_HOST='126.96.36.1999',MASTER_USER='slave_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS= 107;
how it possible to select multiple masters ?
am thinking of create a series of master slave replications, from A to B to D / C to B to D But I think I will get lost :D, hope i get the answers from you :(