start: Job failed to start

Discussion in 'Installation/Configuration' started by millpark10, Dec 16, 2013.

  1. millpark10

    millpark10 Member

    Edited!
    Hi

    Mirror setup, using "Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3"

    Seems to be a known issue due to change in MYSQL-version. //Edit wrote php-version before, should be mysql-version)
    I read the threads
    http://www.howtoforge.com/forums/showthread.php?t=63205&highlight=start: Job failed start
    http://www.howtoforge.com/forums/showthread.php?t=63198&highlight=start: Job failed start
    http://www.howtoforge.com/forums/showthread.php?t=62473&highlight=start: Job failed start&page=4

    Understand I have to somehow invoke:
    CHANGE MASTER TO MASTER_HOST='master', MASTER_USER='slave_user00', MASTER_PASSWORD='some_password' (...)

    Sorry to be a newbie, but where is this supposed to be entered.
    >MySql IS actually running but I could not login with "mysql -u root -p"
    >On the other hand "mysql -h localhost -u root -p" did work.
    (it can't be a sql-command. And also, Is this sulotion forever, will it stick even after a restart.) it obviously is, my mistake.

    >now I have commented out
    >#master-host = 172.17.2.182
    >#master-user = slaveuser
    >#master-password = password
    >#master-connect-retry = 60

    >Suddenly after several mysql restarts it is possible to login with "mysql -u root -p" so i did
    >"mysql> CHANGE MASTER TO MASTER_HOST='slaveIP-address', MASTER_USER='slaveuser', MASTER_PASSWORD='mystrongpassword' "

    Now I am not sure how to proceed from here. I
    Can't find out what to do. Start over from beginning with a new install following the same "howto", will produce same problem, or?

    //millpark10
     
    Last edited: Dec 16, 2013
  2. millpark10

    millpark10 Member

    [solved]

    Hi
    Some instructions in the perfect server setup referred to is not applicable due to change in mysql-version!

    This worked for me:
    Server1
    The change in /etc/mysql/my.cnf comment out:
    #bind-address = 127.0.0.1
    For server 1 add lines:
    server-id = 1
    replicate-same-server-id = 0
    auto-increment-increment = 2
    auto-increment-offset = 1
    log_bin = /var/log/mysql/mysql-bin.log
    Change from 100M to 500M:
    max_binlog_size = 500M

    server 2:
    The change in /etc/mysql/my.cnf comment out:
    #bind-address = 127.0.0.1
    For server 2 add lines:
    server-id = 2
    replicate-same-server-id = 0
    auto-increment-increment = 2
    auto-increment-offset = 2
    log_bin = /var/log/mysql/mysql-bin.log
    Change from 100M to 500M:
    max_binlog_size = 500M

    Following
    The additions in /etc/mysql/my.cnf:
    master-host = 172.17.2.182
    master-user = slaveuser
    master-password = password
    master-connect-retry = 60
    will not work in 5.5.34 (the version I have)

    Instead these shall be invoked as mysql-command,
    login to mysql
    mysql -u root –p
    mysql> CHANGE MASTER TO MASTER_HOST='172.17.2.181', MASTER_USER='slave_user', MASTER_PASSWORD='mystrongpassword';
    mysql> FLUSH PRIVILEGES;
    mysql> quit;

    This was a bit confusing before I understood it and got it to work. In the process to find out how to do this the problems and errors in previous post showed up. I also managed to destroy the mysql installation (changed privileges etc).
    I completely removed it an reinstalled it, then followed my revised setup as above.

    To remove mysql completely from your system:
    sudo apt-get remove --purge mysql-server mysql-client mysql-common
    sudo apt-get autoremove
    sudo apt-get autoclean

    Long post and maybe not completely understandable, sorry for that. I'm obviously a newbie trying to follow descriptions.

    //millpark10
     
    Last edited: Dec 20, 2013

Share This Page