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 <eroomy...@gmail.com> 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 <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 >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql