List:General Discussion« Previous MessageNext Message »
From:Joey L Date:June 6 2012 4:09am
Subject:Re: multi master auto syncing when servers back on line
View as plain text  
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records) and
then i tried to update the "master" server - and only seen the records
that I updated and not the records that were additional to the other
server when I first restored.

I am just trying different scenerios before i put this in production.
I was looking to do load balancing and i am concerned about high-availablitity.
Is there a product that is opensource out there that I can use to
maintian a master master setup with ease ?


thanks
mjh

On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore <eroomydna@stripped> wrote:
> 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