mariadb主從復(fù)制：
一猫缭、主節(jié)點(diǎn)節(jié)點(diǎn)master配置
vi /etc/my.cnf文件
[mysqld]
server-id=1
log_bin=master-bin
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=test
innodb_flush_log_at_trx_commit=1
binlog_format=mixed
重啟maridb
創(chuàng)建主從復(fù)制用戶
mysql>grant replication slave on*.*to'test_user'@'%'? ?identifiedby'123456';
mysql>flush privileges;
查看主節(jié)點(diǎn)記錄
show master status\G;
二稽屏、從節(jié)點(diǎn)slave配置
vi /etc/my.cnf文件
[mysqld]
server-id=2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin
relay_log_recovery=1
重啟數(shù)據(jù)庫
配置slave相關(guān)參數(shù)：
mysql> stop slave;
mysql> change master to
? ? ? master_host='master IP',
? ? ? master_user='backup',
? ? ? master_password='123456',
? ? ? master_log_file='master-bin.000001',
? ? ? master_log_pos=245;
mysql> start slave;
查看配置結(jié)果：
show slave status\G；
