Re: multi master auto syncing when servers back on line

Can you tell me what permissions are needed for the user to run these utilities so i can sync the tables ? I have only assigned them replication slave right. thanks On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore wrote: > Joey, sounds like you've got a lot of testing to do before you can deploy > a

Re: multi master auto syncing when servers back on line

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 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.

Re: multi master auto syncing when servers back on line

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 wrote: > My cu

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