Re: I am trying to setup a multi master mysql setup.

thanks - i had to reset the whole db and the error went away - do not know what i did wrong. thanks On Tue, Jun 5, 2012 at 3:35 PM, Andrew Moore wrote: > Joey, please consult your mysql error log. Something has gone wrong on your > server where innodb is not started. > > On Tue, Jun 5, 2012 at 3:

Re: multi master auto syncing when servers back on line

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 n

Re: multi master auto syncing when servers back on line

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 res

Re: multi master auto syncing when servers back on line

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 Acti

Re: multi master auto syncing when servers back on line

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 a

Re: multi master auto syncing when servers back on line

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 wrote: > Joey, > > from what I can see from your email you lack of a lot

Re: multi master auto syncing when servers back on line

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 > Hi - > I have setup mysql mult master setup on

multi master auto syncing when servers back on line

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

Re: I am trying to setup a multi master mysql setup.

Joey, please consult your mysql error log. Something has gone wrong on your server where innodb is not started. On Tue, Jun 5, 2012 at 3:53 PM, Joey L wrote: > I am following or trying to follow this document: > http://www.howtoforge.com/mysql5_master_master_replication_debian_etch > > I think i

I am trying to setup a multi master mysql setup.

I am following or trying to follow this document: http://www.howtoforge.com/mysql5_master_master_replication_debian_etch I think it is running in a good state because when i query the show slave state, I get awaiting connection from host, like : on server1: mysql> SHOW MASTER STATUS; +--