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