Add replication slave

Comments

3 comments

  • Avatar
    Johan

    Hi!

    Can you paste the content of the mysql error log here.

    Usually found in:

     /var/log/mysql/mysql*.log

     /var/log/mysql*.log

     /data/error.log 

    (basically it will be specified by the log-error directive in the /etc/

    However, if it is indeed a MariaDB server then 'enforce_gtid_consistency'  and 'gtid_mode=ON' are not an supported options.


    BR
    johan

  • Avatar
    Johan

    For MariaDB, tweak the my.cnf.slave template so it looks like:

    [mysqld]
    bind-address=0.0.0.0
    log_bin=binlog
    log_slave_updates=1
    expire_logs_days=7
    server_id=1001
    binlog_format=ROW
    slave_net_timeout=60
    basedir=/usr
    datadir=/data

    Then ensure the server_id is indeed unique, and finally try the job again.

    BR
    johan

     

  • Avatar
    Michael

    That was the issue!

     

    Thanks

Please sign in to leave a comment.

Powered by Zendesk