List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 5 2012 10:42pm
Subject:Re: multi master auto syncing when servers back on line
View as plain text  
Joey,

read
this<http://www.percona.com/doc/percona-xtrabackup/howtos/setting_up_replication.html>
to
setup the second instance with no o little service disruption.

then be aware that you have basically two options for Multimaster
replication with two nodes, Active-Passive and Active-Active

Active-Passive can be used for:

-Having a stand by Master using a failover loadbalancer (using only one
active at a time)

Avoid by all means Active-Active unless you have a great team of developers

Claudio

2012/6/6 Andrew Moore <eroomydna@stripped>

> Joey,
>
> The master master replication topology comes with it's own potential
> pitfalls and trials. Be sure your use case needs master master and that
> you're not implementing it because you think it's 'nice to have'.
>
> pt-table-sync should assist you getting your data in sync but how have you
> arrived at this out-of-sync predicament you find yourself in?
>
> A
>
>
>
> On Tue, Jun 5, 2012 at 11:03 PM, Joey L <mjh2000@stripped> wrote:
>
> > with all do respect - I am new to this - i did read the docs and
> > having a hard time.
> > I also was asking if you know something easier or does the trick as
> > this utility does.
> > thanks
> >
> > On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni <claudio.nanni@stripped>
> > wrote:
> > > Joey,
> > >
> > > from what I can see from your email you lack of a lot of basics and I
> > > suggest you to read some documentation before proceeding.
> > >
> > > Maatkit is now Percona Toolkit and contains some of the best tools for
> > > MySQL.
> > >
> > > Cheers
> > >
> > > Claudio
> > >
> > > 2012/6/5 Joey L <mjh2000@stripped>
> > >>
> > >> Hi -
> > >> I have setup mysql mult master setup on debian squeeze.
> > >> I have realized that the databases have to be initially in sync before
> > >> multi master can operate properly.
> > >>
> > >> This can require a lot of down time on the one functioning server.
> > >> Is there a way to do an automatic sync from the 1 server that is still
> > >> running ??
> > >>
> > >> I have found a tool dpkg package called Maakit , but having trouble
> > >> running it - get this error on the master:
> > >>
> > >>  mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
> > >> mailserver 192.168.1.11
> > >> DBI
> > >>
> connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
> > >> failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
> > >> password: YES) at /usr/bin/mk-table-sync line 1284
> > >>
> > >> can anyone assist with the error ?
> > >> Or can someone tell me of a better opensource tool to use to sync the
> > >> servers without a mysql dump ? my db is rather large.
> > >>
> > >> thanks
> > >>
> > >> --
> > >> MySQL General Mailing List
> > >> For list archives: http://lists.mysql.com/mysql
> > >> To unsubscribe:    http://lists.mysql.com/mysql
> > >>
> > >
> > >
> > >
> > > --
> > > Claudio
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
> >
> >
>



-- 
Claudio

Thread
multi master auto syncing when servers back on lineJoey L5 Jun
  • Re: multi master auto syncing when servers back on lineClaudio Nanni5 Jun
    • Re: multi master auto syncing when servers back on lineJoey L5 Jun
      • Re: multi master auto syncing when servers back on lineAndrew Moore5 Jun
        • Re: multi master auto syncing when servers back on lineClaudio Nanni5 Jun
          • Re: multi master auto syncing when servers back on lineJoey L6 Jun
        • Re: multi master auto syncing when servers back on lineJoey L6 Jun
          • Re: multi master auto syncing when servers back on lineAndrew Moore6 Jun
            • Re: multi master auto syncing when servers back on lineJoey L6 Jun
            • Re: multi master auto syncing when servers back on lineJoey L6 Jun