Shell脚本一键部署-----源码编译安装MySQL数据库

1. 准备好mysql软件包

编写脚本前先将软件包拖到/opt目录下即可

编写一个脚本文件，将以下内容复制进去，使用source或者 . 执行脚本

2. MySQL一键部署脚本(使用source或者./执行脚本。等脚本执行完成，使用mysql -u root -p点击回车即可)

    #!/bin/bash
    echo -e "\033[31m =====正在验证当前为仅主机还是NAT模式===== \033[0m"
    ping -c1 -W1 www.baidu.com &> /dev/null
    if [ $? -eq 0 ];then echo -e "\033[31m 检测当前为NAT模式，为您配置在线yum源 \033[0m"
    mkdir -p /etc/yum.repos.d/repo.bak

    mv -f /etc/yum.repos.d/* /etc/yum.repos.d/repo.bak &> /dev/null

    wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo &> /dev/null

    yum clean all &> /dev/null
    yum list &> /dev/null
    echo -e "\033[31m 在线源已配置完成 \033[0m"

    else
    echo -e "\033[31m 检测当前为仅主机模式，为您配置本地yum源 \033[0m"
    mount /dev/sr0 /mnt &> /dev/null
    cd /etc/yum.repos.d/
    mkdir -p /etc/yum.repos.d/repo.bak

    mv -f /etc/yum.repos.d/* /etc/yum.repos.d/repo.bak &> /dev/null

    echo '[local]
    name=local
    baseurl=file:///mnt
    enabled=1
    gpgcheck=0' > /etc/yum.repos.d/local.repo
    yum clean all &> /dev/null
    yum makecache &> /dev/null

    df -h | grep "/mnt"
    if [ $? -ne 0 ];then
    echo -e "\033[31m 检测当前为仅主机模式，但光盘未连接！ \033[0m"
    else
    echo -e "\033[31m 本地yum源已配置完成 \033[0m"
    fi
    fi

    #关闭系统防火墙和安全机制
    systemctl stop firewalld
    systemctl disable firewalld
    setenforce 0

    echo -e "\033[31m 检查安装包是否正确，请耐心等待 \033[0m"
    ls /opt | egrep "^mysql-boost-5.7.20.tar.gz$"
    if [ $? -eq 0 ];then
    echo -e "\033[31m 接下来进入正式配置，请耐心等待 \033[0m"
    else
    echo -e "\033[31m 请准备正确安装包mysql-boost-5.7.20.tar.gz \033[0m"
    exit
    fi


    #安装Mysql环境依赖包
    yum -y install \
    ncurses \
    ncurses-devel \
    bison \
    cmake \
    gcc \
    gcc-c++ \
    make

    #创建程序用户，便于准确控制访问用户
    useradd -M -s /sbin/nologin mysql

    #编译安装
    cd /opt
    tar xzvf mysql-boost-5.7.20.tar.gz -C /opt

    cd /opt/mysql-5.7.20/
    cmake \
    -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
    -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
    -DSYSCONFDIR=/etc \
    -DSYSTEMD_PID_DIR=/usr/local/mysql \
    -DDEFAULT_CHARSET=utf8 \
    -DDEFAULT_COLLATION=utf8_general_ci \
    -DWITH_EXTRA_CHARSETS=all \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
    -DMYSQL_DATADIR=/usr/local/mysql/data \
    -DWITH_BOOST=boost \
    -DWITH_SYSTEMD=1

    #编译及安装
    make && make install

    #修改mysql 配置文件
    echo '[client]
    port = 3306
    socket=/usr/local/mysql/mysql.sock

    [mysqld]
    user = mysql
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data
    port = 3306
    character-set-server=utf8
    pid-file = /usr/local/mysql/mysqld.pid
    socket=/usr/local/mysql/mysql.sock
    bind-address = 0.0.0.0
    skip-name-resolve
    max_connections=2048
    default-storage-engine=INNODB
    max_allowed_packet=16M
    server-id = 1

    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES' > /etc/my.cnf


    #更改mysql安装目录和配置文件的属主属组
    chown -R mysql:mysql /usr/local/mysql/
    chown mysql:mysql /etc/my.cnf

    #设置路径环境变量
    echo "export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib">> /etc/profile
    source /etc/profile

    #初始化数据库
    cd /usr/local/mysql/bin/
    ./mysqld \
    --initialize-insecure \
    --user=mysql \
    --basedir=/usr/local/mysql \
    --datadir=/usr/local/mysql/data

    #添加mysqld系统服务
    cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/


    systemctl daemon-reload
    systemctl start mysqld.service
    systemctl enable mysqld