Mysql 主从架构配置

# vim /etc/mysql/mysql.conf.d/mysqld.cnf

# 打开二进制日志
[mysqld]
server_id=1
log-bin=master-bin
log-bin-index=master-bin.index

$ mysql -uroot -p 
mysql> create user repl;
mysql> grant replication slave on *.* to 'user'@'your_slave_addr' identified by 'password'
mysql> flush privileges;

mysql> show master status;

# vim /etc/mysql/mysql.conf.d/mysqld.cnf

# 打开relay 日志
[mysqld]
server_id=2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin

$ mysql -uroot -p
mysql> change master to master_host="your master ip ", master_port=3306, master_user='repl',master_password='password',master_log_file='master-bin.000001',master_log_pos=0;

mysql> start slave;

mysql> show slave status;

# vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
slave_skip_errors=1146