对比配置 my.cnf server-id = 1 log-bin=/usr/local/mysql/var/mysql-bin.000001 #binlog-do-db = zabbix binlog-ignore-db = mysql binlog-ignore-db = test binlog-ignore-db = information_schema mysql>grant replication slave on *.* to 'rep'@'%' identified by 'password'; #授权用户 mysql> show master status\G; #binlog-id,pos号码 File: mysql-bin.000011 Position: 490 2 slave 端 my.conf #编辑my.cnf server-id = 2 mysql>change master to master_host='192.168.56.10',master_user='rep',master_password='password',master_log_file='mysql-bin.000011',master_log_pos=490; mysql> start slave; mysql> show slave status\G; Slave_IO_Running: Yes Slave_SQL_Running: Yes
确定binlog是否开启?
56,940
社区成员
56,757
社区内容
加载中
试试用AI创作助手写篇文章吧