Zabbix高可用搭建系列:
一、Zabbix高可用架构
二、编译安装Zabbix
三、实现Zabbix高可用
四、MySQL主主同步与高可用
1.主主同步
Master:192.168.164.152
~]# cat /etc/my.cnf #我们这儿使用GTID实现复制
[mysqld]
datadir = /opt/mysql/data
basedir = /opt/mysql
socket = /tmp/mysql.sock
symbolic-links = 0
skip-name-resolve
slave_skip_errors = 1062 #跳过1062错误, 1062错误是指一些主键重复
server_id = 1 #数据库唯一ID,主从ID不能相同
log-bin = /opt/mysql/log/binary-log #开启binlog日志
relay-log = /opt/mysql/log/relay-log #开启relay日志
binlog_format = mixed #复制模式,混合复制
sync_binlog = 1 #开启binlog日志同步到磁盘
auto-increment-increment = 2 #自增步长
auto-increment-offset = 1 #自增起始值
binlog-do-db = zabbix #同步的库
binlog-ignore-db = mysql
binlog-ignore-db = sys
binlog-ignore-db = performance_schema
binlog-ignore-db = information_schema
replicate-do-db = zabbix
replicat