bruce wrote:
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tied back to the Master Server/DB...
However, in looking through various docs, I can only see how to setup a
single Slave connection in the my.cnf file. I can't see how to setup
multiple Slave connections in the Slave Server, to allow it to handle
multiple Masters...
So, my basic question is how/what do I need to do? Can I have multiple
my.cnf files.. Should everything be placed in a single my.cnf file?
I would advise you to set up a slave with CHANGE MASTER TO instead of
configuring it in the slave's my.cnf. It avoids nasty things happening
when the slave is restarted, etc. The server will remember information
about its master in a separate file.
Each slave can have only a single master. Multiple masters are not
possible. (Don't be confused by the terminology: some people say
multi-master replication when they discuss a setup in which two servers
are mutually master and slave. Each slave can have only one master;
co-master or dual-master or whatever you want to call it is not the same
as multi-master).
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
