PDA

View Full Version : MySql down and up after the replication function is activated


quannv
31st October 2007, 10:13
I installed ispconfig as Control Panel.
I configured the replication function on MySQL, then I get the following message in each 30 minutes in Master. ( may be from the momit service)

Warning: service mysqld not running (server: xyz.com)!
Message generated at October 31, 2007, 14:30.

Does this message mean working normally?

falko
1st November 2007, 19:38
What's the output of netstat -tap?
Please log in to MySQL:
mysql -u root -p
and run
SHOW SLAVE STATUS;
What's the output?

quannv
2nd November 2007, 06:18
netstat -tap
tcp 0 0 sic-corp.com.vn:mysql *:* LISTEN 25986/mysqld
tcp 0 0 *:81 *:* LISTEN 9902/ispconfig_http
tcp 0 0 *:ftp *:* LISTEN 6685/proftpd: (acce
tcp 0 0 sic-corp.com.vn:domain *:* LISTEN 10062/named
tcp 0 0 localhost:domain *:* LISTEN 10062/named
tcp 0 0 *:smtp *:* LISTEN 7149/master
tcp 0 0 localhost:953 *:* LISTEN 10062/named
tcp 0 0 localhost:35725 localhost:imap2 TIME_WAIT -
tcp 0 0 sic-corp.com.vn:mysql 210.245.87.213:4588 ESTABLISHED25986/mysqld


mysql> SHOW SLAVE STATUS;
Empty set (0.00 sec)

falko
3rd November 2007, 11:17
MySQL isn't listening on all interfaces. What's in your my.cnf?