Hi, Yes, but what about two "masters" doing circular replication with each other and one slave reading from one of the masters. Since all updates/inserts happen on both masters, they also happen on the slave, so in effect you have two masters. I just wish you could do that with three "masters" :)
Thanks, Eric At 10:45 AM 3/12/2004, Ken Menzel wrote: >Not at this time, however you could have two different slaves on the >same physical server using mysql_mutli type of configuration. >http://www.mysql.com/doc/en/mysqld_multi.html > >Hope it helps >Ken >----- Original Message ----- >From: "Ari Davidow" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, March 12, 2004 1:30 PM >Subject: two masters, one slave > > >> Is it possible to have two masters and one slave? I'm trying to >replicate >> two master databases so that I have a failover. >> >> The alternate, I guess, would be to have two instances of mysql >listing on >> different ports on the slave server platform? >> >> ari >> >> Ari Davidow >> [EMAIL PROTECTED] >> http://www.ivritype.com/ >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
