RE: step-by-step replication on MySQL 5.1.x

Why a ring? Several possible answers and problems...

Three masters in a ring -- If one dies and cannot be restarted, you have a replication mess that is hard to unravel.

Multi-master (2 or 3) does NOT buy any additional performance in inserts -- all inserts have to go to all machines eventually.

Multi-master has procedural hassles with auto_increment (use offset; don't depend on monotonicity; etc) and other unique keys.

For scaling readonly access, use plain slaves.

Dual-master, with only one writable at a time, provides a high degree of failover / BCP / recovery / etc. But you need slaves also. The machines should be in geographically distinct places (don't want a flood/earthquake to take out your whole system).

> -----Original Message-----
> From: Aslan Carlos [mailto:aslan@digirati.com.br]
> Sent: Wednesday, September 05, 2007 9:13 AM
> To: Rick James
> Cc: replication@lists.mysql.com
> Subject: RE: step-by-step replication on MySQL 5.1.x
>
> I don't know, I want know this.
>
> I'm making a new project. I'll build a configuration of replication in
> circle using MySQL 5.1.x, ( called too as replication ring ).
> There many
> problems to do this configuration.
>
>
> Anyone here are using a replication ring or used one day? Did have any
> problem using this configuration?
>
>
> best regard,
> Aslan Carlos
>
>
>
>
> On Wed, 2007-09-05 at 08:59 -0700, Rick James wrote:
> > Are there any differences? Maybe having to do with
> row-based replication,
> > but that is optional.
> >
> > > -----Original Message-----
> > > From: Aslan Carlos [mailto:aslan@digirati.com.br]
> > > Sent: Monday, September 03, 2007 1:19 PM
> > > To: replication@lists.mysql.com
> > > Subject: step-by-step replication on MySQL 5.1.x
> > >
> > > Hi folks,
> > >
> > > I'm looking for papers that describe step-by-step the
> replication
> > > process in the MySQL version 5.1.x, like was described in the
> > > book 'High
> > > performace MySQL', but there just talks the 3.23 and 4.0.x.
> > >
> > >
> > > thanks in advance.
> > > --
> > > Aslan Carlos de M. Ramos
> > > Senior Network Administrator
> > > K8 Networks, Digirati Networks , Hostnet Web hosting
> > > Phone : +55(21)2233-5950 tie-line:29
> > > Mobile : +55(21)9989-4932
> > > Skype : aslancarlos
> > >
> > >
> >
>

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com