ansible-roles-mariadb

This role is designed to provide a basic mariadb podman deployment

• https://mariadb.org/
• https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/
• https://hub.docker.com/_/mariadb

Task Configuration

- name: Setup mariadb
  hosts: somehost
  become: true
  roles:
    - role: mariadb
      mariadb_db_name: somedatabase
      mariadb_db_user someuser
      mariadb_db_password somepassword
    - role: firewalld
      firewalld_add:
        - name: public
          ports:
            - 3306/tcp
            - 3306/udp

Deployment and Removal

Sometimes you need to manually stop the running containers to get a clean run when re-deploying Services must be stopped as the respecitve user or another means to aquire the correct user scope for systemd

systemctl --user stop container-mariadb.service

Deploy

ansible-playbook -i hosts site.yml --tags=firewalld,mariadb --limit=somehost

Remove

ansible-playbook -i hosts site.yml --tags=firewalld,mariadb --extra-vars "container_state=absent firewall_action=remove" --limit=somehost