Multi Master to one slave

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

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:

http://msdn.microsoft.com/en-us/library/ms187577%28v=sql.90%29.aspx

[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!