安装好数据库客户端和服务端:
yum install mariadb mariadb-server -y
修改 MySQL 数据库配置文件 (/etc/my.cnf), 在[mysqld] 下添加以下两行:
- log-bin=jfedu-bin
- server-id=1
启动数据库服务:
systemctl start mariadb
查看配置是否生效:
通过 MySQL 客户端直接登录:
MariaDB [(none)]> show variables like "%log_bin";
对从库进行授权:
- grant replication slave on . to "jfedu"@"192.168.75.135" identified by "123456";
- flush privileges;
查看 master 状态:
show master status;
slave 端配置:
安装 MySQL yum install mariadb mariadb-server -y
修改配置文件 (/etc/my.cnf), 在[mysqld] 下添加以下行: server-id=2
启动服务:
systemctl start mariadb
指定 master 数据库:
change master to master_host="192.168.75.128", master_user="jfedu", master_password="123456", master_log_file="jfedu- bin.000002", master_log_pos=476;
查看 slave 状态:
- slave start;
- show slave status\G
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
验证数据同步:
create database cylin charset=utf8;
在 slave 查看数据库:
MariaDB [(none)]> show databases;
来源: http://www.bubuko.com/infodetail-3342601.html