#######################################################################################################

:exclamation: DEPRECATION :exclamation:

This repository and the role associated are deprecated in favor of the Manala Ansible Collection

You will find informations on its usage on the collection repository

#######################################################################################################

Ansible Role: Mysql

:exclamation: Report issues and send Pull Requests in the main Ansible Role repository :exclamation:

This role will deal with the setup of Mysql (>= 5.6).

It's part of the Manala Ansible stack but can be used as a stand alone component.

Requirements

None.

Dependencies

None.

Installation

Ansible 2+

Using ansible galaxy cli:

ansible-galaxy install manala.mysql

Using ansible galaxy requirements file:

- src: manala.mysql

Role Handlers

Role Variables

Configuration example

Configure my.cnf example

Create an alternative link for debian MySQL official packages

manala_mysql_config_alternative: /etc/mysql/my.manala.cnf

Use template

manala_mysql_config_template: mysql/my.cnf.j2
manala_mysql_config:
  foo: bar

Use dict parameters

manala_mysql_config:
  mysqld:
    bind-address: 0.0.0.0
    innodb_buffer_pool_size: 4G

Use raw content

manala_mysql_config: |
  [mysqld]
  bind-address = 0.0.0.0
  innodb_buffer_pool_size = 4G

Use dict's array parameters (deprecated):

manala_mysql_config:
  - mysqld:
    - bind-address: 0.0.0.0
    - innodb_buffer_pool_size: 4G

Configure /etc/mysql/conf.d example

A state (present|absent|ignore) can be provided.

# Keep configs directory clean
manala_mysql_configs_exclusive: true

manala_mysql_configs:
  # Dict parameters
  - file: foo.cnf
    config:
      client:
        port: 3306
        socket: /var/run/mysqld/mysqld.sock
  # Raw content
  - file: bar.cnf
    config: |
      [client]
      port = 3306
      socket = /var/run/mysqld/mysqld.sock
  # Template
  - file: baz.cnf # file name based on template name if not defined
    template: mysql/baz.cnf.j2
    config:
      foo: bar
  # Dict's array (deprecated)
  - file: qux.cnf
    config:
      - client:
        - port: 3306
        - socket: /var/run/mysqld/mysqld.sock
  # Ensure config is absent
  - file: absent.cnf
    state: absent # "present" by default
  # Ignore config
  - file: ignore.cnf
    state: ignore
  # Flatten configs
  - "{{ my_custom_configs_array }}"

Users

manala_mysql_users:
  # Creates database user 'foo' and password '12345' with all database privileges and 'WITH GRANT OPTION'
  - name: foo
    password: 12345
    priv: '*.*:ALL,GRANT'
  # Modify user `bar` to require SSL connections. Note that REQUIRESSL is a special privilege that should only apply to *.* by itself
  - name: bar
    append_privs: true
    priv: '*.*:REQUIRESSL'
  # Ensure user `baz@localhost` is absent
  - name: baz
    host: localhost
    state: absent
  # Ignore user
  - name: qux
    state: ignore
  # Flatten users
  - "{{ my_custom_users_array }}"
  # Example of skipping binary logging while adding user
  - name: foo
    password: 12345
    priv: '*.*:ALL,GRANT'
    sql_log_bin: false

Databases

manala_mysql_databases:
  # Creates foo database
  - name: foo
    encoding: utf8
    collation: utf8_general_ci
  # Ensure database baz is absent
  - name: baz
    state: absent
  # Ignore database
  - name: qux
    state: ignore
  # Flatten databases
  - "{{ my_custom_databases_array }}"

Change default data directory

Be aware it will not clean your previous data directory nor migrate it.

manala_mysql_data_dir: /mnt/data

# Required on mariadb
manala_mysql_data_dir_initialize: true

manala_mysql_configs:
  - file: mysqld.cnf
    config:
      mysqld:
        datadir: /mnt/data

MariaDB

If you are using the apt role, define the wanted MariaDB version:

manala_apt_preferences:
 - mariadb@mariadb_10_5

You will also need to override default packages:

manala_mysql_install_packages_default:
  - mariadb-server
  - mariadb-client

Example playbook

- hosts: servers
  roles:
    - role: manala.mysql

Licence

MIT

Author information

Manala (http://www.manala.io/)