CentOS7脚本一键安装MySQL5.6

一、需求

公司要安装mysql5.6组件，这里有两种方式(推荐使用rpm包安装)：

• 采用官方提供的rpm安装
  • 优点：快速安装完毕，比较通用
  • 缺点：无法定制化安装
• 源码编译
  • 优点：可以定制化编译安装

  • 缺点：安装慢，通用性不好(还需要自己写服务管理脚本)

二、脚本代码解析

• 加载mysql5.6官方源

  # 以下为部分脚本代码
  # 1.可以看到自己配置mysql5.6官方源
  # 2.之后使用yum即可进行安装
  
    if [ ! -f {mysql_repo} ]; then
        cat >>{mysql_repo}<< EOF
  # Enable to use MySQL 5.6
  [mysql56-community]
  name=MySQL 5.6 Community Server
  baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/{sys_ver}/\$basearch/
  enabled=1
  gpgcheck=1
  gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
  EOF
    fi
  
  if [ ! -f{mysql_gpg_key} ]; then
      wget http://repo.mysql.com/RPM-GPG-KEY-mysql -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 
  fi
  

• yum安装mysql

  # 以下为部分脚本代码
  # 1.通过yum即可安装mysql-5.6
  # 2.这里需要注意的时候如果你配置了多个mysql安装源的话，yum时可能会安装其他版本mysql
  
  if [ `check_rpm mysql-server` == '0' ]; then
      yum install -y mysql-community-client mysql-community-server mysql-community-devel mysql-community-test 
  fi
  

• 自定义data数据存储目录

  # 以下为部分脚本代码
  # 1.自定义数据库存储目录方便后期管理维护 
  
  #创建mysql数据库目录
  [ ! -d  {mysql_data}/data ] && mkdir -p{mysql_data}/data
  [ ! -d  {mysql_data}/log ] && mkdir -p{mysql_data}/log
  [ ! -d  {mysql_data}/tmp ] && mkdir -p{mysql_data}/tmp
  chown -R mysql.mysql ${mysql_data}
  

• 自定义my.cnf并初始化

  # 以下为部分脚本代码
  # 1.mysql5.6可通过mysql_install_db进行初始化
  # 2.mysql5.7初始化脚本命令不再相同
  
  #初始化mysql数据库
  if [ ! -d {mysql_data}/data/mysql ]; then
      #/usr/bin/mysql_install_db --defaults-extra-file={mysql_conf} --user=mysql --force >/dev/null >&1
      echo {mysql_conf}
      /usr/bin/mysql_install_db --defaults-extra-file={mysql_conf} --user=mysql --force
      if [ ? -eq 0 ]; then
          echo  "mysql数据库初始化成功" |tee -a{log}
      else
          echo 'mysql数据库初始化 fail' |tee -a {log}
      fi
  else
      echo "mysql数据库已初始化，无需再次初始化." |tee -a{log}
  fi
  

三、脚本内容

#!/bin/bash
#MySQL5.6一键安装
#Author: yousong.xiang
#Date:  2018.11.26
#Version: v1.0.2


[ -f /etc/profile ] && . /etc/profile
[ # -ne 1 ] && {
                    echo -e "\033[31m传递参数有误\033[0m"
                    exit 9
                }

cmd=`pwd`
datetime=`date '+%H%M%S'`
log=upgrade{datetime}.log

if [ ! -f {log} ]; then
    touch{log}
fi

function check_rpm(){
    rpm_name=1
    num=`rpm -qa|grep{rpm_name}|wc -l`
    echo {num}
}

