"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
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,