joe-speedboat.mariadb

This Ansible Role helps to install and set up MariaDB, and manage data like databases and users.

How to Install with ansible-galaxy:

ansible-galaxy install joe-speedboat.mariadb

How to Install with git:

git clone https://github.com/joe-speedboat/ansible.mariadb.git /etc/ansible/roles/joe-speedboat.mariadb

Requirements

• You need Ansible version 2.9 or higher for this role.
• Compatible Operating Systems:
  • CentOS 8
  • Alma/Rocky 9

Role Dependencies

This role does not depend on any other Ansible roles.

Collection Dependencies

You need the following collection:

• community.mysql

ansible-galaxy collection install -r collections/requirements.yml

About uniQconsulting ag

I work at uniQconsulting ag. I created these roles in my free time to prepare for the Red Hat Ansible exam. When uniQconsulting ag started using Ansible more, I moved the roles to their GitHub account. However, to meet the needs of the community better, I decided to manage them independently and more flexibly in my own free time. Feel free to use, discuss, or suggest changes (pull requests) if you want.

Thank you!

Chris

Role Variables

The variables are easy to understand or can be found in:

• defaults/main.yml
• vars/main.yml

You can change the following variables:

• mariadb_secure_installation: Default is false. Works like mysql_secure_installation.
• mariadb_root_password: Default is ''.
• mariadb_databases: Default is {}. A list of databases.
• mariadb_users_create: Default is {}. A list of user credentials to create.
• mariadb_users_remove: Default is {}. A list of users to delete.

Example Playbooks

Example playbooks for this role are in the test folder:

• test/playbook_mariadb_minimal.yml: A simple test role.
• test/playbook_mariadb.yml: A real-life example.
• test/playbook_mariadb_full.yml: A complete example with all possible options.

License

Open Source License
Copyright (c) Chris Ruettimann chris@bitbull.ch