Joey, read this<http://www.percona.com/doc/percona-xtrabackup/howtos/setting_up_replication.html> 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 <eroomy...@gmail.com> > 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 <mjh2...@gmail.com> 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.na...@gmail.com> > > 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 <mjh2...@gmail.com> > > >> > > >> 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