replication setup issues

Discussion in 'Installation/Configuration' started by ginner159, Jun 1, 2014.

  1. ginner159

    ginner159 New Member

    Hi ive been following the guide on setting up replication of databases from the ispconfig documentation but it hasn't been updated to accommodate mysql 5.5 the process no longer works (see image attached for text added to my.cnf).

    the syslog shows this
    Code:
    [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=mydomain'
    then shows mysql shutting down and failing to boot.

    anyone know what i need to change this to?
     

    Attached Files:

  2. florian030

    florian030 Well-Known Member HowtoForge Supporter

    With newer mysql-version you can´t set some variables in the config-file. Use mysql instead and enter
    Code:
    CHANGE MASTER TO MASTER_HOST='master', MASTER_USER='slave_user00', MASTER_PASSWORD='some_password';
     

Share This Page