List:General Discussion« Previous MessageNext Message »
From:Joey L Date:June 6 2012 8:50pm
Subject:Re: multi master auto syncing when servers back on line
View as plain text  
But andrew do you have an answer for me why i am getting this error ?

thanks

On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore <eroomydna@stripped> wrote:
> Joey, sounds like you've got a lot of testing to do before you can deploy
> and support this in production yourself with out fear of shooting yourself
> in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
> from percona.
>
> A
>
>
> On Wed, Jun 6, 2012 at 5:09 AM, Joey L <mjh2000@stripped> wrote:
>>
>> 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
>> >>
>> >
>>
>> --
>> 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