Role Name

Simple Ansible MariaDB Role

Changelog

1.1.0

• Added support for Debian Bullseye and Ubuntu Jammy
• Included changelog

1.0.0

• Ansible Role for Debian Buster and Ubuntu Focal

Installation

To install using ansible-galaxy, run:

$ ansible-galaxy install lukasic.mariadb

To install using requirements.yml, add this:

- src: lukasic.mariadb

Requirements

Works with Debian Buster / Ubuntu Focal and newer.

Role Variables

Settings for /etc/mysql/mariadb.conf.d/50-server.cnf

mariadb_server_params: []

MariaDB root password:

mariadb_root_passwd: null

Databases and users to be set up:

mariadb_databases: []
mariadb_users: []

Dependencies

None.

Example Playbook

Here’s how you can use this role with some example variables:

- hosts: mariadb
  roles:
    - lukasic.mariadb
  vars:
    mariadb_server_params:
      - option: "sql_mode"
        section: "mysqld"
        value: "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
      - option: "innodb_buffer_pool_size"
        section: "mysqld"
        value: "2G"
    mariadb_databases:
      - db1
    mariadb_users:
      - host: "%"
        name: "user_a"
        password: "supersecretpass"
        priv: "db1.*:ALL"

License

WTFPL

Author Information

Created in 2020 by Lukáš Kasič.