List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:September 25 2012 5:06am
Subject:Re: Doubt Regd. Circular Replication In Mysql
View as plain text  
Agreed with your point Rick, right now i am maintaining my datadir &
logging in my EBS volumes so if any of the instance goes down ,we will
launch new instance & use the existing EBS volumes and start replication
again.

I think it will start automatically from the point where it goes down and
start replicating again.

Can we use any other prevention for automating the failover.

Thanks

On Tue, Sep 25, 2012 at 12:41 AM, Rick James <rjames@stripped> wrote:

> Don't use circular replication with more than 2 servers.  If one of your 3
> crashes and cannot be recovered, you will have a nightmare on your hands to
> fix the broken replication.
>
> > -----Original Message-----
> > From: Stillman, Benjamin [mailto:BStillman@stripped]
> > Sent: Monday, September 24, 2012 11:56 AM
> > To: Shawn Green
> > Cc: mysql@stripped
> > Subject: Re: Doubt Regd. Circular Replication In Mysql
> >
> > I stand corrected and apologize. Numerous multi-master setup
> > descriptions I've read have said to set this (including the one linked
> > in the original question). However, as you said, the entry in the
> > manual clearly says it defaults to 0. Learn something new every day.
> > Thanks Shawn.
> >
> >
> >
> > On Sep 24, 2012, at 2:05 PM, "Shawn Green" <shawn.l.green@stripped>
> > wrote:
> >
> > > replicate-same-server-id = 0
> >
> > ________________________________
> >
> > Notice: This communication may contain privileged and/or confidential
> > information. If you are not the intended recipient, please notify the
> > sender by email, and immediately delete the message and any attachments
> > without copying or disclosing them. LBI may, for any reason, intercept,
> > access, use, and disclose any information that is communicated by or
> > through, or which is stored on, its networks, applications, services,
> > and devices.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
Doubt Regd. Circular Replication In MysqlAdarsh Sharma24 Sep
  • RE: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
RE: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
  • Re: Doubt Regd. Circular Replication In MysqlShawn Green24 Sep
    • Re: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
      • RE: Doubt Regd. Circular Replication In MysqlRick James24 Sep
        • Re: Doubt Regd. Circular Replication In MysqlAdarsh Sharma25 Sep