List:General Discussion« Previous MessageNext Message »
From:Joey L Date:June 6 2012 4:13am
Subject:Re: multi master auto syncing when servers back on line
View as plain text  
Claudio thank you for your input. I can see that you have set this up before.
My issue is that my db is getting very big approaching 50G and
performance is being impacted.
I am also very concerned about recovery time - this is production - so
i can have very little recovery time - so what else is new :)
I will look at the site for active-active config - but have you had
any experience with active-active yourself?
what was your solution - i am on a seriously low budget - so any thing
free is great.
thanks
mjh

On Tue, Jun 5, 2012 at 6:42 PM, Claudio Nanni <claudio.nanni@stripped> wrote:
> Joey,
>
> read this 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