ansible执行mysql脚本

概述

ansible执行mysql脚本

实践

官网文档

环境要求

环境需要安装以下内容:

• 1.mysql客户端(安装了mysql即会有)
• 2.安装MySQL-python (Python 2.X)

详细插件安装链接

ansible yml脚本

关键代码如下：

# 剧本集
- hosts: nodes
  gather_facts: false
  tasks:
    - name: Run pwd command and capture the output
      shell: pwd
      register: pwd_current_path
    - name: nacos sql init
      mysql_db:
        login_host: "{{ mysql_url }}"
        login_user: "{{ mysql_user }}"
        login_password: "{{ mysql_password }}"
        login_port: 3306
        name: ry-config
        state: import
        target: ./ry_config.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

命令

# ansible-playbook release.yml --extra-vars "version=1.23.45 other_variable=foo"
ansible-playbook -i hosts main.yaml --extra-vars  "mysql_url=10.57.12.18 mysql_user=root mysql_password=root"
[root@ks2p-hadoop01 ansible-test]# ls
hosts  main.yaml  PyMySQL-1.0.2-py3-none-any.whl  ry_config_20220929.sql
[root@ks2p-hadoop01 ansible-test]# ansible-playbook -i hosts main.yaml --extra-vars  "mysql_url=10.57.12.18 mysql_user=root mysql_password=root"

PLAY [nodes] ***********************************************************************************************************************************************************************

TASK [打印调试信息] **********************************************************************************************************************************************************************
ok: [ks2p-hadoop04] => {
    "msg": "hello"
}

TASK [nacos mysql sql init] ********************************************************************************************************************************************************
changed: [ks2p-hadoop04]

PLAY RECAP *************************************************************************************************************************************************************************
ks2p-hadoop04              : ok=2    changed=1    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

离线包

下载链接