在知识库中专注阅读，并随时返回相关工具与课程
大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。 @TOC目录 昨天群里有位朋友分享了芬达大佬的 MySQL 部署工具：dbops，抱着试一试的心态玩了一把，确实很给力。今天给大家分享一下，完全免费哦！ dbops 是一套高效的 ansible playbook 集合，目前是一个可以自动化安装和部署生产级别的 MySQL 及周边生态的工具。dbops 正在持续迭代开发中，目前已
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
昨天群里有位朋友分享了芬达大佬的 MySQL 部署工具：dbops，抱着试一试的心态玩了一把，确实很给力。今天给大家分享一下，完全免费哦！
dbops 是一套高效的 ansible playbook 集合，目前是一个可以自动化安装和部署生产级别的 MySQL 及周边生态的工具。dbops 正在持续迭代开发中，目前已经支持：
dbops 的理念：
Code as Standrad 这个理念由芬达提出，目的是减少对部署规范文档的依赖，通过 playbook 编码来固定部署规范。如果你使用 dbops 进行部署，那就相当于满足了交维规范。
目前支持的数据库小版本的硬限制：
请注意，这些仅仅是硬编码到
pre_tasks/validate_common_config_setting.yml的硬限制，是由于作者没有测过小于等于这些版本。特殊需要时，用户也可以自行修改代码，放开限制。
支持的系统和数据库架构：
ansible：
mysql-ansible：
opengauss-ansible：
注意，作者在开发时已考虑了某些系统或版本的兼容性，经过判断后填写了 Y，但实际上并未进行过严格实测。
这里建议下载稳定发行版，如果需要测试可以下载开发版进行尝鲜。
Gitee 下载地址：https://gitee.com/fanderchan/dbops
选择 克隆/下载即可：
我这里是通过服务器联网直接下载的方式：
1# 挂载本地 ISO2mount /dev/sr0 /mnt/34# 配置本地 YUM 源5## 备份系统初始配置文件6mkdir -p /etc/yum.repos.d/bak7mv /etc/yum.repos.d/* /etc/yum.repos.d/bak8## 一键配置软件源，默认 ISO 安装镜像挂载在 /mnt 目录下9cat<<-EOF>/etc/yum.repos.d/local.repo10[server]11name=server12baseurl=file:///mnt13enabled=114gpgcheck=015EOF16## 查看配置好的软件源17cat /etc/yum.repos.d/local.repo1819# 最小化安装需要自行安装 wget 功能20yum install -y wget2122# 通过 wget 方式下载稳定发行版23cd ~24dbops_version="1.4.20240729"25wget https://gitee.com/fanderchan/dbops/releases/download/dbops.${dbops_version}/dbops.${dbops_version}-Linux-x86_64.tar.gz无法联网的朋友建议直接下载上传即可。
为了降低 Ansible 部署难度和兼容性问题，统一版本以避免因使用不同版本产生 bug，所以作者特意采用了绿色版 Ansible 2.10.5，并集成到了 dbops 中。部署过程中，系统会自动安装 Python3，并搭配使用 Python3 和 Ansible 2.10.5。为加快 dbops 的下载速度，作者精简了绿色版 Ansible 中不常用的功能，使其体积非常小。ansible-portable 目录压缩后仅有 3.6 MB，整个 dbops.tar.gz 压缩包仅有 20 MB！
作者推荐将安装路径设置为 /usr/local：
1# 解压2[root@mysql8 ~]# tar zxvf dbops.1.4.20240729-Linux-x86_64.tar.gz -C /usr/local34# 查看解压后的目录5[root@mysql8 ~]# cd /usr/local/dbops/6[root@mysql8 dbops]# ll7total 208-rw-r--r--. 1 root root 11356 Jul 29 16:41 LICENSE9drwxr-xr-x. 6 root root 148 Jul 29 16:41 mysql_ansible10drwxr-xr-x. 6 root root 120 Jul 29 16:41 opengauss_ansible11drwxr-xr-x. 3 root root 97 Jul 29 16:41 portable-ansible-v0.5.0-py312-rw-r--r--. 1 root root 915 Jul 29 16:41 README.en.md13-rw-r--r--. 1 root root 58 Jul 29 16:41 README.md进入目录，执行 shell 脚本：
1[root@mysql8 dbops]# cd /usr/local/dbops/portable-ansible-v0.5.0-py32[root@mysql8 portable-ansible-v0.5.0-py3]# sh setup_portable_ansible.sh3Loaded plugins: fastestmirror4Loading mirror speeds from cached hostfile5Resolving Dependencies6--> Running transaction check7---> Package python3.x86_64 0:3.6.8-17.el7 will be installed8--> Processing Dependency: python3-libs(x86-64) = 3.6.8-17.el7 for package: python3-3.6.8-17.el7.x86_649--> Processing Dependency: python3-setuptools for package: python3-3.6.8-17.el7.x86_6410--> Processing Dependency: python3-pip for package: python3-3.6.8-17.el7.x86_6411--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-17.el7.x86_6412--> Running transaction check13---> Package python3-libs.x86_64 0:3.6.8-17.el7 will be installed14--> Processing Dependency: libtirpc.so.1()(64bit) for package: python3-libs-3.6.8-17.el7.x86_6415---> Package python3-pip.noarch 0:9.0.3-8.el7 will be installed16---> Package python3-setuptools.noarch 0:39.2.0-10.el7 will be installed17--> Running transaction check18---> Package libtirpc.x86_64 0:0.2.4-0.16.el7 will be installed19--> Finished Dependency Resolution2021Dependencies Resolved2223=====================================================================================================================================================================================================24 Package Arch Version Repository Size25=====================================================================================================================================================================================================26Installing:27 python3 x86_64 3.6.8-17.el7 server 70 k28Installing for dependencies:29 libtirpc x86_64 0.2.4-0.16.el7 server 89 k30 python3-libs x86_64 3.6.8-17.el7 server 6.9 M31 python3-pip noarch 9.0.3-8.el7 server 1.6 M32 python3-setuptools noarch 39.2.0-10.el7 server 629 k3334Transaction Summary35=====================================================================================================================================================================================================36Install 1 Package (+4 Dependent packages)3738Total download size: 9.3 M39Installed size: 48 M40Downloading packages:41-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------42Total 114 MB/s | 9.3 MB 00:00:00 43Running transaction check44Running transaction test45Transaction test succeeded46Running transaction47 Installing : libtirpc-0.2.4-0.16.el7.x86_64 1/5 48 Installing : python3-pip-9.0.3-8.el7.noarch 2/5 49 Installing : python3-setuptools-39.2.0-10.el7.noarch 3/5 50 Installing : python3-3.6.8-17.el7.x86_64 4/5 51 Installing : python3-libs-3.6.8-17.el7.x86_64 5/5 52 Verifying : libtirpc-0.2.4-0.16.el7.x86_64 1/5 53 Verifying : python3-pip-9.0.3-8.el7.noarch 2/5 54 Verifying : python3-3.6.8-17.el7.x86_64 3/5 55 Verifying : python3-setuptools-39.2.0-10.el7.noarch 4/5 56 Verifying : python3-libs-3.6.8-17.el7.x86_64 5/5 5758Installed:59 python3.x86_64 0:3.6.8-17.el7 6061Dependency Installed:62 libtirpc.x86_64 0:0.2.4-0.16.el7 python3-libs.x86_64 0:3.6.8-17.el7 python3-pip.noarch 0:9.0.3-8.el7 python3-setuptools.noarch 0:39.2.0-10.el7 6364Complete!65which: no sshpass in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)66Please run 'source ~/.bashrc' to apply the changes in your current shell.生效 .bashrc：
1[root@mysql8 portable-ansible-v0.5.0-py3]# source ~/.bashrc确认是否部署成功：
1[root@mysql8 portable-ansible-v0.5.0-py3]# ansible --version2ansible 2.10.53 config file = None4 configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']5 ansible python module location = /usr/local/dbops/portable-ansible-v0.5.0-py3/ansible/ansible6 executable location = /usr/local/dbops/portable-ansible-v0.5.0-py3/ansible7 python version = 3.6.8 (default, Oct 13 2020, 16:18:22) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)]python 版本是 3.x 为正确。ansible 版本为 2.10.5 为正确。
dbops 支持的部署架构中有些至少需要 3 台机器，例如 MySQL 的 MGR 架构。建议 dbops 独立用一台机器，那么整套实验就至少需要 4 台机器。如果实在没办法，可以把 dbops 部署到第一台 MySQL 复用机器。
本次只演示单机模式部署，dbops 和 MySQL 共用一台服务器主机。
修改 hosts.ini，添加需要操作的机器进去：
1## 进入 hosts.ini 所在目录2[root@mysql8 inventory]# pwd3/usr/local/dbops/mysql_ansible/inventory45## 修改 hosts.ini 中对应的 IP 和 root 密码6[root@mysql8 inventory]# vi hosts.ini 7[root@mysql8 inventory]# cat hosts.ini 8[dbops_mysql]9192.168.168.162 ansible_user=root ansible_ssh_pass="'oracle'"1011[all:vars]12#ansible_python_interpreter=/usr/bin/python3建议在配置完 host.ini 之后验证一下服务器的连通性：
1[root@mysql8 playbooks]# pwd2/usr/local/dbops/mysql_ansible/playbooks3[root@mysql8 playbooks]# ansible all -m ping4192.168.6.162 | SUCCESS => {5 "ansible_facts": {6 "discovered_interpreter_python": "/usr/bin/python"7 },8 "changed": false,9 "ping": "pong"10}修改公共配置参数文件 common_config.yml：
1## 主要关注 MySQL 版本和端口号，如果不需要修改则跳过2[root@mysql8 playbooks]# pwd3/usr/local/dbops/mysql_ansible/playbooks4[root@mysql8 playbooks]# grep mysql_version: common_config.yml 5mysql_version: "8.4.0"6[root@mysql8 playbooks]# grep mysql_port: common_config.yml 7mysql_port: 3306上传安装包：
MySQL 安装包下载地址：MySQL Product Archives
选择安装包版本时，需要注意主机的 glibc 版本以及 CPU 架构：
1## glibc 版本2[root@mysql8 ~]# ldd --version3ldd (GNU libc) 2.174Copyright (C) 2012 Free Software Foundation, Inc.5This is free software; see the source for copying conditions. There is NO6warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.7Written by Roland McGrath and Ulrich Drepper.8## CPU 架构9[root@mysql8 ~]# uname -m10x86_64下载完成后上传至指定目录：
1[root@mysql8 downloads]# pwd2/usr/local/dbops/mysql_ansible/downloads3[root@mysql8 downloads]# ll4total 598725-rw-r--r--. 1 root root 61305888 Aug 23 16:03 mysql-8.4.0-linux-glibc2.17-x86_64-minimal.tar.xz执行 playbook 部署，安装过程不需要联网：
1[root@mysql8 playbooks]# pwd2/usr/local/dbops/mysql_ansible/playbooks3[root@mysql8 playbooks]# ansible-playbook single_node.yml45PLAY [Deploy single-node MySQL server using binary installation] ************************************************************************************************************************************67TASK [Gathering Facts] ******************************************************************************************************************************************************************************8ok: [192.168.6.162]910TASK [Check if password meets complexity requirements] **********************************************************************************************************************************************11ok: [192.168.6.162] => (item=None)12ok: [192.168.6.162] => (item=None)13ok: [192.168.6.162] => (item=None)14ok: [192.168.6.162] => (item=None)15ok: [192.168.6.162] => (item=None)16ok: [192.168.6.162] => (item=None)17ok: [192.168.6.162]1819TASK [Print custom error message] *******************************************************************************************************************************************************************20skipping: [192.168.6.162]2122TASK [Validate fcs_ setting are 0 or 1] *************************************************************************************************************************************************************23skipping: [192.168.6.162] => (item=fcs_skip_db_mount_verification) 24skipping: [192.168.6.162] => (item=fcs_skip_check_ntpd_or_chrony_running) 25skipping: [192.168.6.162] => (item=fcs_auto_download_mysql) 26skipping: [192.168.6.162] => (item=fcs_create_mysql_fast_login) 27skipping: [192.168.6.162] => (item=fcs_backup_script_create_backup_user) 28skipping: [192.168.6.162] => (item=fcs_mysql_use_jemalloc) 29skipping: [192.168.6.162] => (item=fcs_use_greatsql_ha) 3031TASK [Validate mysql_port is within range] **********************************************************************************************************************************************************32skipping: [192.168.6.162]3334TASK [Validate mysql_version is within range] *******************************************************************************************************************************************************35skipping: [192.168.6.162]3637TASK [Validate mysql_version is within range] *******************************************************************************************************************************************************38skipping: [192.168.6.162]3940TASK [Validate db_type is a valid option] ***********************************************************************************************************************************************************41skipping: [192.168.6.162]4243TASK [Validate server_specs is a valid option] ******************************************************************************************************************************************************44skipping: [192.168.6.162]4546TASK [Check if mysql-8.4.0-linux-glibc2.17-x86_64-minimal.tar.xz exists in ../downloads/ (local)] ***************************************************************************************************47changed: [192.168.6.162]4849TASK [Set the OS type variable] *********************************************************************************************************************************************************************50ok: [192.168.6.162]5152TASK [Print the OS type] ****************************************************************************************************************************************************************************53ok: [192.168.6.162] => {54 "msg": "The OS type of host 192.168.6.162 is CentOS7"55}5657TASK [Assert if OS type is supported] ***************************************************************************************************************************************************************58ok: [192.168.6.162] => {59 "changed": false,60 "msg": "All assertions passed"61}6263TASK [Check for Python 3] ***************************************************************************************************************************************************************************64ok: [192.168.6.162]6566TASK [Check for Python 2] ***************************************************************************************************************************************************************************67ok: [192.168.6.162]6869TASK [Set Python interpreter] ***********************************************************************************************************************************************************************70ok: [192.168.6.162]7172TASK [Print the Python interpreter] *****************************************************************************************************************************************************************73ok: [192.168.6.162] => {74 "msg": "The Python interpreter of host 192.168.6.162 is /usr/bin/python2"75}7677TASK [Set server_specs_processor_count and server_specs_memtotal_gb based on server_specs] **********************************************************************************************************78skipping: [192.168.6.162]7980TASK [Gen random MySQL server_id] *******************************************************************************************************************************************************************81ok: [192.168.6.162]8283TASK [Collect mysql_server_id to a list on localhost] ***********************************************************************************************************************************************84ok: [192.168.6.162]8586TASK [Check for duplicate mysql_server_id] **********************************************************************************************************************************************************87ok: [192.168.6.162] => {88 "changed": false,89 "msg": "All assertions passed"90}9192TASK [Generate random UUID if mgr_use_random_uuid is set to 1] **************************************************************************************************************************************93changed: [192.168.6.162]9495TASK [set_fact] *************************************************************************************************************************************************************************************96ok: [192.168.6.162]9798TASK [Display the list of target hosts and additional information] **********************************************************************************************************************************99ok: [192.168.6.162] => {100 "msg": [101 "Hosts to be affected by Deploy single-node MySQL server using binary installation: 192.168.6.162",102 "DB type: mysql",103 "MySQL port: 3306",104 "MySQL version: 8.4.0",105 "Server specs: auto",106 "Roles to be executed: ../roles/pre_check_and_set, ../roles/mysql_server"107 ]108}109110TASK [Prompt user for confirmation] *****************************************************************************************************************************************************************111[Prompt user for confirmation]112This will perform Deploy single-node MySQL server using binary installation on the displayed hosts. Please type 'confirm' to continue or press Ctrl+C to cancel.:113ok: [192.168.6.162]114115TASK [Check if user confirmed] **********************************************************************************************************************************************************************116skipping: [192.168.6.162]117118TASK [Include role] *********************************************************************************************************************************************************************************119120TASK [../roles/pre_check_and_set : Check yum and install libselinux-python3] ************************************************************************************************************************121ok: [192.168.6.162]122123TASK [../roles/pre_check_and_set : Install ncurses-compat-libs if necessary] ************************************************************************************************************************124skipping: [192.168.6.162]125126TASK [../roles/pre_check_and_set : Intall tar for openEuler20] **************************************************************************************************************************************127ok: [192.168.6.162]128129TASK [../roles/pre_check_and_set : Set SeLinux disabled] ********************************************************************************************************************************************130[WARNING]: SELinux state change will take effect next reboot131ok: [192.168.6.162]132133TASK [../roles/pre_check_and_set : Stop and Disabled Firewalld] *************************************************************************************************************************************134ok: [192.168.6.162]135136TASK [../roles/pre_check_and_set : Gather service facts] ********************************************************************************************************************************************137skipping: [192.168.6.162]138139TASK [../roles/pre_check_and_set : Assert NTP or Chrony is running and only one is enabled] *********************************************************************************************************140skipping: [192.168.6.162]141142TASK [../roles/pre_check_and_set : Check whether NUMA is turned off] ********************************************************************************************************************************143fatal: [192.168.6.162]: FAILED! => {"changed": false, "cmd": ["grep", "-q", "numa=off", "/proc/cmdline"], "delta": "0:00:00.004868", "end": "2024-08-23 16:07:01.721770", "msg": "non-zero return code", "rc": 1, "start": "2024-08-23 16:07:01.716902", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []}144...ignoring145146TASK [../roles/pre_check_and_set : Show warning if NUMA is not turned off] **************************************************************************************************************************147ok: [192.168.6.162] => {148 "msg": "Warning: NUMA is not turned off."149}150151TASK [../roles/pre_check_and_set : Update sysctl configuration file] ********************************************************************************************************************************152ok: [192.168.6.162]153154TASK [../roles/pre_check_and_set : Reload sysctl] ***************************************************************************************************************************************************155changed: [192.168.6.162]156157TASK [../roles/pre_check_and_set : Extract parent directories of mysql_data_dir_base] ***************************************************************************************************************158skipping: [192.168.6.162]159160TASK [../roles/pre_check_and_set : Remove root '/' from parent directories list] ********************************************************************************************************************161skipping: [192.168.6.162]162163TASK [../roles/pre_check_and_set : Check if mount points exist for pre_check_and_set__mysql_data_dir_base_parents list] *****************************************************************************164skipping: [192.168.6.162]165166TASK [../roles/pre_check_and_set : Find the first matching mount point for mysql_data_dir_base and its parents] *************************************************************************************167skipping: [192.168.6.162] => (item={'block_used': 35061, 'uuid': '3d53107e-ce12-4c21-a78d-82f97fef2750', 'size_total': 1063256064, 'block_total': 259584, 'mount': '/boot', 'block_available': 224523, 'size_available': 919646208, 'fstype': 'xfs', 'inode_total': 524288, 'options': 'rw,seclabel,relatime,attr2,inode64,noquota', 'device': '/dev/sda1', 'inode_used': 326, 'block_size': 4096, 'inode_available': 523962}) 168skipping: [192.168.6.162] => (item={'block_used': 4980714, 'uuid': '2020-11-02-15-15-23-00', 'size_total': 10200502272, 'block_total': 4980714, 'mount': '/mnt', 'block_available': 0, 'size_available': 0, 'fstype': 'iso9660', 'inode_total': 0, 'options': 'ro,relatime', 'device': '/dev/sr0', 'inode_used': 0, 'block_size': 2048, 'inode_available': 0}) 169skipping: [192.168.6.162] => (item={'block_used': 379986, 'uuid': '3342f530-81a3-43d8-8405-5f4ecb2d6389', 'size_total': 97658605568, 'block_total': 23842433, 'mount': '/', 'block_available': 23462447, 'size_available': 96102182912, 'fstype': 'xfs', 'inode_total': 47708160, 'options': 'rw,seclabel,relatime,attr2,inode64,noquota', 'device': '/dev/mapper/centos-root', 'inode_used': 34255, 'block_size': 4096, 'inode_available': 47673905}) 170171TASK [../roles/pre_check_and_set : Debug output for mount point] ************************************************************************************************************************************172skipping: [192.168.6.162]173174TASK [../roles/pre_check_and_set : Assert mount point is using xfs filesystem] **********************************************************************************************************************175skipping: [192.168.6.162]176177TASK [../roles/pre_check_and_set : If it is a physical machine, double network card binding is required] ********************************************************************************************178ok: [192.168.6.162] => {179 "msg": "ens192"180}181182TASK [../roles/pre_check_and_set : If it is a physical machine, double network card binding is required] ********************************************************************************************183skipping: [192.168.6.162]184185TASK [../roles/pre_check_and_set : Add network interface alias to a temporary file] *****************************************************************************************************************186changed: [192.168.6.162]187188TASK [../roles/pre_check_and_set : Fetch copy] ******************************************************************************************************************************************************189changed: [192.168.6.162]190191TASK [../roles/pre_check_and_set : Append file /tmp/net_aliases.txt (delegate to 127.0.0.1)] ********************************************************************************************************192ok: [192.168.6.162]193194TASK [../roles/pre_check_and_set : Check if shell output is 1] **************************************************************************************************************************************195ok: [192.168.6.162] => {196 "changed": false,197 "msg": "All assertions passed"198}199200TASK [../roles/pre_check_and_set : Delete /tmp/net_aliases.txt] *************************************************************************************************************************************201changed: [192.168.6.162]202203TASK [../roles/pre_check_and_set : Delete /tmp/ssh/ (delegate to 127.0.0.1)] ************************************************************************************************************************204changed: [192.168.6.162]205206TASK [../roles/mysql_server : Check if flag exists or not] ******************************************************************************************************************************************207ok: [192.168.6.162]208209TASK [../roles/mysql_server : Fail if flag exists] **************************************************************************************************************************************************210skipping: [192.168.6.162]211212TASK [../roles/mysql_server : Check port not in use —— mysql port 3306] *****************************************************************************************************************************213ok: [192.168.6.162]214215TASK [../roles/mysql_server : Ensure group "mysql" exists] ******************************************************************************************************************************************216ok: [192.168.6.162]217218TASK [../roles/mysql_server : Create mysql user] ****************************************************************************************************************************************************219changed: [192.168.6.162]220221TASK [../roles/mysql_server : Create mysql directories] *********************************************************************************************************************************************222ok: [192.168.6.162] => (item=/database/mysql/etc)223ok: [192.168.6.162] => (item=/database/mysql/data)224ok: [192.168.6.162] => (item=/database/mysql/tmp)225ok: [192.168.6.162] => (item=/database/mysql/run)226ok: [192.168.6.162] => (item=/database/mysql/log/binlog)227ok: [192.168.6.162] => (item=/database/mysql/log/redolog)228ok: [192.168.6.162] => (item=/database/mysql/log/relaylog)229ok: [192.168.6.162] => (item=/database/mysql/etc/3306)230ok: [192.168.6.162] => (item=/database/mysql/data/3306)231ok: [192.168.6.162] => (item=/database/mysql/tmp/3306)232ok: [192.168.6.162] => (item=/database/mysql/log/binlog/3306)233ok: [192.168.6.162] => (item=/database/mysql/log/redolog/3306)234ok: [192.168.6.162] => (item=/database/mysql/log/relaylog/3306)235ok: [192.168.6.162] => (item=/database/mysql/base/8.4.0)236237TASK [../roles/mysql_server : Config /etc/my.cnf for mysql-5.7.x] ***********************************************************************************************************************************238skipping: [192.168.6.162]239240TASK [../roles/mysql_server : Config /etc/my.cnf for mysql-8.0.x] ***********************************************************************************************************************************241skipping: [192.168.6.162]242243TASK [../roles/mysql_server : Config /etc/my.cnf for mysql-8.4.x] ***********************************************************************************************************************************244changed: [192.168.6.162]245246TASK [../roles/mysql_server : Config /etc/my.cnf for percona-5.7.x] *********************************************************************************************************************************247skipping: [192.168.6.162]248249TASK [../roles/mysql_server : Config /etc/my.cnf for percona-8.0.x] *********************************************************************************************************************************250skipping: [192.168.6.162]251252TASK [../roles/mysql_server : Config /etc/my.cnf for greatsql-5.7.x] ********************************************************************************************************************************253skipping: [192.168.6.162]254255TASK [../roles/mysql_server : Config /etc/my.cnf for greatsql-8.0.x] ********************************************************************************************************************************256skipping: [192.168.6.162]257258TASK [../roles/mysql_server : Install libaio and numactl] *******************************************************************************************************************************************259ok: [192.168.6.162] => (item={'name': 'libaio'})260ok: [192.168.6.162] => (item={'name': 'numactl'})261262TASK [../roles/mysql_server : Install jemalloc using yum] *******************************************************************************************************************************************263skipping: [192.168.6.162]264265TASK [../roles/mysql_server : Set jemalloc rpm file name based on OS] *******************************************************************************************************************************266skipping: [192.168.6.162]267268TASK [../roles/mysql_server : Copy jemalloc rpm to target server] ***********************************************************************************************************************************269skipping: [192.168.6.162]270271TASK [../roles/mysql_server : Install jemalloc from local file] *************************************************************************************************************************************272skipping: [192.168.6.162]273274TASK [../roles/mysql_server : Check if jemalloc installation failed] ********************************************************************************************************************************275skipping: [192.168.6.162]276277TASK [../roles/mysql_server : Check if MySQL package exists locally(local)] *************************************************************************************************************************278ok: [192.168.6.162]279280TASK [../roles/mysql_server : Fail if MySQL package not found and auto download is disabled(local)] *************************************************************************************************281skipping: [192.168.6.162]282283TASK [../roles/mysql_server : Download MySQL binary tarball if not found locally and auto download is enabled(local)] *******************************************************************************284skipping: [192.168.6.162]285286TASK [../roles/mysql_server : Download GreatSQL binary tarball if not found locally and auto download is enabled(local)] ****************************************************************************287skipping: [192.168.6.162]288289TASK [../roles/mysql_server : Transfer MySQL install package to remote host] ************************************************************************************************************************290changed: [192.168.6.162]291292TASK [../roles/mysql_server : Unarchive MySQL install package to /database/mysql/base/8.4.0] ********************************************************************************************************293changed: [192.168.6.162]294295TASK [../roles/mysql_server : Touch unarchive_mysql_package_finished file] **************************************************************************************************************************296changed: [192.168.6.162]297298TASK [../roles/mysql_server : Change owner to mysql user] *******************************************************************************************************************************************299changed: [192.168.6.162]300301TASK [../roles/mysql_server : Make link /database/mysql/mysql-xx.yy.gz to /usr/local/mysql] *********************************************************************************************************302changed: [192.168.6.162]303304TASK [../roles/mysql_server : Export mysql share object (*.os)] *************************************************************************************************************************************305changed: [192.168.6.162]306307TASK [../roles/mysql_server : Load share object] ****************************************************************************************************************************************************308ok: [192.168.6.162]309310TASK [../roles/mysql_server : Export path env variable] *********************************************************************************************************************************************311changed: [192.168.6.162]312313TASK [../roles/mysql_server : Export path env to /root/.bashrc] *************************************************************************************************************************************314changed: [192.168.6.162]315316TASK [../roles/mysql_server : Export path env to /home/mysql/.bashrc] *******************************************************************************************************************************317changed: [192.168.6.162]318319TASK [../roles/mysql_server : Remove /usr/include/mysql] ********************************************************************************************************************************************320ok: [192.168.6.162]321322TASK [../roles/mysql_server : Export include file to /usr/include/mysql] ****************************************************************************************************************************323changed: [192.168.6.162]324325TASK [../roles/mysql_server : Create symbolic links for libssl.so and libcrypto.so] *****************************************************************************************************************326skipping: [192.168.6.162] => (item={'src': 'libssl.so.10', 'dest': 'libssl.so'}) 327skipping: [192.168.6.162] => (item={'src': 'libcrypto.so.10', 'dest': 'libcrypto.so'}) 328329TASK [../roles/mysql_server : Initialize-insecure for mysql-5.7.x] **********************************************************************************************************************************330skipping: [192.168.6.162]331332TASK [../roles/mysql_server : Initialize-insecure for mysql-8.0.x or mysql-8.4.x] *******************************************************************************************************************333changed: [192.168.6.162]334335TASK [../roles/mysql_server : Create systemd config file] *******************************************************************************************************************************************336changed: [192.168.6.162]337338TASK [../roles/mysql_server : Start mysql(sytemctl)] ************************************************************************************************************************************************339changed: [192.168.6.162]340341TASK [../roles/mysql_server : Config mysql.service start up on boot] ********************************************************************************************************************************342changed: [192.168.6.162]343344TASK [../roles/mysql_server : Mysql status] *********************************************************************************************************************************************************345ok: [192.168.6.162]346347TASK [../roles/mysql_server : Transfer sql statement to remote] *************************************************************************************************************************************348changed: [192.168.6.162]349350TASK [../roles/mysql_server : Make mysql secure] ****************************************************************************************************************************************************351changed: [192.168.6.162]352353TASK [../roles/mysql_server : Remove temp file /tmp/make_mysql_secure.sql] **************************************************************************************************************************354changed: [192.168.6.162]355356TASK [../roles/mysql_server : Ensure expect is installed] *******************************************************************************************************************************************357changed: [192.168.6.162]358359TASK [../roles/mysql_server : Transfer expect script to remote host] ********************************************************************************************************************************360changed: [192.168.6.162]361362TASK [../roles/mysql_server : Execute expect script to set MySQL login-path] ************************************************************************************************************************363[WARNING]: Module remote_tmp /home/mysql/.ansible/tmp did not exist and was created with a mode of 0700, this may cause issues when running as another user. To avoid this, create the remote_tmp364dir with the correct permissions manually365ok: [192.168.6.162]366367TASK [../roles/mysql_server : Set up alias in .bashrc named —— db3306] ******************************************************************************************************************************368changed: [192.168.6.162]369370TASK [../roles/mysql_server : Remove expect script from remote host] ********************************************************************************************************************************371changed: [192.168.6.162]372373TASK [../roles/mysql_server : Touch single_finish.flag] *********************************************************************************************************************************************374changed: [192.168.6.162]375376PLAY RECAP ******************************************************************************************************************************************************************************************377192.168.6.162 : ok=66 changed=31 unreachable=0 failed=0 skipped=36 rescued=0 ignored=1 378379Playbook run took 0 days, 0 hours, 1 minutes, 42 seconds整个过程十分丝滑，大概需要 1~2 分钟就完成了，中间会有一步需要确认信息，输入 confirm 回车即可！
使用 mysql 用户连接 MySQL，默认密码为 Dbops@8888：
1[root@mysql8 playbooks]# su - mysql2Last login: Fri Aug 23 15:54:50 CST 2024 on pts/03[mysql@mysql8 ~]$ mysql -uadmin -h127.0.0.1 -P3306 -pDbops@8888 -e "select @@version"4mysql: [Warning] Using a password on the command line interface can be insecure.5+-----------+6| @@version |7+-----------+8| 8.4.0 |9+-----------+使用快速登录连接，这里其实是做了 alias 别名：
1## 查看 alias 别名2[mysql@mysql8 ~]$ alias | grep db33063alias db3306='mysql --login-path=db3306'45## 连接 MySQL 数据库6[mysql@mysql8 ~]$ db33067Welcome to the MySQL monitor. Commands end with ; or \g.8Your MySQL connection id is 119Server version: 8.4.0 MySQL Community Server - GPL1011Copyright (c) 2000, 2024, Oracle and/or its affiliates.1213Oracle is a registered trademark of Oracle Corporation and/or its14affiliates. Other names may be trademarks of their respective15owners.1617Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.1819mysql> show databases;20+--------------------+21| Database |22+--------------------+23| information_schema |24| mysql |25| performance_schema |26| sys |27+--------------------+284 rows in set (0.01 sec)对于任何 playbook，执行前都只需要做三件事即可
可以发现，如果熟悉了整个流程之后，部署将变得十分简单，特别是多台并行部署行，可以在几分钟内部署几十上百套数据库，总之 Niubility。
Oracle RAC 启动顺序，你真的了解吗？ 达梦数据库一键安装脚本（免费）一篇文章让你彻底掌握 Python 🔥
一篇文章让你彻底掌握 Shell 🔥
Oracle 监控 EMCC 13.5 安装部署超详细教程 🔥
Oracle 一键巡检自动生成 Word 报告 🔥
Oracle一键安装脚本的 21 个疑问与解答 🔥
Oracle一键巡检脚本的 21 个疑问与解答 🔥
全网首发：Oracle 23ai 一键安装脚本 🔥
Oracle 19C 最新 RU 补丁 19.24 ，一键安装！ 🔥
Oracle Linux 6 一键安装 Oracle 11GR2 RAC
Oracle Linux 7.9 一键安装 Oracle 19C
Oracle Linux 8.9 一键安装 Oracle 19C RAC
Oracle Linux 9.4(aarch64) 一键安装 Oracle 19C 🔥
openEuler 20.03 LTS SP4 一键安装 Oracle 19C 🔥
openEuler 22.03 LTS SP4 一键安装 Oracle 19C RAC
RHEL 7.9 一键安装 Oracle 19C 19.23 RAC
Redhat 8.4 一键安装 Oracle 11GR2
RedHat 9.4(aarch64) 一键安装 Oracle 19C
龙蜥 Anolis 7.9 一键安装 Oracle 19C 19.23
龙蜥 Anolis OS 8.8 一键安装 Oracle 19C
SUSE 15 SP5 一键安装 Oracle 19C
统信 UOS V20 1070(a) 一键安装 Oracle 11GR2
Ubuntu 22.04 一键安装 Oracle 19C
Ubuntu 14.04 一键安装 Oracle 19C
银河麒麟 Kylin V10 SP3 一键安装 Oracle 19C 🔥
银河麒麟 Kylin V10 SP3 一键安装 Oracle 11GR2 RAC
Oracle DataGuard GAP 修复手册 🔥
优化 Oracle：最佳实践与开发规范
DBA 必备：Linux 软件源配置全攻略 🔥
Linux 一键配置时钟同步全攻略 🔥
Starwind 配置 ISCSI 共享存储
SUSE 15 SP3 安装 Oracle 19C RAC 数据库
达梦 8 数据库安装手册 🔥
Oracle 12CR2 RAC 安装避坑宝典
Linux7 安装 Oracle 19C RAC 详细图文教程 🔥
Oracle ADG 搭建 RAC to Single 详细教程
Oracle DataGuard GAP 修复手册 🔥
Oracle 分区表之在线重定义
AutoUpgrade 快速升级 Oracle 数据库
Oracle 数据库巡检命令手册 🔥
Oracle 数据坏块的 N 种修复方式 🔥
数据库 SQL 开发入门教程
超全 Linux 基础命令总结 🔥
VMware 虚拟机安装 Linux 系统
Linux 安装 MySQL 详细教程
教你玩转 SQLPLUS，工作效率提升 200%
感谢您的阅读，这里是 Lucifer三思而后行，欢迎 点赞+关注，我会持续分享数据库知识、运维技巧。