mariadb
Ansible role mariadb
An ansible role for managing MariaDB.
- Install MariaDB packages from the official MariaDB repository.
- Set/Reset root password.
- Remove
test
database. - Remove anonymoyus users.
- Create users and databases.
- Manage configuration file
my.cnf
- Replication
Fixed settings:
- Storage engine : InnoDB
Tested against:
- CentOS 7.4
- Ubuntu 16.04 (Xenial)
- Ubuntu 18.04 (Bionic)
- MariaDB 10.3
Requirements
No requirements
Role Variables
Variable | Default | Comments |
---|---|---|
mariadb_bind_address |
'127.0.0.1' | IP address of the network interface to listen on. '0.0.0.0' for all interfaces. |
mariadb_binlog_format |
'ROW' | binary logging format (STATEMENT , ROW , MIXED ) |
mariadb_charset |
'utf8' | |
mariadb_collation |
'utf8_general_ci' | |
mariadb_databases |
[] | databases to add. See mysql_db |
mariadb_enabled_on_startup |
true | 'true': enable MariaDB on startup. |
mariadb_expire_logs_days |
10 | the number of days before automatic removal of binary log files. |
mariadb_group_concat_max_len |
1024 | |
mariadb_innodb_buffer_pool_size |
256M | |
mariadb_innodb_file_per_table |
ON | |
mariadb_innodb_flush_log_at_trx_commit |
1 | |
mariadb_innodb_log_buffer_size |
8M | |
mariadb_innodb_log_file_size |
64M | |
mariadb_innodb_lock_wait_timeout |
50 | |
mariadb_join_buffer_size |
256K | |
mariadb_key_buffer_size |
256M | |
mariadb_lower_case_table_names |
1 | 0: case-sensitive(Linux), 1: stored in lowercase, case-insensitive(Windows), 2: stored as declared, compared in lowercase(OSX) |
mariadb_max_allowed_packet |
64M | |
mariadb_max_binlog_size |
100M | max binary log size (4096 byte ~ 1GB) |
mariadb_max_connections |
151 | |
mariadb_max_heap_table_size |
16M | |
mariadb_myisam_sort_buffer_size |
64M | |
mariadb_mysqldump_max_allowed_packet |
64M | |
mariadb_overwrite_global_mycnf |
true | true : global my.cnf should be overwritten each time this role is run. |
mariadb_port |
3306 | port number |
mariadb_read_buffer_size |
1M | |
mariadb_read_rnd_buffer_size |
4M | |
mariadb_replication_master |
'' | replication master |
mariadb_replication_master_host |
'' | replication master host (default: hostvars[mariadb_replication_master]['ansible_host'] ) |
mariadb_replication_role |
'' | replication role (master , slave ) |
mariadb_replication_user |
[] | replication user (name , password required) |
mariadb_root_password |
'root' | root password |
mariadb_root_remote |
no |
yes : enable remote root login |
mariadb_root_remote_host |
'%' | remote root login enabled host |
mariadb_server_id |
'' | server id (replication) |
mariadb_skip_name_resolve |
1 | |
mariadb_sort_buffer_size |
1M | |
mariadb_sql_mode |
NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO | |
mariadb_table_open_cache |
256 | |
mariadb_thread_cache_size |
8 | |
mariadb_tmp_table_size |
16M | |
mariadb_users |
[] | users to add |
mariadb_version |
'10.3' | MariaDB version to install |
mariadb_wait_timeout |
28800 |
Dependencies
No dependencies
Example Playbook
Create database and users
---
- name: example
hosts: all
become: true
vars:
mariadb_bind_address: '0.0.0.0'
mariadb_root_password: 'root'
mariadb_root_remote: yes
mariadb_databases:
- name: dev
mariadb_users:
- name: dev
password: 'devdev'
priv: "dev.*:ALL"
host: "%"
roles:
- lechuckroh.mariadb
Replication
host inventory
mariadb-master ansible_host=192.168.50.11 ansible_user=vagrant
mariadb-slave ansible_host=192.168.50.12 ansible_user=vagrant
Master playbook
---
- name: Install mysql on Master
hosts: mariadb-master
become: true
vars:
mariadb_bind_address: '0.0.0.0'
mariadb_root_password: 'root'
mariadb_databases:
- name: dev1
- name: dev2
replicate: yes
- name: dev3
replicate: no
mariadb_users:
- name: dev
password: 'devdev'
priv: "dev*.*:ALL"
host: "%"
mariadb_server_id: 1
mariadb_max_binlog_size: 100M
mariadb_binlog_format: ROW
mariadb_expire_logs_days: 10
mariadb_replication_role: master
mariadb_replication_master: mariadb-master
mariadb_replication_user:
name: repl
password: repl
tasks:
- include_role:
name: lechuckroh.mariadb
Slave playbook
---
- name: Install mysql on Master
hosts: mariadb-slave
become: true
vars:
mariadb_bind_address: '0.0.0.0'
mariadb_root_password: 'root'
mariadb_databases:
- name: dev1
- name: dev2
mariadb_server_id: 2
mariadb_replication_role: master
mariadb_replication_master: mariadb-master
mariadb_replication_user:
name: repl
password: repl
tasks:
- include_role:
name: lechuckroh.mariadb
License
MIT
Install
ansible-galaxy install lechuckroh/ansible-role-mariadb
License
mit
Downloads
70
Owner