darexsu.mysql
Ansible role MySQL
- Role:
- Playbooks (merge version):
- Playbooks (full version):
Platforms
| Testing | repo: distribution | repo: mysql |
|---|---|---|
| Debian 11 | No | mysql.com |
| Debian 10 | No | mysql.com |
| Ubuntu 20.04 | No | mysql.com |
| Ubuntu 18.04 | No | mysql.com |
| Oracle Linux 8 | mysql 8.0 | mysql.com |
| Rocky Linux 8 | mysql 8.0 | mysql.com |
Install
ansible-galaxy install darexsu.mysql --force
Merge behaviour
Replace or Merge dictionaries (with "hash_behaviour=replace" in ansible.cfg):
# Replace # Merge
--- ---
vars: vars:
dict: merge:
a: "value" dict:
b: "value" a: "value"
b: "value"
# How does merge work?
Your vars [host_vars] --> default vars [current role] --> default vars [include role]
dict: dict: dict:
a: "1" --> a: "1" --> a: "1"
b: "2" --> b: "2"
c: "3"
Install and configure: MySQL (merge version)
---
- hosts: all
become: true
vars:
merge:
# MySQL
mysql:
enabled: true
repo: "mysql"
# MySQL -> install
mysql_install:
enabled: true
# MySQL -> config
mysql_config:
enabled: true
skip-grant-tables: false
data:
pid-file: "{{ mysql_const[ansible_os_family]['pid-file'] }}"
socket: "{{ mysql_const[ansible_os_family]['socket'] }}"
datadir: "{{ mysql_const[ansible_os_family]['datadir'] }}"
log-error: "{{ mysql_const[ansible_os_family][mysql.repo]['log-error'] }}"
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Install: MySQL, repository: distribution (merge version)
---
- hosts: all
become: true
vars:
merge:
# MySQL
mysql:
enabled: true
repo: "distribution"
# MySQL -> install
mysql_install:
enabled: true
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Install: MySQL, repository: mysql (merge version)
---
- hosts: all
become: true
vars:
merge:
# MySQL
mysql:
enabled: true
repo: "mysql"
version: "8.0"
# MySQL -> install
mysql_install:
enabled: true
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Configure: server.conf (merge version)
---
- hosts: all
become: true
vars:
merge:
# MySQL
mysql:
enabled: true
# MySQL -> config
mysql_config:
enabled: true
file: "{{ mysql_const[ansible_os_family]['config_file']}}"
src: "mysql_server.conf.j2"
backup: false
skip-grant-tables: false
data:
pid-file: "{{ mysql_const[ansible_os_family]['pid-file'] }}"
socket: "{{ mysql_const[ansible_os_family]['socket'] }}"
datadir: "{{ mysql_const[ansible_os_family]['datadir'] }}"
log-error: "{{ mysql_const[ansible_os_family][mysql.repo]['log-error'] }}"
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Install and configure: MySQL (full version)
---
- hosts: all
become: true
vars:
# MySQL
mysql:
enabled: true
repo: "mysql"
version: "8.0"
service:
state: "started"
enabled: true
# MySQL -> install
mysql_install:
enabled: true
# MySQL -> config
mysql_config:
enabled: true
file: "{{ mysql_const[ansible_os_family]['config_file']}}"
src: "mysql_server.conf.j2"
backup: false
skip-grant-tables: false
data:
pid-file: "{{ mysql_const[ansible_os_family]['pid-file'] }}"
socket: "{{ mysql_const[ansible_os_family]['socket'] }}"
datadir: "{{ mysql_const[ansible_os_family]['datadir'] }}"
log-error: "{{ mysql_const[ansible_os_family][mysql.repo]['log-error'] }}"
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Install: MySQL, repository: distribution (full version)
---
- hosts: all
become: true
vars:
# MySQL
mysql:
enabled: true
repo: "distribution"
version: ""
service:
state: "started"
enabled: true
# MySQL -> install
mysql_install:
enabled: true
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Install: MySQL, repository: mysql (full version)
---
- hosts: all
become: true
vars:
# MySQL
mysql:
enabled: true
repo: "mysql"
version: "8.0"
service:
state: "started"
enabled: true
# MySQL -> install
mysql_install:
enabled: true
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
Configure: server.conf (full version)
---
- hosts: all
become: true
vars:
# MySQL
mysql:
enabled: true
repo: "mysql"
version: "8.0"
service:
state: "started"
enabled: true
# MySQL -> config
mysql_config:
enabled: true
file: "{{ mysql_const[ansible_os_family]['config_file']}}"
src: "mysql_server.conf.j2"
backup: false
skip-grant-tables: false
data:
pid-file: "{{ mysql_const[ansible_os_family]['pid-file'] }}"
socket: "{{ mysql_const[ansible_os_family]['socket'] }}"
datadir: "{{ mysql_const[ansible_os_family]['datadir'] }}"
log-error: "{{ mysql_const[ansible_os_family][mysql.repo]['log-error'] }}"
tasks:
- name: include role darexsu.mysql
include_role:
name: darexsu.mysql
