# Ansible and MariaDB

- [Ansible Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/ansible-overview-for-mariadb-users.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/deploying-docker-containers-with-ansible.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/deploying-to-remote-servers-with-ansible.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/existing-ansible-modules-and-roles-for-mariadb.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/installing-mariadb-deb-files-with-ansible.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/managing-secrets-in-ansible.md): 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](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/running-mariadb-tzinfo-to-sql-with-ansible.md): 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.