main.yml

---
# file: roles/mysql-client/tasks/main.yml

- name: MySQL Client Role
  set_fact:
    role_mysql_client_started: yes
  tags:
    - always

- block:

    - name: Install required packages
      apt:
        pkg: '{{ packages }}'
        state: present
      vars:
        packages:
          - mysql-client
          - mytop

    - name: Config for easy access for admins
      template:
        src: admin_my_cnf
        dest: /home/{{ item }}/.my.cnf
        owner: '{{ item }}'
        group: root
        mode: 0644
      with_items: '{{ admins }}'

    - name: Config for easy access for root
      template:
        src: admin_my_cnf
        dest: /root/.my.cnf
        owner: root
        group: root
        mode: 0644

    - name: Install PIP packages
      pip:
        name: '{{ packages }}'
        state: present
      vars:
        packages:
          - PyMySQL

  when: not excluded_roles or "mysql-client" not in excluded_roles