Ubuntu 12.04 mirror setup mysql won't start

Discussion in 'ISPConfig 3 Priority Support' started by dgeho1, Sep 11, 2013.

Thread Status:
Not open for further replies.
  1. dgeho1

    dgeho1 Member

    In working through the ISPCONFIG manual for setting up a two-server mirror on page 49 I hit a snag..

    when I restart the MySQL server module on server 1, I get an error msg "Job Failed to start"

    I'm a relative newbie so please forgive my simplistic questions.

    Thanx

    Dave
     
    dgeho1, Sep 11, 2013
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which debian version do you use?


    [edit] sorry, did not see that you had the os version in the title.

    Which mysql version do you have installed on that server? The mysql version which is used on debian in the manual is < 5.5. If you use mysql 5.5 or newer, then the mysql master/master mirror configuration is different as far as I know as mysql changed the way it is configured.
     
    Last edited: Sep 11, 2013
    till, Sep 11, 2013
    #2
  3. dgeho1

    dgeho1 Member

    mysql version

    Ver 14.14 Distrib 5.5.32, for debian-linux-gnu (i686) using readline 6.2
     
    dgeho1, Sep 11, 2013
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I fear that the current mirror guide will not work with that mysql version. We are working on a updated guide, but it is not finished yet.
     
    till, Sep 11, 2013
    #4
  5. stefanm

    stefanm Member HowtoForge Supporter

    Hi,
    just a hint, this should be easy to fix (did it some days ago).
    The main difference is that MySQL dropped some configuration options from the my.cnf (master_host, master_user,...)

    So instead you need to set this values with a SQL command (and MySQL writes these to a new config file called master.info):

    Code:
    mysql -u root –p
mysql> CHANGE MASTER TO MASTER_HOST='<YOURMASTER>', MASTER_USER='<SLAVE_USER>', MASTER_PASSWORD='<YOURPASSWORD>';
     
    stefanm, Sep 12, 2013
    #5
Thread Status:
Not open for further replies.

Share This Page