MariaDB (MySQL) Ansible Role for Debian

This role installs and sets up MariaDB (with Galera Cluster) on Debian. It can manage replication (master/slave) and create users and databases.

To manage older Debian versions, use the latest managed version.

Notes

• Galera Cluster is still experimental. Feel free to test it and report any issues.

Requirements

• Ansible - check meta/main.yml
• Collections - see requirements.yml

Role Variables

• mariadb_use_galera: set this to true to install Galera Cluster.

Configuration

If you need extra configuration options, use the following list. These will be added to /etc/mysql/conf.d/01-extra.

• mariadb_extra_config: a key/value pair, see default vars file

Databases

• mariadb_databases: list of databases to create.

Users

Example configuration for users:

mariadb_users:
  - name: 'lorem'
    password: '123'
    priv: lorem.*:ALL
    host: 'localhost'
  - name: 'ipsum'
    password: '465'
    priv: ipsum.*:ALL
    host_all: yes

For more details on "priv", check the mysql_user module documentation.

Packaging

• mariadb_upstream_version: depends on the Debian version.

Other

• mariadb_debug_role: boolean; set to true to show logs.

Dependencies

None.

If you want to develop this role locally with Molecule

Check the available scenarios in the molecule directory.

For the debian12_master_slave scenario:

molecule -v -c molecule/_shared/base.yml verify -s debian12_master_slave

Example Playbook

- hosts: servers
  roles:
     - { role: hanxhx.mysql, mariadb_origin: 'upstream' }

License

GPLv2

Donation

If this code helped you or if you used it in your projects, feel free to buy me a drink! :beers:

• Bitcoin: 1BQwhBeszzWbUTyK4aUyq3SRg7rBSHcEQn
• Ethereum: 0x63abe6b2648fd892816d87a31e3d9d4365a737b5
• Litecoin: LeNDw34zQLX84VvhCGADNvHMEgb5QyFXyD
• Monero: 45wbf7VdQAZS5EWUrPhen7Wo4hy7Pa7c7ZBdaWQSRowtd3CZ5vpVw5nTPphTuqVQrnYZC72FXDYyfP31uJmfSQ6qRXFy3bQ

Don't have cryptocurrency? You can also show your support by starring the project! :sunglasses:

Author Information

• Twitter: @hanxhx_