open-tc-mysql

open-tc-mysql.yml

---
- hosts: tc-swarm-cluster
  gather_facts: no
  run_once: True

  tasks:
  - name: open database client
    delegate_to: 127.0.0.1
    ansible.builtin.shell: "open 'mysql://{{db_user}}:{{db_password}}@127.0.0.1:63306/{{ db_name }}'"
    register: mysql
    tags: mysql

  - name: ssh tunnel
    delegate_to: 127.0.0.1
    ansible.builtin.shell: "ssh -F inventories/{{inventory_dir.split('/')[-1]}}/ssh-config -L 63306:{{db_host}}:{{db_port}} {{inventory_hostname}} -N"
    register: ssh
    tags: ssh

  - name: echo ssh result
    delegate_to: 127.0.0.1
    ansible.builtin.debug:
      var: ssh

  - name: echo mysql result
    delegate_to: 127.0.0.1
    ansible.builtin.debug:
      var: mysql