You're going to need to architect more than just a master-slave relationship to do what you want to do. All replication does is copy commands from one MySQL server to the other; it does not create a failover environment by itself.
Creating a failover environment is beyond the scope of MySQL; you'll need to handle things like fault detection of the master server, redirecting traffic from the master to the slave when a fault occurs, and ensuring that you don't "flap" connections between master and slave (i.e. when you switch over to the slave, you don't switch back to the master without bringing the master back up to date first). You also need to take care of the double failure case and probably many other corner cases I haven't listed. In short, MySQL's failover is *not* a multiple-master replicated database system like Oracle Parallel Server. There's a reason why the latter is so pricey. :-) --Michael > -----Original Message----- > From: Sanya Shaik [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 20, 2003 6:11 AM > To: [EMAIL PROTECTED] > Subject: Re: Mast-Master Replication > > > Well , what I want is the second server to take the place of > the first one in case of any problems with the master without > having to come to a stand still > > Jeremy Zawodny <[EMAIL PROTECTED]> wrote:On Tue, Aug 19, > 2003 at 01:52:26PM -0700, Sanya Shaik wrote: > > I am unable to find any information about master-master > replication. I > > need to replicate 1 mysql server over to other as a standby master > > server. > > If the second server is merely standby, you probably want > master/slave rather than master/master. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) > > > --------------------------------- > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
