"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
