On Nov 14, 2007 3:40 PM, bruce <[EMAIL PROTECTED]> 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? > > Any thoughts/pointers/comments would be helpful!! > > thanks > > >
Typically, each slave is configured to follow only a single master.. mutli-mastering is possible, but it highly complex and not for beginners .. you really have to know your way around replication before planning something like that... There are reservations among the pros as to just how advisable it is. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
