88 lines
2.2 KiB
YAML
88 lines
2.2 KiB
YAML
|
---
|
||
|
|
- name: Get MySQL version.
|
||
|
|
command: 'mysql --version'
|
||
|
|
register: mysql_cli_version
|
||
|
|
changed_when: false
|
||
|
|
check_mode: false
|
||
|
|
|
||
|
|
- name: Copy my.cnf global MySQL configuration.
|
||
|
|
template:
|
||
|
|
src: my.cnf.j2
|
||
|
|
dest: "{{ mysql_config_file }}"
|
||
|
|
owner: root
|
||
|
|
group: root
|
||
|
|
mode: 0644
|
||
|
|
force: "{{ overwrite_global_mycnf }}"
|
||
|
|
notify: restart mysql
|
||
|
|
|
||
|
|
- name: Verify mysql include directory exists.
|
||
|
|
file:
|
||
|
|
path: "{{ mysql_config_include_dir }}"
|
||
|
|
state: directory
|
||
|
|
owner: root
|
||
|
|
group: root
|
||
|
|
mode: 0755
|
||
|
|
when: mysql_config_include_files | length
|
||
|
|
|
||
|
|
- name: Copy my.cnf override files into include directory.
|
||
|
|
template:
|
||
|
|
src: "{{ item.src }}"
|
||
|
|
dest: "{{ mysql_config_include_dir }}/{{ item.src | basename }}"
|
||
|
|
owner: root
|
||
|
|
group: root
|
||
|
|
mode: 0644
|
||
|
|
force: "{{ item.force | default(False) }}"
|
||
|
|
with_items: "{{ mysql_config_include_files }}"
|
||
|
|
notify: restart mysql
|
||
|
|
|
||
|
|
- name: Create slow query log file (if configured).
|
||
|
|
command: "touch {{ mysql_slow_query_log_file }}"
|
||
|
|
args:
|
||
|
|
creates: "{{ mysql_slow_query_log_file }}"
|
||
|
|
warn: false
|
||
|
|
when: mysql_slow_query_log_enabled
|
||
|
|
|
||
|
|
- name: Create datadir if it does not exist
|
||
|
|
file:
|
||
|
|
path: "{{ mysql_datadir }}"
|
||
|
|
state: directory
|
||
|
|
owner: mysql
|
||
|
|
group: mysql
|
||
|
|
mode: 0755
|
||
|
|
setype: mysqld_db_t
|
||
|
|
|
||
|
|
- name: Set ownership on slow query log file (if configured).
|
||
|
|
file:
|
||
|
|
path: "{{ mysql_slow_query_log_file }}"
|
||
|
|
state: file
|
||
|
|
owner: mysql
|
||
|
|
group: "{{ mysql_log_file_group }}"
|
||
|
|
mode: 0640
|
||
|
|
when: mysql_slow_query_log_enabled
|
||
|
|
|
||
|
|
- name: Create error log file (if configured).
|
||
|
|
command: "touch {{ mysql_log_error }}"
|
||
|
|
args:
|
||
|
|
creates: "{{ mysql_log_error }}"
|
||
|
|
warn: false
|
||
|
|
when:
|
||
|
|
- mysql_log == ""
|
||
|
|
- mysql_log_error != ""
|
||
|
|
tags: ['skip_ansible_galaxy']
|
||
|
|
|
||
|
|
- name: Set ownership on error log file (if configured).
|
||
|
|
file:
|
||
|
|
path: "{{ mysql_log_error }}"
|
||
|
|
state: file
|
||
|
|
owner: mysql
|
||
|
|
group: "{{ mysql_log_file_group }}"
|
||
|
|
mode: 0640
|
||
|
|
when:
|
||
|
|
- mysql_log == ""
|
||
|
|
- mysql_log_error != ""
|
||
|
|
tags: ['skip_ansible_galaxy']
|
||
|
|
|
||
|
|
- name: Ensure MySQL is started and enabled on boot.
|
||
|
|
service: "name={{ mysql_daemon }} state=started enabled={{ mysql_enabled_on_startup }}"
|
||
|
|
register: mysql_service_configuration
|