测试环境:
主节点:81.69.247.195
从节点:124.71.182.20
linux:centos6.5
主:
1.
编辑 vim /etc/my.cnf
添加:log-bin = mysql-bin
添加 :server-id =1
添加:innodb-file-per-table =ON
添加:skip_name_resolve=ON
2.
重启mysql:service mysqld restart
3.进入mysql:mysql -u root -p
4.查看二进制信息:
show global variables like '%log%';
5.查看主节点二进制日志列表
show master logs;
6.查看主节点的server id
show global variables like '%server%';
7.在主节点上创建有复制权限的用户。REPLIACTION SLAVE ,REOPLIATION CLIENT
grant replication slave,replication client on *.* to 'admin'@'124.71.182.20' identified by '123456';
8.刷新
flush privileges;
从:
1.
编辑 vim /etc/my.cnf
添加:relay-log=relay-log
添加:relay-log-index=relay-log.index
添加:server-id=2
添加:innodb_file_per_table=ON
添加:skip_name_resolve=ON
2.重启mysql:service mysqld restart
3.进入mysql:mysql -u root -p
读写分离 主从复制
最新推荐文章于 2024-05-11 11:27:26 发布