1.两台虚拟机
2.防火墙,selinux的关闭
3.两台虚拟机主机名修改
hostnamectl set-hostname mysql1
hostnamectl set-hostname mysql2
1.数据库的用YUM源进行下载
yum install mariadb-server mariadb -y
2.重启数据库
systemctl restart mariadb
3.数据库初始化(设置密码,接下来的操作就回车就行了)
mysql_secure_installation
4.节点配置(主节点为mysql1,从节点为mysql2)
vi /etc/my.cnf.d/server.cnf
5.在mysql下进行内容添加(主虚拟机和从虚拟机同时进行)
[mysqld]
log_bin=mysql-bin
binlog_ignore_db=mysql
server_id=虚拟机ip的末尾两位数字
6.重启数据库
systemctl restart mariadb
7.先进入主机点数据库进行操作
mysql -uroot -p
grant all privileges on *.* to root@'%' identified by "000000";
grant replication slave on *.* to 'user'@'mysql2' identified by '000000';
8.进入从节点数据库
change master to master_host='mysql1',master_user='user',master_password='000000';
start slave;
show slave statusG;
出现以下两个YES则成功



