computer-playbook/roles/docker-mariadb/README.md

33 lines
1.5 KiB
Markdown
Raw Permalink Normal View History

2023-12-29 22:50:42 +01:00
# MariaDB Docker Ansible Role
## Overview
This Ansible role facilitates the deployment of a MariaDB server using Docker. It is designed to ensure ease of installation and configuration, with the flexibility to adapt to different environments.
## Features
- **Dockerized MariaDB**: Leverages Docker for MariaDB deployment, ensuring consistency across different environments.
- **Customizable Settings**: Allows customization of the MariaDB instance through various Ansible variables.
- **Network Configuration**: Includes setup of a dedicated Docker network for MariaDB.
- **Idempotent Design**: Ensures that repeat runs of the playbook do not result in unwanted changes.
- **Security Focused**: Implements best practices for securing the MariaDB root password.
## Prerequisites
Before using this role, ensure you have the following:
- Ansible installed on the control machine.
- Docker installed on the target host(s).
- Access to the target host(s) via SSH.
## Configuration
Configure the role by setting the required variables. These can be set in the playbook or in a separate variable file:
- `central_mariadb_root_password`: The root password for the MariaDB server.
2024-01-06 14:32:49 +01:00
- `database_name`: The name of the initial database to create.
2023-12-29 22:50:42 +01:00
- `database_username`: The username for the database user.
- `database_password`: The password for the database user.
2024-02-06 20:24:16 +01:00
## Execute SQL commands
```bash
2024-04-03 20:39:22 +02:00
docker exec -it central-mariadb mariadb -u root -p
2024-02-06 20:24:16 +01:00
```
2023-12-29 22:50:42 +01:00
## Contributing
Contributions to this project are welcome. Please submit issues and pull requests with your suggestions.