基于GTID做的mysql主从复制（简易版）

一、首先准备两台CentOS7虚拟机

192.168.26.131 主
192.168.26.132 从

二、配置mariadb版本十环境

vim /etc/yum.repo.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = https://mirrors.aliyun.com/mariadb/yum/10.5/centos7-amd64/
gpgkey=https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

配置完成以后关闭防火墙

三、两台安装mariadb

yum -y install mariadb mariadb-server

四、两台机器修改配置文件

vim /etc/my.cnf.d/server.cnf

主的里面配置在【mysqld】下面添加

server_id = 1	
log_bin = mysql-bin

从的里面配置在【mysqld】下面添加

server_id = 2
log_bin = mysql-bin

五、主的里面授权

grant replication slave on *.* to 'slave'@'192.168.26.%' identified by '111';

六、从里面的配置

stop slave;

change master to master_host='192.168.26.131', master_user='slave', master_password='111', master_port=3306, master_use_gtid = current_pos;

start slave;

七、查看

	show slave status\G;