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