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.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th April 2012, 17: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?.

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

http://www.howtoforge.com/how-to-rep...ql-replication

There are cases where this doesn't help, and you have to set up replication from scratch again.
__________________
Falko
--
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
Reply

Bookmarks

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 22:34
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Master master Mysql replication with ignore table wxman HOWTO-Related Questions 2 5th May 2009 22:25
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11


All times are GMT +2. The time now is 09:49.


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