Ansible and MariaDB

Provides general information and resources for using Ansible to automate the deployment and configuration of MariaDB servers using playbooks.

Ansible Overview for MariaDB Users

Introduction to core Ansible concepts such as inventories, playbooks, and roles, with specific examples of how to structure them for MariaDB deployments like Galera Clusters and replicas.

Deploying Docker Containers with Ansible

Explains how to use Ansible's Docker modules to automate the deployment and configuration of MariaDB containers, serving as an alternative to Docker Compose.

Deploying to Remote Servers with Ansible

A guide to executing Ansible commands and playbooks on remote servers via SSH, covering basic connectivity tests (ping) and the application of roles to specific host groups.

Existing Ansible Modules and Roles for MariaDB

Lists and describes the standard Ansible modules available for managing MariaDB, such as mysql_db, mysql_user, and mysql_variables, highlighting their idempotent nature.

Installing MariaDB .deb Files with Ansible

Detailed instructions for automating the installation of MariaDB on Debian/Ubuntu systems, including tasks for adding repositories, importing GPG keys, and installing packages.

Managing Secrets in Ansible

Best practices for handling sensitive information like database passwords and SSH keys within Ansible, recommending the use of ansible-vault to encrypt secrets.

Running mariadb-tzinfo-to-sql with Ansible

Demonstrates how to automate the loading of time zone data into MariaDB using the mysql_tzinfo_to_sql utility, with techniques to ensure the task is idempotent.