# Automated Deployment & Administration

- [Why to Automate MariaDB Deployments and Management](/docs/server/server-management/automated-mariadb-deployment-and-administration/why-to-automate-mariadb-deployments-and-management.md): Explains the benefits of automating database deployment and management, such as consistency, scalability, and the adoption of Infrastructure as Code principles.
- [Comparison Between Automation Systems](/docs/server/server-management/automated-mariadb-deployment-and-administration/a-comparison-between-automation-systems.md): Compares different automation tools like Ansible and Puppet, highlighting differences in their architecture (agentless vs. agent-based) and code structure to help users choose the right tool.
- [Automating MariaDB Tasks with Events](/docs/server/server-management/automated-mariadb-deployment-and-administration/automating-mariadb-tasks-with-events.md): Describes how to use the MariaDB Event Scheduler to automate recurring SQL tasks directly within the database server, similar to cron jobs.
- [Automating Upgrades with MariaDB.Org Downloads REST API](/docs/server/server-management/automated-mariadb-deployment-and-administration/automating-upgrades-with-mariadborg-downloads-rest-api.md): A guide on using the MariaDB Downloads REST API to programmatically retrieve information about software versions, facilitating automated upgrade scripts.
- [HashiCorp Vault and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/hashicorp-vault-and-mariadb.md): Discusses the integration of HashiCorp Vault with MariaDB for managing secrets, including using MariaDB as a storage backend for Vault.
- [Orchestrator Overview](/docs/server/server-management/automated-mariadb-deployment-and-administration/orchestrator-overview.md): An introduction to Orchestrator, a tool for managing MySQL and MariaDB replication topologies, providing high availability and automated failover capabilities.
- [Ansible and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/ansible-and-mariadb.md): Provides general information and resources for using Ansible to automate the deployment and configuration of MariaDB servers using playbooks.
- [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.
- [Puppet and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb.md): General information and hints on how to automate MariaDB deployments and configuration with Puppet, an open source tool for deployment, configuration, and operations.
- [Puppet Overview](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/puppet-overview-for-mariadb-users.md): Introduction to Puppet's architecture (agent-master vs. standalone), concepts like manifests and catalogs, and how it can be used for configuration management of MariaDB servers.
- [Deploying Docker Containers with Puppet](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/deploying-docker-containers-with-puppet.md): A guide to managing Docker container lifecycles using Puppet's \`docker\` resource type, covering image pulling, container execution, and upgrades for MariaDB.
- [Existing Puppet Modules for MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/existing-puppet-modules-for-mariadb.md): Lists available Puppet modules for MariaDB from the Puppet Forge and GitHub, noting that while no official module exists, community and generic MySQL modules are often used.
- [Puppet hiera Configuration System](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/puppet-hiera-configuration-system.md): Explains how to use Hiera, Puppet's hierarchical key/value lookup tool, to separate MariaDB configuration data from code and manage environment-specific settings.
- [Bolt Examples](/docs/server/server-management/automated-mariadb-deployment-and-administration/automated-mariadb-deployment-and-administration-puppet-and-mariadb/bolt-examples.md): Demonstrates how to use Bolt, an orchestration tool in the Puppet ecosystem, to run ad-hoc commands, scripts, and tasks on remote MariaDB servers without a permanent agent.
- [MariaDB Containers](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb.md): Discusses running MariaDB in Docker containers, covering the benefits of isolation and ease of deployment for development and testing environments.
- [Adding Plugins to the MariaDB Docker Official Image](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/adding-plugins-to-the-mariadb-docker-official-image.md): Instructions on how to extend the official MariaDB Docker image by installing additional plugins and dependencies using a custom Dockerfile.
- [Benefits of Managing MariaDB Containers with Orchestration Software](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/benefits-of-managing-mariadb-containers-with-orchestration-software.md): Explains the advantages of using orchestration tools like Kubernetes or Docker Swarm for managing MariaDB containers, including automated failover, scaling, and rolling updates.
- [Container Backup and Restoration](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/container-backup-and-restoration.md): Complete container backup guide: docker volume create, mariadb-dump --all-databases, mariadb-backup --backup/--prepare/--copy-back operations.
- [Container Security](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/container-security-concerns.md): Discusses security best practices for running MariaDB in containers, addressing topics like root user privileges, volume permissions, and network isolation.
- [Creating a Custom Container Image](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/creating-a-custom-container-image.md): Guide to building a custom MariaDB container image to include specific configuration files, scripts, or pre-loaded data.
- [Deploy MariaDB Enterprise Server with Docker](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/deploy-mariadb-enterprise-server-with-docker.md): Instructions for deploying MariaDB Enterprise Server using the official enterprise Docker images, including handling license keys and entitlements.
- [MariaDB Enterprise Docker Registry for MariaDB Enterprise Server](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-enterprise-docker-registry-for-mariadb-enterprise-server.md): How to authenticate with and pull images from the private MariaDB Enterprise Docker Registry.
- [Docker and AWS EC2](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-aws-ec2.md): Specific considerations and steps for running MariaDB Docker containers on Amazon EC2 instances.
- [Docker and Google Cloud](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-google-cloud.md): Guide for deploying MariaDB containers on Google Cloud Platform (GCP) compute resources.
- [Docker and Microsoft Azure](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-and-microsoft-azure.md): Instructions for running MariaDB containers within the Microsoft Azure ecosystem.
- [Docker Official Image Frequently Asked Questions](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/docker-official-image-frequently-asked-questions.md): Answers to common questions regarding the official MariaDB image, covering versioning, tagging, and default configurations.
- [Installing and Using MariaDB via Docker](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/installing-and-using-mariadb-via-docker.md): Complete guide to MariaDB in Docker. Complete resource for container deployment, volume management, networking, and environment setup for production use.
- [MariaDB Container Cheat Sheet](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-container-cheat-sheet.md): A concise reference of common Docker commands and environment variables used with MariaDB containers.
- [MariaDB Server Docker Official Image Environment Variables](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/mariadb-server-docker-official-image-environment-variables.md): Complete guide to MariaDB in Docker. Complete resource for container deployment, volume management, networking, and environment setup for production use.
- [Setting Up a LAMP Stack with Docker Compose](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/setting-up-a-lamp-stack-with-docker-compose.md): Complete LAMP stack Docker Compose: define docker-compose.yml services (web/mariadb), set volumes/env vars (${MARIADB\_VERSION}), docker-compose up/down.
- [Using Healthcheck](/docs/server/server-management/automated-mariadb-deployment-and-administration/docker-and-mariadb/using-healthcheck-sh.md): Complete healthcheck.sh Docker reference: --connect, --innodb\_initialized, --replication\_\* checks, .my-healthcheck.cnf config, and environment variables.
- [Kubernetes and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb.md): General information and hints on deploying MariaDB Kubernetes (K8s) containers, an open source container orchestration system which automates deployments, horizontal scaling, configuration, and operat
- [Kubernetes Operators for MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb/kubernetes-operators-for-mariadb.md): Official Kubernetes Operators for MariaDB: Enterprise Operator for MariaDB Server+MaxScale, CRDs/controllers, HA topologies, and backup/restore automation.
- [Kubernetes Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/kubernetes-and-mariadb/kubernetes-overview-for-mariadb-users.md): Introduction to core Kubernetes concepts relevant to database administrators, such as StatefulSets, Persistent Volumes, and Services, and how they apply to MariaDB storage and networking.
- [Vagrant and MariaDB](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb.md): Vagrant is an open source tool to quickly setup machines that can be used for development and testing. They can be local virtual machines, Docker containers, AWS EC2 instances, and so on
- [Creating a Vagrantfile](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/creating-a-vagrantfile.md): A guide on creating and configuring a \`Vagrantfile\` to define the characteristics of a MariaDB virtual machine, including box selection and provisioning steps.
- [Vagrant Overview for MariaDB Users](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/vagrant-overview-for-mariadb-users.md): Introduction to Vagrant's workflow and terminology for database administrators, explaining how it simplifies the creation of reproducible MariaDB development environments.
- [Vagrant Security](/docs/server/server-management/automated-mariadb-deployment-and-administration/vagrant-and-mariadb/vagrant-security-concerns.md): Discusses security considerations when using Vagrant with MariaDB, such as default insecure keys, port forwarding risks, and ensuring production-grade settings are not used in dev boxes.