darexsu.mysql

Ansible role MySQL

CI Molecule  Ansible Role

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
About

install and configure MySQL-server from distro or third party repo

Install
ansible-galaxy install darexsu.mysql
GitHub repository
License
mit
Downloads
2.1k
Owner