MySQL主从
准备两台Centos6服务器,一台为Master服务器,一台为Slave服务器,并配置好yum
分别在两台服务器上安装mysql
#yum -y install mysql mysql-server
master主机的配置
#vim /etc/my.cnf
[mysqld]
server-id=1
log-bin=mysql-bin
关闭防火墙
#service mysqld restart
#service iptables stop
#setenforce 0
登录mysql
#mysql -uroot
给从授权一个拥有复制权限的用户
#grant replication slave on . to ‘tom’@’%’ identified by ‘123’;
刷新权限库
flush privileges;
查看当前在用的二进制日志和位置,记录好,一会从上同步使用
show master status;
±-----------------±---------±-------------±-----------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
±-----------------±---------±-------------±-----------------+
| mysql-bin.000001 | 106 | | |
±-----------------±---------±-------------±-----------------+
1 row in set (0.00 sec)
slave主机的配置
#vim /etc/my.cnf
[mysqld]
server-id=2
relay-log=mysql-relay
#service mysqld restart
#service iptables stop
#setenforce 0
登录mysql
#mysql -uroot
mysql> stop slave;
mysql> change master to
-> master_host=‘192.168.189.164’,
-> master_user=‘tom’,
-> master_password=‘123’,
-> master_log_file=‘mysql-bin.000001’,
-> master_log_pos=106;
mysql> start slave;
mysql> show slave status \G;
查看两个进程状态是否为YES,都是YES说明配置成功
在master主机上创建一个数据库测试
mysql> create database wg;
在slave主机上查看数据库是否同步
mysql> show databases;