mysql5.7 keepalived_linux MySQL 5.7+keepalived 主备服务器自主切换

一、环境准备

1、关闭防火墙与selinux

systemctl stop firewalld

setenforce 0

sed -i 's/SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config

二、mysql5.7.20安装

#MySQL5.6与MySQL5.7的区别在于初始化的时候，其他安装步骤一致

1、创建目录

mkdir -p /data/mysql/{data,logs,tmp}

touch /data/mysql/{mysql.pid,mysql.sock}

2、创建用户

useradd mysql

3、安装依赖包

yum install perl perl-devel perl-Data-Dumper libaio-devel -y

4、下载包

cd /usr/local/src

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

tar zxf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

cd /usr/local

mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql

chown -R mysql:mysql /usr/local/mysql /data/mysql/

三、配置文件

========================================================

[client]

port = 16205

default-character-set=utf8mb4

socket = /data/mysql/mysql.sock

[mysqld]

user = mysql

port = 16205

server-id = 111

character_set_server=utf8mb4

socket = /data/mysql/mysql.sock

datadir = /data/mysql/data/

pid-file = /data/mysql/mysql.pid

auto-increment-increment = 2　　　　#主主参数，主从可注释(必填)

auto-increment-offset = 1　　　　　　#主主参数，主从可注释(必填)主：1；从：2

#bind-address = 10.26.25.28

#skip-name-resolve=1

#event_scheduler = on

federated

skip-ssl

secure-file-priv = /home/mysql

disable-partition-engine-check=1

explicit_defaults_for_timestamp=false

max_allowed_packet = 32M

innodb_file_per_table = 1

back_log = 300

max_connections = 8000

max_connect_errors = 1000

table_open_cache = 4096

open_files_limit = 10240

max_allowed_packet = 512M

wait_timeout = 300

interactive_timeout=300

sort_buffer_size = 16M

join_buffer_size = 16M

query_cache_size = 128M

transaction_isolation = REPEATABLE-READ

thread_stack = 512K

innodb_buffer_pool_size = 4G

innodb_data_file_path = ibdata1:512M:autoextend

innodb_flush_log_at_trx_commit = 2

innodb_thread_concurrency = 16

innodb_log_buffer_size = 16M

innodb_log_file_size = 512M

innodb_log_files_in_group = 3

innodb_lock_wait_timeout = 120

binlog-ignore-db=information_schema,mysql,performance_schema　　#主主参数，主从可注释

#replicate-ignore-db=information_schema,mysql,performance_schema

binlog_format=row

expire_logs_days=10

binlog_