mariadb主从复制：
一、主节点节点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
创建主从复制用户
mysql>grant replication slave on*.*to'test_user'@'%' identifiedby'123456';
mysql>flush privileges;
查看主节点记录
show master status\G;
二、从节点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
重启数据库
配置slave相关参数：
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;
查看配置结果：
show slave status\G；
