ansible-playbook roles安装mysql

---

调用角色install_mysql.yml

- hosts: mysql
  vars:
    - action: install
  roles:
    - mysql

mysql roles目录结构

main.yml

- name: check mysql port {{ MYSQL_PORT }}
  shell:
    cmd: |
         if ss -nutlp | grep -w ":{{ MYSQL_PORT }} " &> /dev/null;then
             echo "Mysql Port Is Up"
         else
             echo "Mysql Port Is Down"
         fi
  register: check_result
- name: show check status
  debug: var=check_result.stdout_lines

- include: mysql.yml
  when: '"Down" in check_result.stdout and action == "install"'

- include: mysql.yml
  when: '"Up" in check_result.stdout and action == "uninstall"'

mysql.yml

- name: create {{ ANSIBLE_DIR }}/mysql
  file: path={{ ANSIBLE_DIR }}/mysql state=directory
- name: copy install_mysql.sh to {{ ANSIBLE_DIR }}/mysql
  copy: src=install_mysql.sh dest={{ ANSIBLE_DIR }}/mysql

- block:
  - name: create {{ MYSQL_DATA }}/sql
    file: path={{ MYSQL_DATA }}/sql state=directory mode=0755
  - name: copy mysqld.cnf to {{ MYSQL_DATA }}
    copy: src=mysqld.cnf dest={{ MYSQL_DATA }}
  - name: copy rpms.zip to {{ ANSIBLE_DIR }}/mysql
    copy: src=rpms.zip dest={{ ANSIBLE_DIR }}/mysql/
  when: action == "install"

- name: mysql rpm {{ action }}
  shell: cd {{ ANSIBLE_DIR }}/mysql && bash install_mysql.sh {{ action }} {{ MYSQL_DATA }} {{ MYSQL_IP }} {{ MYSQL_PORT }} {{ MYSQL_ADMIN_USER}} {{ MYSQL_ADMIN_PWD }}
  register: result
  failed_when: result.rc != 0
- name: show excute info
  debug: var=result.stdout_lines verbosity=0

install_mysql.sh

#!/bin/bash
<<INFO
AUTHOR:运维@小兵
DATE:2021-10-16
DESCRIBE:rpm方式安装MySQL
SYSTEM:CentOS7/RedHat7
WARNING:
MODIFY:
INFO

set -e
source /etc/profile                     	#避免ansible远程执行shell获取环境变量不一致的问题

WORKDIR=$(cd `dirname $0`;pwd)              #脚本所在路径
echo "Current Excute: bash ${WORKDIR}/$0 $@"

MYSQL_DATA=$2               #Mysql数据目录
MYSQL_IP=$3
MYSQL_PORT=$4
MYSQL_ADMIN_USER=$5
MYSQL_ADMIN_PWD=$6

#环境检查
Check_Env(){
    echo "INFO:Begin Check Env..."
    if ss -nutlp | grep -w ":${MYSQL_PORT} " &> /dev/null;then
        echo "INFO:Mysql Is Installed" && exit 0
    fi
    [[ ! -f ${WORKDIR}/rpms.zip ]] && echo "ERROR:${WORKDIR}/rpms.zip Not Found" && exit 1
    if [[ ! -f ${MYSQL_DATA}/mysqld.cnf ]];then
        echo "ERROR:${MYSQL_DATA}/mysqld.cnf Not Found" && exit 1
    fi
}

#安装MySQL
Install_Mysql(){
    Check_Env
    echo "INFO:Begin Install Mysql Server..."
    cd ${WORKDIR}
    unzip -qo rpms.zip
    rpm -ivh ${WORKDIR}/rpms/*.rpm --nodeps --force
    [[ ! -f /etc/my.cnf.bak ]] && cp /etc/my.cnf{,.bak}
    \cp ${MYSQL_DATA}/mysqld.cnf /etc/my.cnf
    systemctl start mysqld
    systemctl enable mysqld
}

#修改Mysql的root密码
Modify_Root_Pwd(){
    local init_password=$(grep 'temporary password' /var/log/mysqld.log | awk '{print $NF}' | tail -n1)
    mysql -uroot -p"${init_password}" --connect-expired-password -e "set password=password('${MYSQL_ADMIN_PWD}')"
    mysql -uroot -p"${MYSQL_ADMIN_PWD}" -e "create USER if NOT EXISTS ${MYSQL_ADMIN_USER}@'%' identified by '${MYSQL_ADMIN_PWD}';"
    mysql -uroot -p"${MYSQL_ADMIN_PWD}" -e "grant all privileges on *.* to ${MYSQL_ADMIN_USER}@'%' WITH GRANT OPTION;"
    mysql -uroot -p"${MYSQL_ADMIN_PWD}" -e "flush privileges;"
    if ! mysql -h${MYSQL_IP} -P${MYSQL_PORT} -u${MYSQL_ADMIN_USER} -p${MYSQL_ADMIN_PWD} -e 'show databases;' &> /dev/null;then
        echo "ERROR:Install Mysql Server Fail" && exit 1
    else
        echo "INFO:Install Mysql Server Success"
    fi
}

#卸载MySQL
Uninstall_Mysql(){
    if ! ss -nutlp | grep -w ":${MYSQL_PORT} " &> /dev/null;then
        echo "INFO:Mysql Is Uninstalled" && exit 0
    else
        systemctl stop mysqld
        yum remove mysql-community-server -y
        rm -rf ${MYSQL_DATA}
        rm -rf /var/lib/mysql
        rm -f /etc/my.cnf
        rm -f /var/log/mysqld.log
        if ! ss -nutlp | grep -w ":${MYSQL_PORT} " &> /dev/null;then
            echo "INFO:Uninstall Mysql Success"
        else
            echo "ERROR:Uninstall Mysql Fail" && exit 1
        fi
    fi
}

######################主程序######################
[[ $# -ne 6 ]] && echo "ERROR:Invalid Param!!! eg:bash $0 (install|uninstall) mysql数据目录 mysql_ip mysql端口 mysql管理员 mysql管理员密码" && exit 1
case $1 in
install)
    Install_Mysql
    Modify_Root_Pwd;;
uninstall)
    Uninstall_Mysql;;
*)
    echo "ERROR:Invalid Param!!! eg:bash $0 (install|uninstall) mysql数据目录 mysql_ip mysql端口 mysql管理员 mysql管理员密码" && exit 1
esac

mysqld.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

plugin-load=validate_password.so
validate-password=OFF
character_set_server=utf8mb4
collation-server=utf8mb4_general_ci
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
max_connections=3000
wait_timeout=3600
transaction_isolation=READ-COMMITTED
innodb_log_buffer_size=167772160
innodb_log_file_size=1024M
innodb_strict_mode=0
max_heap_table_size=512M
max_allowed_packet=67108864
lower_case_table_names=1