List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 5 2012 10:18pm
Subject:Re: multi master auto syncing when servers back on line
View as plain text  
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
>
>

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