4步搞定MySQL安装部署（附MySQL一键式部署脚本）

#!/bin/bash#####MySQL5.7.32数据库自动安装脚本# Version:      1.0# Author:       kevinCUI# Date:         2020-12-31######mysql 安装包的绝对路径,去掉.tar.gztarGzPath=/opt/idc/tarGzFile=mysql-5.7.32-linux-glibc2.12-x86_64#mysql 安装路径installPath=/home/mysql/
#my.cnf配置文件mysqlcnf=/home/mysql/my.cnf
#mysql serverid需要设置唯一的id,比如 ip+3位数字mysqlServerid=1010101
#mysql 密码(不可擅自修改)defaultPwd=123456
#mysql 端口mysqlPort=3306
#mysql数据目录data_default=${installPath}${mysqlPort}data_datadir=${data_default}/datadata_binlog=${data_default}/binlogdata_dbdata=${data_default}/dbdatadata_logs=${data_default}/logsdata_tmp=${data_default}/tmpdata_undo=${data_default}/undo# 校验是否为ROOT用户CheckRoot(){if [ $(id -u) != "0" ]; then    echo "Error: You must be root to run this script, please use root to install"    exit 1ficlear} #优化文件最大打开数DependFile(){
if [ $( cat /etc/security/limits.conf  | grep "mysql" | wc -l )  -lt 1 ] ;thencat >>/etc/security/limits.conf << EOF* soft nproc 65536* hard nproc 65536* soft nofile 65536* hard nofile 65536mysql soft nproc 65536mysql hard nproc 65536mysql soft nofile 65536mysql hard nofile 65536EOF
fi
if [ -e /etc/security/limits.d/20-nproc.conf ];thenif [ $( cat /etc/security/limits.d/20-nproc.conf  | grep "mysql" | wc -l )  -lt 1 ] ;thencat >>/etc/security/limits.d/20-nproc.conf<mysql       soft    nproc     unlimitedEOF
fifi
if [ -e /etc/security/limits.d/90-nproc.conf ];thenif [ $( cat /etc/security/limits.d/90-nproc.conf  | grep "mysql" | wc -l )  -lt 1 ] ;thencat >>/etc/security/limits.d/90-nproc.conf<mysql       soft    nproc     unlimitedEOF
fifi
if [ -e /etc/sysctl.conf ];thenfs_file=$( cat /proc/sys/fs/file-max)if [ ${fs_file} -lt 65535 ] ;thensed -i "s/${fs_file}/65535/g" /etc/sysctl.conf/usr/sbin/sysctl -p 
fifi
echo -e "\e[31m #1.配置基础资源 \e[0m"
}
#拷贝tar.gz包DecompressionTarGz(){if [ ! -e ${tarGzPath}${tarGzFile}.tar.gz  ];then    echo -e "\e[31m ${tarGzPath}${tarGzFile}.tar.gz  不存在！请检查后重新执行脚本 \e[0m"    exit 1fi#解压并重命名到安装目录if  [ ! -d ${installPath}${tarGzFile} ] ;then    mkdir -p ${installPath}    tar -xvf ${tarGzPath}${tarGzFile}.tar.gz -C ${installPath} &> /dev/nullfi
echo -e "\e[31m #2.软件已解压 \e[0m"
}#添加组合角色AddMysqlUser(){if [ ! $(id -u "mysql") ]; then   echo "mysql user is not exists for to created"   /usr/sbin/groupadd mysql   /usr/sbin/useradd -g mysql -r -s /sbin/nologin -M mysqlfi
echo -e "\e[31m #3.mysql启动用户已准备完成 \e[0m"
}
#创建mysql 数据目录createMysqlFolder(){if  [ -d ${data_default} ] ;then    if [ $(du -s  ${data_default}  |  awk 'NR==1{print $1}') -gt 0 ] ;then        mv  ${data_default}  ${data_default}"`date +%Y%m%d%H%M`"    fifi
mkdir -p ${data_datadir}mkdir -p ${data_binlog}mkdir -p ${data_dbdata}mkdir -p ${data_logs}mkdir -p ${data_tmp}mkdir -p ${data_undo}
#赋予权限chown -R mysql:mysql ${data_default}chmod 700 ${data_tmp}
echo -e "\e[31m #4.mysql 数据目录 权限 已准备完成 \e[0m"
}
#创建my.cnfMakeMyCnf(){
if  [ -e ${mysqlcnf} ] ;then    #mv  ${mysqlcnf}  ${mysqlcnf}"`date +%Y%m%d%H%M`"    rm ${mysqlcnf}fi
cat >${mysqlcnf}<[mysqld_safe]user = mysqlnice = 0
[client]                           socket                             = ${data_datadir}/mysql.sockport                               = ${mysqlPort}
[mysqld]############# GENERAL #############skip_sslskip-name-resolveautocommit                         = ONcharacter_set_server               = utf8mb4collation_server                   = utf8mb4_unicode_ciexplicit_defaults_for_timestamp    = ON  lower_case_table_names             = 1port                               = ${mysqlPort}read_only                          = OFFtransaction_isolation              = READ-COMMITTEDopen_files_limit                   = 65535max_connections        = 2000expire_logs_days                   = 10default-time_zone                  = '+8:00'####### CACHES AND LIMITS #########interactive_timeout                = 600 lock_wait_timeout                  = 300max_connect_errors                 = 1000000
table_definition_cache             = 2000table_open_cache                   = 2000 table_open_cache_instances         = 8
thread_cache_size                  = 32thread_stack                       = 256K
tmp_table_size                     = 32Mmax_heap_table_size                = 64M
query_cache_size                   = 0query_cache_type                   = 0
sort_buffer_size                   = 1Mjoin_buffer_size        = 1Msort_buffer_size        = 1Mread_rnd_buffer_size        = 2M
innodb_io_capacity            = 1000 innodb_io_capacity_max       = 2000
max_allowed_packet                 = 1024Mslave_max_allowed_packet           = 1024Mslave_pending_jobs_size_max        = 1024M

