mysql去掉主主复制_mysql 主主复制

1.环境准备：

主机IP：192.168.1.4,    192.168.1.5

操作系统：centos 7.3

mysql数据库版本：mysql 5.7.13

浮动IP:192.168.1.24

mysql   采用rpm包安装  ， 依赖关系依次为common→libs→client→serveràdevel

rpm -ivhmysql-community-common-5.7.20-1.el7.x86_64.rpm

rpm -ivhmysql-community-libs-5.7.20-1.el7.x86_64.rpm

rpm -ivhmysql-community-client-5.7.20-1.el7.x86_64.rpm

rpm -ivhmysql-community-server-5.7.20-1.el7.x86_64.rpm

rpm -ivhmysql-community-devel-5.7.20-1.el7.x86_64.rpm

master 主机   ：

vim /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

character_set_server=utf8

max_connections=2000

log_timestamps=SYSTEM

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#主主复制配置:

auto_increment_offset=1

auto_increment_increment=2

#启用二进制日志 注意：日志的目录需要先建立，并将所有者该为mysql

log-bin=mysql-bin

binlog_format=row

log_bin_trust_function_creators=1

#超过30天的binlog删除

expire_logs_days=30

server-id=31

#配置从库上的更新操作是否写入二进制文件，如果这台从库，还要做其他从库的主库，那么就需要打这个参数，以便从库的从库能够进行日志同步

log-slave-updates

sync_binlog=1

#中继日志文件

relay_log = mysql-relay-bin

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

[client]

socket=/var/lib/mysql/mysql.sock<