Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 3rd January 2011, 10:33
voltron81 voltron81 is offline
Senior Member
 
Join Date: Sep 2009
Posts: 292
Thanks: 1
Thanked 4 Times in 3 Posts
Default Problem with Master-Master MySQL replication of ISPConfig database

Hi to everybody.
I've two mailservers (Debian 5) based on ISPConfig 3.0.1.6.
This systems are twins, and I've realized them using GlusterFS to replicate /var/vmail and a master-master replication of the ISPConfig database to replicate the ISPConfig configuration.
Few days ago I had a crash on one server, and now that it is up and running again, the replication is not working anymore.
To setup that replication, I've followed this how-to: http://www.howtoforge.com/mysql-5-ma...ation-fedora-8
Running in both server the command SHOW SLAVE STATUS I've this situation:
SRV1:
Code:
Slave_IO_Running      Slave_SQL_Running
              YES                    NO
SRV2:
Code:
Slave_IO_Running      Slave_SQL_Running
               NO                     YES
Having a look into the log files, I've this files in /var/log/mysql/
SRV1:
Code:
mysql-bin.000663  mysql-bin.000667  mysql-bin.000671  mysql-bin.000675
mysql-bin.000664  mysql-bin.000668  mysql-bin.000672  mysql-bin.index
mysql-bin.000665  mysql-bin.000669  mysql-bin.000673
mysql-bin.000666  mysql-bin.000670  mysql-bin.000674
SRV2:
Code:
mysql-bin.000495  mysql-bin.000499  mysql-bin.000503  mysql-bin.000507
mysql-bin.000496  mysql-bin.000500  mysql-bin.000504  mysql-bin.index
mysql-bin.000497  mysql-bin.000501  mysql-bin.000505
mysql-bin.000498  mysql-bin.000502  mysql-bin.000506
As far as I can see, it's look like they have lose the syncronization...

Any suggestion?
Thanks
Michele
Reply With Quote
Sponsored Links
  #2  
Old 4th January 2011, 13:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
Default

You will 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
  #3  
Old 5th January 2011, 10:18
voltron81 voltron81 is offline
Senior Member
 
Join Date: Sep 2009
Posts: 292
Thanks: 1
Thanked 4 Times in 3 Posts
Default

Hi Falko,
thanks for your reply.
So you mean that I've to cancel the db of SRV2, make a dump of the database from SRV1 and follow the how-to again?

For the future then: there is a way to avoid this kind of problem?

Thanks
Michele
Reply With Quote
  #4  
Old 5th January 2011, 18:00
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
 
Wink

Quote:
Originally Posted by voltron81 View Post
Hi Falko,
thanks for your reply.
So you mean that I've to cancel the db of SRV2, make a dump of the database from SRV1 and follow the how-to again?

For the future then: there is a way to avoid this kind of problem?

Thanks
Michele
You've used mysql database replication to mirror the db yes?

If you're sure that the database still has the correct data in it you can give the slave the new positions and start it back up again.

I find this tutorial a good guide:

http://www.howtoforge.com/how-to-set...on-ubuntu-9.10
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
Amavis/ClamAv problem MattJo. General 7 20th October 2010 17:18
ISPC 3, powerdns, mysql replication not working. damir General 2 8th July 2010 09:24
Hosting multiple websites and webmail dmwcool Installation/Configuration 8 30th March 2010 03:15
ispconfig creating database problem Dag Andresen Installation/Configuration 5 8th December 2009 11:37
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 10:41.


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