闲来无事在虚拟要配置了一遍mysql主从复制,做下记录,配置下来还是蛮简单的

环境:2台#CentOS release 6.8 (Final)虚拟机


[mysql-A]
yum -y update
cat /etc/issue #CentOS release 6.8 (Final)
yum install mysql mysql-devel mysql-server #安装mysql服务器
service mysqld start
service iptables stop
chkconfig iptables off
mysql_secure_installation #初始化mysql参数
vi /etc/my.cnf #server-id=1;log-bin=mysql-bin #添加服务器ID&服务器日志
service mysqld restart
vi .my.cnf > [Client]user=root password=xxx
mysql>CREATE USER 'user'@ 'X.X.X.X' IDENTIFIED BY 'password';#可以创建一个用户专门用来设置成复制账号
grant replication slave on *.* to root@'%' identified by 'passowrd';#赋予“REPLICATION SLAVE”的权限
flush privileges;
flush tables with read lock;#防止数据写入
show master status\G;
netstat -natp | grep -i established.*mysql
mysql -e "SHOW PROCESSLIST"
msyql>UNLOCK TABLES;解锁表
[mysql-B]
vi /etc/my.cnf > server-id=2
service mysqld restart
mysql> change master to
-> master_host='MYSQL-A',
-> master_port='3306', #如未变更可省略
-> master_user='root',
-> master_password='xxx',
-> master_log_file='mysql-bin.000001',
-> master_log_pos=322;
mysql>start slave;
mysql>show processlist;
show slave status \G;

log-bin=mysql-bin

清除mysql主从信息
mysql>slave stop;
mysql>reset slave;
mysql>change master to master_host=’ ‘;