function epel_install(){
    #关闭selinux,安装基础依赖环境函数
    sed -i '/^SELINUX=.*/s/SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
    setenforce 0
    #判断是否安装redhat-lsb-core
    if [ `check_rpm redhat-lsb-core` == '0' ]; then
        yum install -y redhat-lsb-core  >/dev/null >&1
    fi 

    if [ `check_rpm epel-release` == '0' ]; then
        yum install -y epel-release
    fi

    #重新加载环境变量    sys_ver=`lsb_release -r |awk -F' ' '{print2}'|awk -F'.' '{ print 1 }'`
    #echo{sys_ver}    

    #判断是否安装remi-release,如果没有安装则安装
    if [ `check_rpm remi-release` == '0' ]; then
        rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-{sys_ver}.rpm  &>/dev/null
        if [? -eq 0 ]; then
            echo -e "\033[32;1mepel-release install seccuess\033[0m" |tee -a {log}
            yum clean all                   else
            echo -e "\033[31;1mepel-release install fail\033[0m" |tee -a{log}
        fi
    fi   

    if [ `check_rpm wget` == '0' ]; then
        yum install -y wget
        if [ `check_rpm wget` != '0' ]; then
            echo -e "\033[32;1mwget install seccuess\033[0m" |tee -a {log}
        else
            echo -e "\033[31;1mwget install fail\033[0m" |tee -a{log}
        fi
    fi

}

