Re: Replication on one slave and two different masters

2003-12-11 Thread John Leach
"MySQL only supports one master and many slaves. Later we will add a voting algorithm to automatically change master if something goes wrong with the current master. We will also introduce ``agent'' processes to help do load balancing by sending SELECT queries to different slaves." http://www.mysq

Replication on one slave and two different masters

2003-12-10 Thread Lopez David E-r9374c
mysql, query I have a situation come up where we want one slave to act as backup for two different databases located in two different hosts. Can this be done? The master setup is easy. The slave setup is unclear. Can I have two sets of master-host, master-user, and master-password, master-port,