My Configuration:
server-id = 2
master-host=192.1.1.12
master-connect-retry=60
master-user=root
master-password=root123
replicate-do-db=testdatabase
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
log-error = /var/lib/mysql/mysql.err
master-info-file = /var/lib/mysql/mysql-master.info
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
log-bin = /var/lib/mysql/mysql-bin
Output:
2018-09-14 08:41:10 13635 [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=192.1.1.12'
2018-09-14 08:41:10 13635 [ERROR] Aborting
2018-09-14 08:41:10 13635 [Note] Binlog end
2018-09-14 08:41:10 13635 [Note] Shutting down plugin 'partition'
2018-09-14 08:41:10 13635 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
1条答案
按热度按时间wgx48brx1#
主主机、-user和-password选项变量已从MySQL5.5中删除。改用change master语句。
https://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#replication-optvars从机过时