We have 2 servers at a remote data center with mySQL databases and have another single server locally. So that we can maintain "real time" working copies (back-ups) of the mySQL databases, we would like to configure the remote mySQL instances as masters and have the single server, which can communicate with the remote servers via our WAN, act as a "slave" for both mySQL instances. Is this possible? I have been told that we need 2 separate servers locally to act as slaves and that we cannot have both mySQL slave instances on the same server. Is this correct?


Thanks in advance