3
mastermysql
I/OI/Obinlog转储processbinlog转储工艺/O
SQLI/OOs
centos2mysqlmysqlyum
iptables - f,,mysql sentenforceselinux
[root@centos7 ~] #, yum install -y mariadb
(root@centos7 ~) #, yum install -y mariadb-server
(root@centos7 ~) #, systemctl restart mariadb
(root@centos7 ~) #, iptables - f
[root@centos7 ~) #, getenforce
[root@centos7 ~] #,。vim /etc/my . cnf中所做
(mysqld)
server-id =1
log-bin =master-log
skip_name_resolve =,
保存退出
(root@centos7 ~) #, systemctl restart , mariadb
MariaDB [(一)]祝辞,grant replication 奴隶,replication client 提醒*。*,用& # 39;奴隶# 39;@ # 39;172.17. % % & # 39;,identified by & # 39; 123456 & # 39;;
服务器id=2
relay-log=mysql-relay-bin
只读=1
log-bin=mysql-bin
log-slave-updates=1
[root@centos7 ~] #, systemctl restart mariadb
MariaDB [(一)]祝辞,change master 用master_host=& # 39; 172.17.252.89& # 39;
,,,,,master_user=& # 39;奴隶# 39;
,,,,,master_password=& # 39; 123456 & # 39;
,,,,,master_log_file=& # 39; master-log.000006& # 39;
,,,,,master_log_pos=245;
