MySql down and up after the replication function is activated

Discussion in 'Server Operation' started by quannv, Oct 31, 2007.

  1. quannv

    quannv New Member

    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?
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    netstat -tap
    ?
    Please log in to MySQL:
    Code:
    mysql -u root -p
    and run
    Code:
    SHOW SLAVE STATUS;
    What's the output?
     
  3. quannv

    quannv New Member

    netstat -tap
    Code:
    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
    
    Code:
    mysql> SHOW SLAVE STATUS;
    Empty set (0.00 sec)
    
     
  4. falko

    falko Super Moderator Howtoforge Staff

    MySQL isn't listening on all interfaces. What's in your my.cnf?
     

Share This Page