How To Set Up Database Replication In MySQL

Discussion in 'HOWTO-Related Questions' started by cwtudor, Oct 29, 2014.

  1. cwtudor

    cwtudor New Member

    running ISPConfig on wheeze trying to follow How To Set Up Database Replication In MySQL by falko

    After adding

    server-id=2
    master-host=xxx.168.0.100
    master-user=slave_user
    master-password=secret
    master-connect-retry=60
    replicate-do-db=AAL

    Mysql will not restart, Is there something I need to do to let the salve have access to the database through the net address I did comment out
    #bind-address = 127.0.0.1 during setup of ISPConfig
    and there was no the line #skip-networking on the master server.

    I also double checked the created user and password for 'slave_user"
     
  2. conductive

    conductive Member HowtoForge Supporter

    I have never tried this, but in a multiserver environment you typically communicate through cli and need to configure a master and slave in the control panel for it to work properly.
     
  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    IIRC this tutorial is for an older mysql-version. With newer version you can not set slave-data in my.cnf. Login to your mysql and enter
    Code:
    CHANGE MASTER TO MASTER_HOST='master', MASTER_USER='slave_user00', MASTER_PASSWORD='some_password';
     
  4. cwtudor

    cwtudor New Member

    Thanks

    Tried a couple of things as were suggested but Think I will look for other solutions. Thanks for your responses
     
  5. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    Setting-up databse-replication with mysql it´s not very complicated. klick
     

Share This Page