主从复制操作
1.修改配置文件:
vim /etc/my.cnf
server-id=1
log-bin=mysql-bin
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-do-db=需要复制的主数据库名字
binlog_format=STATEMENT
2.从机配置(host80):
修改配置文件:vim /etc/my.cnf
server-id=2
relay-log=mysql-relay
3.主机、从机重启 MySQL 服务
4.主机从机都关闭防火墙
5.在主机上建立帐户并授权 slave
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY '123123';
show master statu;
6.在从机上配置需要复制的主机
CHANGE MASTER TO MASTER_HOST='主机的IP地址',
MASTER_USER='slave',
MASTER_PASSWORD='123123',
MASTER_LOG_FILE='mysql-bin.具体数字',MASTER_LOG_POS=具体值;
start slave;
show slave status\G;
7.主机新建库、新建表、insert 记录,从机复制
8.如何停止从服务复制功能
stop slave;
9.如何重新配置主从
stop slave;
reset master;