Ansible Role: srv_mariadb

An Ansible Role to install and configure mariadb.

Motivation

mariadb is one of the most popular database servers.
Made by the original developers of MySQL.

Description

This role installs and configures mariadb.

• install mariadb packages
• configure mariadb
• configure firewalld
• perform mysql-secure-installation steps

Requirements

Used Modules:

• Ansible Package Module
• Ansible Service Module
• Ansible Template Module
• Ansible File Module
• Ansible Firewalld Module
• Ansible mysql_user Module
• Ansible mysql_db Module
• Ansible package_facts Module

Installation

Install from Ansible Galaxy

ansible-galaxy install while_true_do.srv_mariadb

Install from Github

git clone https://github.com/while-true-do/ansible-role-srv_mariadb.git while_true_do.srv_mariadb

Usage

Role Variables

---
# defaults file for while_true_do.srv_mariadb
# Define the source of installation
# Currently only distribution packages are supported
wtd_srv_mariadb_source: "distribution"
## Package Management
wtd_srv_mariadb_package:
  - mariadb-server
  - python3-mysql
# State can be present|latest|absent
wtd_srv_mariadb_package_state: "present"
## Configuration Management
wtd_srv_mariadb_conf_root_pass: ""
wtd_srv_mariadb_conf_my_path: "/etc/my.cnf"
wtd_srv_mariadb_conf_server_path: "/etc/my.cnf.d/mariadb-server.cnf"
wtd_srv_mariadb_conf_server:
  port: "3306"
  bind_address: "127.0.0.1"
  character_set: "utf8mb4"
  symbolic_links: "0"
  data_dir: "/var/lib/mysql"
  socket: "/var/lib/mysql/mysql.sock"
wtd_srv_mariadb_conf_innodb:
  file_per_table: "true"
  buffer_pool_size: "128M"
wtd_srv_mariadb_conf_query_cache:
  type: "1"
  limit: "256K"
  min_res_unit: "2k"
  cache_size: "64M"
## Service Management
wtd_srv_mariadb_service: "mariadb"
# State can be started|stopped
wtd_srv_mariadb_service_state: "started"
wtd_srv_mariadb_service_enabled: true
## Firewalld Management
wtd_srv_mariadb_fw_mgmt: true
wtd_srv_mariadb_fw_service: "mysql"
# State can be enabled|disabled
wtd_srv_mariadb_fw_state: "enabled"
# Zone can be according to defined zones on your machine.
wtd_srv_mariadb_fw_zone: "public"
## Host Management
wtd_srv_mariadb_reboot_enabled: true
wtd_srv_mariadb_reboot_msg: "System is going down to ..."
wtd_srv_mariadb_reboot_timeout: 3600

Example Playbook

Running Ansible
Roles
can be done in a
playbook.

Simple

---
- hosts: all
  roles:
    - role: while_true_do.srv_mariadb
      wtd_srv_mariadb_conf_root_pass: "myPassword"

Allow network traffic

- hosts: all
  roles:
    - role: while_true_do.srv_mariadb
      wtd_srv_mariadb_conf_root_pass: "myPassword"
      wtd_srv_mariadb_conf_server:
        port: "3306"
        bind_address: "0.0.0.0"

Known Issues

1. RedHat Testing is currently not possible in public, due to limitations
   in subscriptions.
2. Some services and features cannot be tested properly, due to limitations
   in docker.

Testing

Most of the “generic” tests are located in the
Test Library.

Ansible specific testing is done with
Molecule.

Infrastructure testing is done with
testinfra.

Automated testing is done with Travis CI.

Contribute

Thank you so much for considering to contribute. We are very happy, when somebody
is joining the hard work. Please fell free to open
Bugs, Feature Requests
or Pull Requests after
reading the Contribution Guideline.

See who has contributed already in the kudos.txt.

License

This work is licensed under a BSD-3-Clause License.

Contact

• Site https://while-true-do.io
• Twitter https://twitter.com/wtd_news
• Code https://github.com/while-true-do
• Mail @while-true-do.io"">hello@while-true-do.io
• IRC freenode, #while-true-do
• Telegram https://t.me/while_true_do