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