ansible-role-mariadb

Installs & configures MariaDB 10.x using packages from mariadb.com

Dependencies

Roles

None

Collections

• ansible.mysql
• community.general
• community.mysql

Platforms

Supported platforms

• Red Hat Enterprise Linux 8¹
• Red Hat Enterprise Linux 9¹
• Red Hat Enterprise Linux 10¹
• RockyLinux 8
• RockyLinux 9
• RockyLinux 10
• OracleLinux 8
• OracleLinux 9
• OracleLinux 10
• AlmaLinux 8
• AlmaLinux 9
• AlmaLinux 10
• Debian 11 (Bullseye)
• Debian 12 (Bookworm)
• Debian 13 (Trixie)
• Ubuntu 22.04 LTS
• Ubuntu 24.04 LTS
• Ubuntu 26.04 LTS

Note: ¹ : no automated testing is performed on these platforms

Role Variables

defaults/main.yml

# MariaDB version
# mariadb_release: '10.11'

# MariaDB packages
mariadb_pre_packages: []
mariadb_packages: []
mariadb_additional_packages: []

# Install from distro (vendor) or external provider (oss)
mariadb_type: oss

# Shoud socket authentication be used
mariadb_socket_authentication: true

# Mariadb DB settings
mariadb_db_name: ''
mariadb_db_delete: false

# innodb
mariadb_innodb:
  innodb_buffer_pool_size: 1G
  innodb_log_file_size: 64M
  innodb_lock_wait_timeout: 900

mariadb_column_case_sensitive: false

defaults/Debian-11.yml

defaults/family-Debian-13.yml

# List of MariaDB package it depends on
mariadb_pre_packages:
  - apt-transport-https
  # - software-properties-common
  - python3-pymysql
  - rsync

defaults/family-Debian.yml

# Package repository to use
mariadb_repo: >-
  https://deb.mariadb.org/{{ mariadb_release }}/{{ ansible_facts.distribution | lower }}

# GPG key
mariabdb_gpg_key: >-
  https://mariadb.org/mariadb_release_signing_key.pgp

# List of MariaDB package it depends on
mariadb_pre_packages:
  - apt-transport-https
  - software-properties-common
  - python3-pymysql
  - rsync

# List of MariaDB package
mariadb_packages:
  - mariadb-server
  - mariadb-client
  - mariadb-backup

# Configuration path
mariadb_config_dir: /etc/mysql/conf.d

# UNIX socket for authentication
mariadb_socket: /var/run/mysqld/mysqld.sock

defaults/family-RedHat-7.yml

# List of MariaDB package
mariadb_packages:
  - python3-mysql
  - MariaDB-server
  - MariaDB-backup
  - galera-4

defaults/family-RedHat-8.yml

# List of MariaDB package
mariadb_packages:
  - python3-mysql
  - MariaDB-server
  - MariaDB-backup
  - galera-4

defaults/family-RedHat-9.yml

# List of MariaDB package
mariadb_packages:
  - python3-mysqlclient
  - MariaDB-server
  - MariaDB-backup
  - galera-4

defaults/family-RedHat.yml

# Package repository to use
mariadb_repo: >-
  https://rpm.mariadb.org/{{ mariadb_release }}/rhel/$releasever/$basearch

# GPG key
mariabdb_gpg_key: >-
  https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB

# List of MariaDB package it depends on
mariadb_pre_packages:
  - epel-release

# Configuration path
mariadb_config_dir: /etc/my.cnf.d

# UNIX socket for authentication
mariadb_socket: /var/lib/mysql/mysql.sock

defaults/family-Suse-15.yml

# List of MariaDB package
mariadb_packages:
  - python3-mysqlclient
  - MariaDB-server
  - MariaDB-backup
  - galera-4

defaults/family-Suse.yml

# Package repository to use
mariadb_repo: >-
  https://rpm.mariadb.org/{{ mariadb_release }}/sles/$releasever/$basearch

# GPG key
mariabdb_gpg_key: >-
  https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB

# List of MariaDB package it depends on
mariadb_pre_packages: []

# Configuration path
mariadb_config_dir: /etc/my.cnf.d

# UNIX socket for authentication
mariadb_socket: /var/lib/mysql/mysql.sock

defaults/Ubuntu-22.yml

defaults/Ubuntu-26.yml

# Install from distro (vendor) or external provider (oss)
mariadb_type: vendor

Example Playbook

molecule/default/converge.yml

- name: sample playbook for role 'mariadb'
  hosts: all
  become: 'yes'
  vars:
    molecule_driver: '{{ lookup(''env'', ''MOLECULE_DRIVER_NAME'') }}'
    mariadb_user: root
    mariadb_pwd: root1234
    mariadb_db_name: db01
    mariadb_db_user: user01
    mariadb_socket_authentication: true
  tasks:
    - name: Include role 'mariadb'
      ansible.builtin.include_role:
        name: mariadb