2021-08-10

mysqlMHA搭建

准备三台机器
ma’ster：192.168.1.12 主库 ，MHA node
slave1：192.168.1.13 从库 ，MHA node
slave2：192.168.1.14 从库，HMA master，node

1. 开始安装mysql
https://downloads.mysql.com/archives/community/
1.1安装前需要将自带的 mariadb 卸载
rpm -qa | grep mariadb
如果有
rpm -e --nodeps
1.2操作系统用户创建
groupadd mysql
useradd -r –g mysql –s /sbin/nologin mysql
1.3 创建相关目录
mkdir -p 想要安装的目录/mysql
cd 到创建好的目录
mkdir data logs
chown –R mysql:mysql /想要安装的目录/mysql
1.4解压软件
Tar zxf mysql-8.0.21-el7-x86_64.tar.gz
mv mysql-8.0.21-el7-x86_64/* 想要安装的目录/mysql
1.5开始部署
在/etc/下创建配置文件 my.cnf添加如下内容
[client]
port = 3306
#default_character_set = utf8mb4

[mysql]
default_character_set           = utf8mb4

[mysqld]
#skip-grant-tables
read_only                       =1 #从上加这条
server_id                       =82  #安装主机ip的最后一个数字
#lower_case_table_names          = 1
port                            = 3306
basedir                         =/home/mysql
datadir                         = /home/mysql/data
pid-file                        = /home/mysql/data/mysql.pid
socket                          = /tmp/mysql.sock
tmpdir                          = /tmp
default_authentication_plugin   = mysql_native_password#(密码规则)
max_allowed_packet              =1024M
#replicate_ignore_table          =qtzh.resource_platform_ref
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
###GTID模式###
gtid_mode                       = ON#(开启gtid模式)
enforce_gtid_consistency        = ON
#auto_increment_offset           = 1
#auto_increment_increment        = 2
#双主配置时auto_increment_increment配置都为2，auto_increment_offset参数分别设置1，2。以此解决自增长字段的值之间的冲突
############################################################
skip_name_resolve               = 1 #(内网地址不做反向解析)
character_set_server            = utf8mb4
collation_server                = utf8mb4_unicode_ci
max_connections                 = 4000
max_connect_errors              = 10000
interactive_timeout             = 600
wait_timeout                    = 600
table_open_cache                = 5120
#################rep###########################
relay_log                       =rac1-relay-bin
relay_log_info_repository       = TABLE
slave_parallel_type             = LOGICAL_CLOCK
slave_parallel_workers          =16
slave_preserve_commit_order     =1
master_info_repository          =TABLE
relay_log_purge                 =1
skip_slave_start=1
############log set###################
log_bin=master-binlog
log_error                       = /home/mysql/logs/mysql.log
slow_query_log_file             = /home