> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb.md).

# Ansible and MariaDB

{% columns %}
{% column %}
{% content-ref url="/pages/7tEP8lZlF5YJ3PdE2PhP" %}
[Ansible Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/ansible-overview-for-mariadb-users.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/j1fOwpMLCiI7z7gSdDBp" %}
[Deploying Docker Containers with Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/deploying-docker-containers-with-ansible.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/zrmRR4fYTX3xATRmeC2m" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4fQCW5Xig2SMaUhxgplZ" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists and describes the standard Ansible modules available for managing MariaDB, such as `mysql_db`, `mysql_user`, and `mysql_variables`, highlighting their idempotent nature.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/EyspckBe1RVjW2oWoWWm" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/vevN62pt4DvYOu5T8UI7" %}
[Managing Secrets in Ansible](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb/managing-secrets-in-ansible.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Best practices for handling sensitive information like database passwords and SSH keys within Ansible, recommending the use of `ansible-vault` to encrypt secrets.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QDXE8DNgwVVvSq02Qwdd" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}