MariaDB基于GTID主从复制及多主复制

一、简单主从模式配置步骤(必须要mysql5.6，此处以maridb10.0.10为例)

1、配置主从节点的服务配置文件
# vim /etc/my.cnf

1.1、配置master节点：

[mysqld]
log-bin=/data/binlogs/master-bin
binlog_format=row


server-id       = 100
log-slave-updates = True
#gtid-mode = ON
#enforce-gtid-consistency=True
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info = 1
slave-parallel-threads = 2
binlog-checksum = CRC32
master-verify-checksum = 1
slave-sql-verify-checksum = 1
binlog-rows-query-log-events = 1
report-port = 3306
report-host = master.chinasoft.com

1.2、配置slave节点：

[mysqld]
log-bin=/data/binlogs/master-bin
binlog_format=row


server-id       = 200
log-slave-updates = True
#gtid-mode = ON
#enforce-gtid-consistency=True
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info = 1
slave-parallel-threads = 2
binlog-checksum = CRC32
master-verify-checksum = 1
slave-sql-verify-checksum = 1
binlog-rows-query-log-events = 1
report-port = 3306
report-host = slave.chinasoft.com