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.mysql.com/doc/en/Replication_Features.html
On Wed, 2003-12-10 at 22:21, Lopez David E-r9374c wrote:
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, master-connect-retry,
w/o the mysqld getting confused?
My experience is one slave, one master. No FAQ covers
multiples master on one slave that I can find.
I'm running mysql version 3.23.49 on Solaris.
--
http://www.johnleach.co.uk
signature.asc
Description: This is a digitally signed message part