mysql

Ansible Role: MySQL

Modular Ansible Role for deploying and configuring MySQL/MariaDB

Requirements

This Ansible role supports the two latest stable releases of specific server-focused Linux distributions and aims to follow their deprecation policies. Additionally we will focus on supporting the latest two stable releases of each, which at the time of writing are as follows:

CentOS 7.x
Debian 10 or later
Ubuntu 20.04 LTS or later
AlmaLinux 8.x or later
RockyLinux 8.x or later

Dependencies

community.mysql

Role Variables

Available variables are listed below with their default values (you can also see defaults/main.yml)

Variable	Description
mysql_config_file	Default: `/etc/my.cnf`
mysql_config_include_dir	Default: `/etc/my.cnf.d`
mysql_daemon	Default: `mariadb`
mysql_innodb_buffer_pool_size	Default: `128M`
mysql_innodb_file_per_table	Default: `1`
mysql_innodb_log_buffer_size	Default: `16M`
mysql_innodb_log_file_size	Default: `96M`
mysql_log_dir	Default: `/var/log/`
mysql_log_error	Default: `"{{ mysql_log_dir }}/mariadb/mariadb.log"`
mysql_log_file_group	Default: `mysql`
mysql_log_warning	Default: `1`
mysql_packages	Default: `The MySQL packages to install`
mysql_query_alloc_block_size	Default: `16384`
mysql_query_cache_limit	Default: `1M`
mysql_query_cache_min_res_unit	Default: `4096`
mysql_query_cache_size	Default: `16M`
mysql_query_cache_strip_comments	Default: `0`
mysql_query_cache_type	Default: `1`
mysql_query_cache_wlock_invalidate	Default: `0`
mysql_query_prealloc_size	Default: `24576`
mysql_root_home	Default: `/root`
mysql_root_password_update	Default: `false`
mysql_root_username	Default: `root`
mysql_slow_query_log_enabled	Default: `true`
mysql_slow_query_log_file	Default: `"{{ mysql_log_dir }}/mysql-slow.log"`
mysql_socket	Default: `true`
mysql_socket_path	Default: `/var/lib/mysql/mysql.sock`
mysql_supports_innodb_large_prefix	Default: `true`
mysql_syslog_tag	Default: `mariadb`
password_generate	Default: `"{{ lookup('password', '/dev/null length=15 chars=ascii_letters') }}"`

Example Playbook

- hosts: www
  roles:
     - role: inmotionhosting.mysql

License

GPLv3

Author Information

InMotion Hosting

About

Modular Ansible Role for deploying and configuring MySQL/MariaDB

role database mariadb mysql web

Install

ansible-galaxy install inmotionhosting/ansible-role-mysql

GitHub repository

0 stars

1 forks

0 open issues

License

gpl-3.0

Downloads

32930

Owner

InMotion Hosting

Offering Private and Public Cloud, Software as a Service, and Web Hosting