############# SAFETY ##############local_infile                       = OFFskip_name_resolve                  = ONsql_mode                           = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES
############# LOGGING #############general_log                        = 0log_queries_not_using_indexes      = ONlog_slow_admin_statements          = ONlog_warnings                       = 2long_query_time                    = 1  #1秒慢日志slow_query_log                     = ON
############# REPLICATION #############
server_id                          = ${mysqlServerid}  #ip+3位数字binlog_checksum                    = CRC32binlog_format                      = ROWbinlog_rows_query_log_events       = ON
enforce_gtid_consistency           = ONgtid_mode                          = ONlog_slave_updates                  = ON
master_info_repository             = TABLEmaster_verify_checksum             = ON
max_binlog_size                    = 512Mmax_binlog_cache_size              = 1024M   #已修改，原值1024binlog_cache_size        = 8M
relay_log_info_repository          = TABLEskip_slave_start                   = ONslave_net_timeout                  = 10slave_sql_verify_checksum          = ON
sync_binlog                        = 1sync_master_info                   = 1sync_relay_log                     = 1sync_relay_log_info                = 1
############### PATH ##############basedir                            = ${installPath}${tarGzFile}
datadir                            = ${data_datadir}tmpdir                             = ${data_tmp}socket                             = ${data_datadir}/mysql.sockpid_file                           = ${data_datadir}/mysql.pidinnodb_data_home_dir               = ${data_dbdata}
log_error                          = ${data_logs}/error.loggeneral_log_file                   = ${data_logs}/general.logslow_query_log_file                = ${data_logs}/slow.log
log_bin                            = ${data_binlog}/mysql-binlog_bin_index                      = ${data_binlog}/mysql-bin.indexrelay_log                          = ${data_binlog}/relay-logrelay_log_index                    = ${data_binlog}/relay-log.index
# undo settingsinnodb_undo_directory        = ${data_undo}innodb_undo_log_truncate           = 1 innodb_max_undo_log_size      = 16Minnodb_undo_tablespaces            = 4

############# INNODB #############innodb_file_format                 = barracudainnodb_flush_method                = O_DIRECT
innodb_buffer_pool_size            = 1024Minnodb_buffer_pool_instances       = 4 innodb_thread_concurrency          = 0
innodb_log_file_size               = 1024Minnodb_log_files_in_group          = 2innodb_flush_log_at_trx_commit     = 1innodb_support_xa                  = ONinnodb_strict_mode                 = ON
innodb_data_file_path              = ibdata1:32M;ibdata2:16M:autoextendinnodb_temp_data_file_path         = ibtmp1:1G:autoextend:max:30Ginnodb_checksum_algorithm          = strict_crc32innodb_lock_wait_timeout           = 600
innodb_log_buffer_size             = 8Minnodb_open_files                  = 65535
innodb_page_cleaners               = 1innodb_lru_scan_depth              = 256innodb_purge_threads               = 4innodb_read_io_threads             = 4innodb_write_io_threads            = 4 
innodb_print_all_deadlocks         = 1
[mysql]############# CLIENT #############                            max_allowed_packet                 = 16Msocket                             = ${data_datadir}/mysql.sockno-auto-rehash
[mysqldump]                        max_allowed_packet                 = 16M
EOF
echo -e "\e[31m #5.mysql cnf配置完成，【需要按照实际情况更改】 \e[0m"}
#初始化数据库InitDataBase(){#cd ${installPath}${tarGzFile}${installPath}${tarGzFile}/bin/mysqld --defaults-file=${mysqlcnf} --basedir=${installPath}${tarGzFile} --datadir=${data_datadir} --user=mysql --initialize
${installPath}${tarGzFile}/bin/mysqld_safe --defaults-file=${mysqlcnf}  --user=mysql   &
echo -e "\e[31m #6. 初始化数据库完成并启动服务. \e[0m"
}
#重置密码ResetPwd(){sleep 10s#从日志中获取mysql初始密码pwd=`grep "A temporary password is generated for root@localhost: " ${data_logs}/error.log`pwd=${pwd##*root@localhost:}#防止因为初始密码中有特殊字符出错 拼接单引号pwd=${pwd// /}echo ${pwd}${installPath}${tarGzFile}/bin/mysql -uroot -p${pwd} -S ${data_datadir}/mysql.sock --connect-expired-password  -e "alter user 'root'@'localhost' identified by   '${defaultPwd}';"
echo -e "\e[31m #7. 已重置数据库密码。登录方式如下: \e[0m"echo -e "\e[31m ${installPath}${tarGzFile}/bin/mysql -uroot -p  -S ${data_datadir}/mysql.sock \e[0m"
}#ResetPwd
main()  {  ###1.校验是否为ROOT用户CheckRoot  
###2.优化文件最大打开数DependFile
###3.拷贝tar.gz包DecompressionTarGz
###4.添加组合角色AddMysqlUser
###5.创建mysql 数据目录createMysqlFolder
###6.创建my.cnfMakeMyCnf
###7.初始化数据库InitDataBase
###8.重置密码ResetPwd
}  
main