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字段值
#启动从节点
目的:搭建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;