Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kylesbigdog
Starting Member
2 Posts |
 Posted - 2009-11-04 : 14:47:23
|
| 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kylesbigdog
Starting Member
2 Posts |
Posted - 2009-11-04 : 15:11:41
|
| Thanks. |
 |
|
|
|
|
|
mySQL Master Slave configuration