MySQL的部署脚本

今天不念来一个MySQL的部署脚本。同样地，先给出部署文档步骤：

1）下载

cd  /usr/local
sudo curl -O https://cdn.mysql.com/Downloads/MySQL-8.0/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz

2）解压

sudo tar Jxf mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz
sudo ln -s mysql-8.0.30-linux-glibc2.12-x86_64 mysql

3）创建用户

sudo useradd -s /sbin/nologin  mysql

4）创建数据目录

sudo mkdir -p /data/mysql
sudo chown -R mysql:mysql /data/mysql

5）定义配置文件

sudo vi  /etc/my.cnf  #写入如下内容
[mysql]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
user = mysql
port = 3306
basedir = /usr/local/mysql
datadir = /data/mysql
socket = /tmp/mysql.sock
pid-file = /data/mysql/mysqld.pid
log-error = /data/mysql/mysql.err

6）安装依赖

##Rocky / CentOS
sudo yum install -y ncurses-compat-libs-6.1-9.20180224.el8.x86_64  libaio-devel
## Ubuntu
sudo  apt install  libaio-dev libtinfo5

7）初始化

/usr/local/mysql/bin/mysqld --console --initialize-insecure --user=mysql   ## initialize-insecure使用空密码

8）启动

sudo vi /usr/lib/systemd/system/mysqld.service  #写如下内容
[Unit]
Description=MYSQL server
After=network.target
[Install]
WantedBy=multi-user.target
[Service]
Type=forking
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --daemonize $OPTIONS
ExecReload=/bin/kill -HUP -$MAINPID     #这里-HUP可以是改成-s HUP，就变成强制杀进程，有需要可以改，下面也一样
ExecStop=/bin/kill -QUIT $MAINPID        #-s QUIT是强制杀进程
KillMode=process
LimitNOFILE=65535
Restart=on-failure
RestartSec=10
RestartPreventExitStatus=1
PrivateTmp=false
### end

sudo systemctl daemon-reload
sudo systemctl enable mysqld
sudo systemctl start mysqld

9）配置环境变量

sudo vi  /etc/profile  #最后面增加下面一行内容
export PATH=$PATH:/usr/local/mysql/bin
## 然后执行下面命令，使其生效
sudo source  /etc/profile

10）设置密码

mysqladmin -uroot  password  'your_new_passwd'

将上面步骤写成脚本：

#!/bin/bash

### 设置变量 ###
mysql_url="https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz"

mysql_base_dir="/usr/local/mysql"
mysql_data_dir="/data/mysql"

mysql_root_pwd="aminglinux.Com"
mysql_rep_pwd="Aminglinux123"

##########################
ck_ok()
{
        if [ $? -ne 0 ]
        then
                echo "$1 error."
                exit 1
        fi
}
download_mysql()
{
        ##下载前，先判断当前目录下是否已经下载过
        cd /usr/local
        if [ -f mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz ]
        then
                echo "当前目录已经存在mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz"
                echo "检测md5"
                mysql_md5=`md5sum mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz|awk '{print $1}'`
                if [ ${mysql_md5} == "2469b1ae79e98110277d9b5bee301135" ]
                then
                        return 0
                else
                        sudo /bin/mv mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz.old
                fi
        fi
        sudo wget ${mysql_url}
        ck_ok "下载mysql"
}

install_mysql()
{
        cd /usr/local
        echo "解压mysql"
        sudo tar Jxf mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz
        ck_ok "解压mysql"
        if [ -d ${mysql_base_dir} ]
        then
                echo "${mysql_base_dir}已经存在，挪走"
                sudo /bin/mv ${mysql_base_dir} ${mysql_master_base_dir}-`date +%s`
        fi
        sudo mv mysql-8.0.30-linux-glibc2.12-x86_64 mysql
        if id mysql &>/dev/null
        then
                echo "系统已经存在mysql用户，跳过创建"
        else
                echo "创建mysql用户"
                sudo useradd -s /sbin/nologin  mysql
        fi

        if [ -d ${mysql_data_dir} ]
        then
                echo "${mysql_data_dir}已经存在，挪走"
                sudo /bin/mv ${mysql_data_dir} ${mysql_data_dir}-`date +%s`
        fi
        echo "创建mysql datadir"
        sudo mkdir -p ${mysql_data_dir}
        sudo chown -R mysql ${mysql_data_dir}


        if [ -f ${mysql_base_dir}/my.cnf ]
        then
                echo "master配置文件已经存在,删除"
                sudo rm -f ${mysql_base_dir}/my.cnf
        fi
        echo "创建master配置文件my.cnf"
        cat > /tmp/my.cnf <<EOF
[mysqld]
user = mysql
port = 3306
server_id = 1
basedir = ${mysql_base_dir}
datadir = ${mysql_data_dir}
socket = /tmp/mysql.sock
pid-file = ${mysql_data_dir}/mysqld.pid
log-error = ${mysql_data_dir}/mysql.err
EOF
        sudo /bin/mv /tmp/my.cnf  ${mysql_base_dir}/my.cnf

        echo "安装依赖"
        sudo  yum install -y  ncurses-compat-libs-6.1-9.20180224.el8.x86_64  libaio-devel

        echo "初始化"
        sudo ${mysql_base_dir}/bin/mysqld --console  --datadir=${mysql_data_dir} --initialize-insecure --user=mysql
        ck_ok "初始化"

        if [ -f /usr/lib/systemd/system/mysqld.service ]
        then
                echo "mysql服务管理脚本已经存在，挪走"
                sudo /bin/mv  /usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/mysqld.service-`date +%s`
        fi
        echo "创建服务启动脚本"
        cat > /tmp/mysqld.service <<EOF
[Unit]
Description=MYSQL server
After=network.target
[Install]
WantedBy=multi-user.target
[Service]
Type=forking
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=${mysql_base_dir}/bin/mysqld --defaults-file=${mysql_base_dir}/my.cnf --daemonize $OPTIONS
ExecReload=/bin/kill -HUP -$MAINPID
ExecStop=/bin/kill -QUIT $MAINPID
KillMode=process
LimitNOFILE=65535
Restart=on-failure
RestartSec=10
RestartPreventExitStatus=1
PrivateTmp=false
EOF

        sudo /bin/mv /tmp/mysqld.service /usr/lib/systemd/system/mysqld.service
        sudo systemctl unmask mysqld
        sudo systemctl daemon-reload
        sudo systemctl enable mysqld
        echo "启动mysql"
        sudo systemctl start mysqld
        ck_ok "启动mysql"


        echo "设置mysql密码"
        ${mysql_base_dir}/bin/mysqladmin -S/tmp/mysql.sock -uroot  password "${mysql_root_pwd}"
        ck_ok "设置mysql密码"
}

main()
{
        download_mysql
        install_mysql
}

main

写脚本最重要的是思路，有了思路，有了命令，还难么？

当然，我们还需要考虑到脚本可能出现的异常，比如下载的包不对，很有可能导致后面的解压出错。

所以就需要先判断下载的包到底对不对。

不过，这个能力就需要一点一点积累了，多写多练肯定是没错的。