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