Member Avatar for OsaMasw

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='12.34.56.789',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 :(

  • 3 Contributors
  • 2 Replies
  • 191 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Hi, if I'm not wrong you cannot replicate many Masters to one single Slave in MySQL, but you should check MySQL documentation and switch between versions to check if there are any changes: http://dev.mysql.com/doc/refman/5.1/en/replication.html

Note: if you are trying to apply replication in relation to your previous thread on PHP forum about searches on multiple databases, I suggested you about federated tables because it can be used to connect to multiple servers... then you could use a local cache system to temporary save part of the data queried by the clients...

Bye!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.