环境操作系统:CentOS-7MySQL:mysql-5.6一台虚拟机又克隆了两台192.168.102.31 master192.168.102.56 slave192.168.102.36 slave启动/停止
service mysqld start|stop|restart
systemctl start|stop|restart mysqld
本机的话,直接mysql就可以进去了
主数据库配置第1步:编辑/etc/my.cnf文件,在[mysqld]下增加如下两行设置:
[mysqld]
log-bin=mysql-bin # 非必需
server-id=1 # 必需
第2步:创建用于数据同步的账户
CREATE USER 'repl'@'192.168.102.%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.102.%';
FLUSH PRIVILEGES;
第3步:查看master状态
show master status;
3. 从数据库配置第1步:编辑/etc/my.cnf文件,设置server-id
[mysqld]
server-id=2
第2步:执行同步语句,并启动slave
change master to master_host='192.168.102.31', master_user='repl', master_password='123456', master_log_file='mysql-bin.000001', master_log_pos=514;
第3步:查看slave状态
show slave status\G;
另外一台从数据库也是这样设置4. 验证是否同步成功在主数据上操作,从数据库中查看
5. 设置只读账户
mysql> create user 'pig'@'%' identified by '123456';
mysql> grant select on test.* to 'pig'@'%';
mysql> flush privileges;
参考https://dev.mysql.com/doc/refman/5.7/en/replication-options-slave.htmlhttp://www.cnblogs.com/gl-developer/p/6170423.htmlhttps://www.cnblogs.com/alvin_xp/p/4162249.htmlhttps://www.cnblogs.com/sos-blue/p/6852945.html