mysql主从搭建

mysql主从搭建
目的:搭建mysql主从,实现数据同步
主:192.168.202.128
从:192.168.202.129


一,mysql的yum卸载和安装
1.查看:rpm -qa|grep mysql
1.卸载:yum remove  mysql mysql-server mysql-libs
2.安装:yum install mysql-server
     yum install mysql
启动|停止|重启:service mysqld start|stop|restart


二,主从配置
主节点配置:
1.mysql -u<name> -p<password>登陆创建一个可以远程连接的用户并赋权
  %可以模糊匹配ip
  GRANT REPLICATION SLAVE ON *.* TO '<user>'@'<ip>' IDENTIFIED BY '<password>';
  
2.vi /etc/my.cnf在[mysqld]添加
server-id=1
log-bin=master-bin
log-bin-index=master-bin.index
binlog-format=ROW


三,从节点配置:
1.vi /etc/my.cnf在[mysqld]添加
server-id=2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin


2.mysql -u<name> -p<password>登陆


连接master节点
change master to master_host='192.168.202.128',   #主节点ip
master_port=3306,   #主节点端口
master_user='canal',  #主节点创建的用户名
master_password='canal',   #主节点创建的用户密码 
master_log_file='master-bin.000005',  #在master节点SHOW MASTER STATUS;命令后的File字段值
master_log_pos=693;  #在master节点SHOW MASTER STATUS;命令后的Position字段值


#启动从节点

slave start;

四,测试

   登陆master节点，create database hello;

   检查从节点是否有数据同步,show databases;