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 :(

Recommended Answers

how it possible to select multiple masters ?

It's alot of work. This is not something people have at home and used daily.

You can look at these:

http://www.mssqltips.com/sqlservertip/2445/sql-server-multi-server-administration/

and this:

Jump to Post

All 2 Replies

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.