（一）mariadb replication双向主从复制环境搭建

一、准备两台安装已经安装好mariadb的服务器

        可通过 apt-get install mariadb-server 下载

二、配置复制相关的文件

1.  在主备节点均配置mariadb my.conf文件,以下三点为必要配置

• log_bin = [file path]            #目的是activating binary log
• server_id = x                      # x为1 ~ 2^32,每台服务器的server_id独一无二
• log-basename = name-unique      #例子中的report_host

举例:

#master master replication changes
server-id               = 1
report_host = master1
log_bin                 = /var/log/mysql/mariadb-bin
log_bin_index           = /var/log/mysql/mariadb-bin.index
relay_log               = /var/log/mysql/relay-bin
relay_log_index         = /var/log/mysql/relay-bin.index
log_slave_updates = ON
binlog_format=ROW
slave_skip_errors       = 1517,1507,1396

replicate-ignore-table  = mysql.gtid_slave_pos
replicate-ignore-table  = dbbkphist.backup_history

配置完成后重启mariad