上一篇文章介绍了mysql8的数据库搭建,下面介绍mysql的主从搭建,非常简单
首先改my.cnf文件,
主库增加如下内容:[mysqld]下面增加
server-id=1
log-bin=master-bin
log-bin-index=master-bin.index
从库1增加
server-id=2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin
从库2增加
server-id=2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin
主库创建复制账号和密码
mysql>create user repuser1 IDENTIFIED BY 'test123456';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repuser1'@'192.168.0.123';
mysql>FLUSH PRIVILEGES;
mysql>create user repuser2 IDENTIFIED BY 'test123456';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repuser2'@'192.168.0.124';
mysql>FLUSH PRIVILEGES;
重启主库和从库,然后进入mysqld主库,