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 12th May 2010, 11:49
stevegjacobs stevegjacobs is offline
Junior Member
 
Join Date: Sep 2008
Posts: 28
Thanks: 1
Thanked 1 Time in 1 Post
Default Ispconfig3 High availability cluster: mysql problem

Hi
This is my second attempt to set up a high availability cluster with Ispconfig3. What I want is no single point of failure, so I have two separate servers, webserver1 and webserver2, set up with DRBD/Heartbeat.

The first attempt was with Centos, which didn't work out due to problems with mail packages. I have started over with Debian. I have everything working on the Debian install, EXCEPT that when I force a failover, mysql won't start on webserver2.

Here is what I have done:

1. set up webserver1 and webserver2 with drbd/Heartbeat for clustering.
2. Installed all packages and and Ispconfig on each server according to the 'Perfect server tutorial.
3. Moved folders www, vmail, and mysql data folder from webserver1 to the drbd storage area (/mnt/drbd/ on my system)
4. Created appropriate sym links and edited config files on each system to reflect the above changes.
5. Started all services on webserver1, logged into ispconfig, added a website, installed Joomla on the site, added an email address and an extra ip address, and tested all. Everything worked!
6. Forced a failover to webserver 2. Mysql won't start.

The thing is, that when I first tried it on Centos, I did the same thing with everything, including mysql, everything worked except for mail. If I forced a failover, ispconfig, mysql, my websites and ip addresses all moved to webserver2. I gave up on Centos because I couldn't get mail to work on either server.

Would anybody have any suggestions about what to do to get mysql to work?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 12th May 2010, 12:08
mike_p mike_p is offline
Senior Member
 
Join Date: Mar 2010
Location: Surrey, England
Posts: 140
Thanks: 9
Thanked 28 Times in 17 Posts
Default

what information does mysqld.log give?
(On centos its in /var/log - don't know where in your distro)
Reply With Quote
  #3  
Old 12th May 2010, 12:47
stevegjacobs stevegjacobs is offline
Junior Member
 
Join Date: Sep 2008
Posts: 28
Thanks: 1
Thanked 1 Time in 1 Post
 
Default debian does things different

Mysql logs are included in /var/log syslog. Here is the sequence of log entries when I try to start mysql:
May 12 10:43:25 webserver2 mysqld_safe[1565]: started
May 12 10:43:25 webserver2 mysqld[1568]: 100512 10:43:25 InnoDB: Operating system error number 13 in a file operation.
May 12 10:43:25 webserver2 mysqld[1568]: InnoDB: The error means mysqld does not have the access rights to
May 12 10:43:25 webserver2 mysqld[1568]: InnoDB: the directory.
May 12 10:43:25 webserver2 mysqld[1568]: InnoDB: File name ./ibdata1
May 12 10:43:25 webserver2 mysqld[1568]: InnoDB: File operation call: 'open'.
May 12 10:43:25 webserver2 mysqld[1568]: InnoDB: Cannot continue operation.
May 12 10:43:25 webserver2 mysqld_safe[1574]: ended
May 12 10:43:39 webserver2 /etc/init.d/mysql[2128]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 12 10:43:39 webserver2 /etc/init.d/mysql[2128]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 12 10:43:39 webserver2 /etc/init.d/mysql[2128]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 12 10:43:39 webserver2 /etc/init.d/mysql[2128]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I need to compare this to what happens when I restart on webserver1
Reply With Quote
Reply

Bookmarks

Tags
cluster, debian, drbd, ispconfig3, mysql

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
Problems with MySQL Cluster (Help) longvnit Server Operation 2 9th December 2009 18:22
MySQL High Availability FreeBSD Cluster businessgeeks Suggest HOWTO 1 22nd May 2008 12:46
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37


All times are GMT +2. The time now is 23:47.


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