function mysql56_install() {
    mysql_data=1
    mysql_conf=/etc/my.cnf
    mysql_repo=/etc/yum.repos.d/mysql-community.repo
    mysql_gpg_key=/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql


    if [ -f /var/log/mysql_install.lock ]; then
        echo -e "\033[31;1mMysql installed Already \033[0m" |tee -a{log}
        return 0
    fi    

    sys_ver=`lsb_release -r |awk -F' ' '{print 2}'|awk -F'.' '{ print1 }'`

    if [ ! -f {mysql_repo} ]; then
        cat >>{mysql_repo}<< EOF
# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/{sys_ver}/\$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
EOF
    fi

  if [ ! -f{mysql_gpg_key} ]; then
      wget http://repo.mysql.com/RPM-GPG-KEY-mysql -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 
  fi

  if [ `check_rpm mysql-server` == '0' ]; then
      #yum install -y mysql-community-client mysql-community-server mysql-community-devel mysql-community-test  >/dev/null >&1
      yum install -y mysql-community-client mysql-community-server mysql-community-devel mysql-community-test 
  fi

  if [ `check_rpm mysql-server` != '0' ]; then
      echo -e "\033[32;1mmysql install seccuess\033[0m" |tee -a {log}
  else:
      echo -e "\033[31;1mmysql install fail\033[0m" |tee -a{log}
  fi

  #创建mysql数据库目录
  [ ! -d  {mysql_data}/data ] && mkdir -p{mysql_data}/data
  [ ! -d  {mysql_data}/log ] && mkdir -p{mysql_data}/log
  [ ! -d  {mysql_data}/tmp ] && mkdir -p{mysql_data}/tmp
  chown -R mysql.mysql {mysql_data}

  mem_total=`free -m|grep "^Mem"|awk '{print2}'`


  if [ -n {mem_total} ]; then
      let buffer_innodb={mem_total}/4
  else
      buffer_innodb=256
  fi

  buffer_innodb={buffer_innodb}M


  if [ -f{mysql_conf} ]; then
      mv /etc/my.cnf /etc/my.cnfbak
      cat >>{mysql_conf}<<EOF
[mysqld_safe]
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
port=3306
prompt=\\\u@\\\d \\\R:\\\m:\\\s>
default-character-set=utf8
no-auto-rehash
[mysqld]
#server
port=3306
bind-address=0.0.0.0
skip-name-resolve
skip-ssl
sql_mode=""
max_connections=4500
max_user_connections=4000
max_connect_errors=65536
max_allowed_packet=128M
connect_timeout=8
net_read_timeout=30
net_write_timeout=60
back_log=1024
default-storage-engine=INNODB
character-set-server=utf8mb4
lower_case_table_names=1
skip-external-locking
open_files_limit=65536
safe-user-create
local-infile=1
#sqlmod="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"
performance_schema=0
log_slow_admin_statements=1
log_warnings=1
long_query_time=1
slow_query_log=1
general_log=0
query_cache_type=0
query_cache_limit=1M
query_cache_min_res_unit=1K
table_definition_cache=65536
table_open_cache=65536
thread_stack=512K
thread_cache_size=256
read_rnd_buffer_size=128K
sort_buffer_size=256K
join_buffer_size=128K
read_buffer_size=128K
#dir
basedir={mysql_data}
datadir={mysql_data}/data
tmpdir={mysql_data}/tmp
log-error={mysql_data}/alert.log
slow_query_log_file={mysql_data}/log/slow.log
#general_log_file={mysql_data}/log/general.log
socket=/var/lib/mysql/mysql.sock
#binlog
log-bin={mysql_data}/log/mysql-bin
server_id=1
binlog_cache_size=32K
max_binlog_cache_size=1G
max_binlog_size=500M
binlog_format=ROW
log-slave-updates=1
expire_logs_days=8
#replication
master-info-file={mysql_data}/log/master.info
relay-log={mysql_data}/log/relaylog
relay_log_info_file={mysql_data}/log/relay-log.info
relay-log-index={mysql_data}/log/mysqld-relay-bin.index
slave_load_tmpdir={mysql_data}/tmp
slave_net_timeout=4
#innodb
innodb_data_home_dir={mysql_data}/data
innodb_log_group_home_dir={mysql_data}/data
innodb_data_file_path=ibdata1:2G;ibdata2:16M:autoextend
innodb_buffer_pool_size={buffer_innodb}
innodb_buffer_pool_instances=4
innodb_log_files_in_group=2
innodb_log_file_size=1G
innodb_log_buffer_size=200M
innodb_flush_log_at_trx_commit=2
innodb_additional_mem_pool_size=20M
innodb_max_dirty_pages_pct=60
innodb_io_capacity=1000
innodb_thread_concurrency=16
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_open_files=60000
innodb_file_format=Barracuda
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_change_buffering=inserts
innodb_adaptive_flushing=1
innodb_old_blocks_time=1000
innodb_stats_on_metadata=0
innodb_read_ahead=0
innodb_use_native_aio=0
innodb_lock_wait_timeout=5
innodb_rollback_on_timeout=0
innodb_purge_threads=1
innodb_strict_mode=1
innodb_autoinc_lock_mode=0
#myisam
key_buffer_size=64M
myisam_sort_buffer_size=64M
concurrent_insert=2
delayed_insert_timeout=300
EOF
  fi      

  #初始化mysql数据库
  if [ ! -d {mysql_data}/data/mysql ]; then
      #/usr/bin/mysql_install_db --defaults-extra-file={mysql_conf} --user=mysql --force >/dev/null >&1
      echo {mysql_conf}
      /usr/bin/mysql_install_db --defaults-extra-file={mysql_conf} --user=mysql --force
      if [ ? -eq 0 ]; then
          echo  "mysql数据库初始化成功" |tee -a{log}
      else
          echo 'mysql数据库初始化 fail' |tee -a {log}
      fi
  else
      echo "mysql数据库已初始化，无需再次初始化." |tee -a{log}
  fi

  if [ -f /usr/my.cnf ]; then
      rm -f /usr/my.cnf
  fi
  #修正Centos7 mysql连接数限制
  cat >>/usr/lib/systemd/system/mysqld.service<< EOF
LimitNOFILE=65535
LimitNPROC=65535          
EOF
  #添加mysql 服务开机自启动
  /bin/systemctl daemon-reload
  /bin/systemctl enable mysqld.service
  /bin/systemctl start mysqld.service
  firewall-cmd --zone=public --add-service=mysql --permanent
  firewall-cmd --reload

  if [ `check_rpm mysql-community-server` != '0' ]; then
      echo "mysql-community-server install seccuess" |tee -a {log}
      touch /var/log/mysql_install.lock
  fi

}

case1 in
db)
    epel_install
    mysql_dir=/data/mysql
    mysql56_install {mysql_dir}
    ;;
*)
    echo "USAG:0 'mysql'" 
    ;;
esac

四、github地址

https://github.com/xiangys0134/deploy/blob/master/software_install/mysql/mysql_rpm-5-6.sh

• 备注：采用官方mysql源安装速度缓慢，建议自建yum源。