Default variable details
Some of debops.mariadb_server
default variables have more extensive
configuration than simple strings or lists, here you can find documentation and
examples for them.
mariadb_server__options
The role uses /etc/mysql/conf.d/mysqld.cnf
configuration file to manage the
MariaDB/MySQL server configuration. This configuration file is generated by
a template that uses the mariadb_server__mysqld_options
variable to get
the configuration data. The configuration itself is split among several
variables located in defaults/main.yml
file.
A minimal configuration is stored as a YAML dictionary. Keys of the dictionary as MariaDB configuration option names, and values of the dictionary are the configuration values. All values are automatically quoted in the generated configuration file.
Example configuration section:
mariadb_server__options:
'query_cache_type': '0'
'key_buffer': '16M'
'skip_name_resolve':
The dictionary keys without values will be written in the configuration file with correct notation.
Alternative configuration notation is to use a YAML list, each element of a list being a YAML dictionary in the above format. An example:
mariadb_server__options:
- 'query_cache_type': '0'
'key_buffer': '16M'
- 'skip_name_resolve':
Yet another alternative format can be used if you use certain keys in the YAML
dictionary. The template checks for presence of the name
or section
keys, and if found, changes to a different format that uses YAML dictionary
keys:
name
Required for the main options. Name of the option to add.
section
Required for the definition of a configuration section. Create new section of the configuration file, written in square brackets.
state
Optional. Either
present
orabsent
. If not specified orpresent
, a given section or option will be added in the configuration file; ifabsent
, option or section won't be added.comment
Optional. Add a comment to a given option or section.
value
Optional for main options. If specified, set a value of a given option.
options
Optional. A YAML dictionary or list of YAML dictionaries with options to include in a given section, or multiple options specified together as a group. If it's specified, values of
name
andvalue
are ignored.
Examples:
mariadb_server__options:
- section: 'mysqld'
comment: 'Global MariaDB server options'
options:
- name: 'skip_name_resolve'
- name: 'key_buffer'
value: '16M'
- name: 'query_cache_type'
value: '0'
state: 'present'