Multiple Master to one Slave for MySQL Replication
hi guys,
i have been testing out replication for mysql, got master-slave to work. I've also got master-master to work (2 nodes, both are master to each other, slave to each other too). This allows me to quickly use the 2nd machine as main db machine and yet populate changes to the original "master"
anyway, I am trying to find examples/guides of setting multi-master db to one slave.
Meaning, say:
I have 2 dB servers, each having their unique databases.
I have one super machine earmarked as slave. I want to use this super machine to be slave to both master dB, to host all their databases.
How do I do that?
|