Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 29th April 2012, 18:39
dghvoip dghvoip is offline
Junior Member
Join Date: Apr 2012
Posts: 7
Thanks: 2
Thanked 1 Time in 1 Post
Default MySQL master to master replication

Hi, I setup two servers in master to master replication but I'd like to know how if anything goes wrong in replication for some reason what should I do, should I restart fro the begginning deleting all databases on the seconda master or can I just use CHANGE MASTER TO ... stanza and use the LOG_POSITION= to what the SHOW MASTER STATUS; on server one and restart the slave.

The concise question is how do I resync the servers if replication breaks?.

Reply With Quote
Sponsored Links
Old 30th April 2012, 11:48
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts


There are cases where this doesn't help, and you have to set up replication from scratch again.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Master MySQL Data Base replication issue On Debian Squeeze Linox91 Installation/Configuration 1 12th January 2012 23:34
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Master master Mysql replication with ignore table wxman HOWTO-Related Questions 2 5th May 2009 23:25
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11

All times are GMT +2. The time now is 17:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.