Each slave can only have one master. If you want to have one box be a
slave to multiple masters, you have to set up a mysqld for each master
on the slave box, each with a different port and socket.
Now, if this is on Linux, you also can't have the multiple servers share
data on this one box, si
It can be done. The slave server needs to hold mutiple slave databases corresponding
to the masters. Each slave instance needs to be start separately. For example, each
database wil need it's own my.cnf file holding with port the master is connecting to.
I have seen this done with full dat
query
Is it possible to set one SLAVE to handle two or multiple MASTERS???
For example if I want to replicate one table from one MASTER and
second table from another.
Thanx a lot
-
Before posting, please check:
http://www.my
