mysql/common.sls

{%- from "mysql/map.jinja" import server with context %}

{%- if server.admin is defined %}

mariadb_debconf:
  debconf.set:
  - name: mariadb-server
  - data:
      'mysql-server/root_password': {'type':'string','value':'{{ server.admin.password }}'}
      'mysql-server/root_password_again': {'type':'string','value':'{{ server.admin.password }}'}
  - require_in:
    - pkg: mysql_packages

{%- endif %}

mysql_packages:
  pkg.installed:
  - names: {{ server.pkgs }}

{%- if server.version != '5.6' %}

mysql_config:
  file.managed:
  - name: {{ server.config }}
  - source: salt://mysql/conf/my.cnf.{{ grains.os_family }}
  - mode: 644
  - template: jinja
  - require: 
    - pkg: mysql_packages
  - watch_in:
    - service: mysql_service

{%- endif %}

mysql_service:
  service.running:
  - name: {{ server.service }}
  - enable: true

mysql_config_dir:
  file.directory:
  - name: /etc/mysql/conf.d
  - makedirs: true
  - mode: 755

mysql_dirs:
  file.directory:
  - names:
    - /root/mysql/scripts
    - /root/mysql/flags
    - /root/mysql/data
  - mode: 700
  - user: root
  - group: root
  - makedirs: true
  - require: 
    - pkg: mysql_packages

/root/mysql/flags:
  file.directory:
  - mode: 700
  - user: root
  - group: root
  - makedirs: true
  - require: 
    - pkg: mysql_packages


{#
# 	Backup part
#}

{#
# 	Backup part - automysqlbackup
#}

{% for backup_engine in pillar.mysql.server.get("backup_engine", []) %}

{%- if backup_engine.get("name", []) == "automysqlbackup" %}

{%- if grains.osfullname in ['CentOS'] %}

mysql_backup1_pkgs:
  pkg.installed:
  - names:
    - pigz
    - pbzip2
    - cronie
    - mailx

{%- elif grains.osfullname in ['Ubuntu'] %}

mysql_backup2_pkgs:
  pkg.installed:
  - names:
    - mailutils
    - pigz
    - pbzip2

{%- endif %}

{%- if grains.osfullname in ['CentOS'] or grains.osfullname in ['Ubuntu'] %}

mysql_backup_dirs:
  file.directory:
  - names:
    - /root/mysql/scripts
    - /root/mysql/data
    - /etc/automysqlbackup
  - mode: 700
  - user: root
  - group: root
  - makedirs: true
  - require:
{%- if grains.osfullname in ['CentOS'] %}
    - pkg: mysql_backup1_pkgs
{%- elif grains.osfullname in ['Ubuntu'] %}
    - pkg: mysql_backup2_pkgs
{%- endif %}

mysql_automysqlbackup_conf:
  file.managed:
  - name: /etc/automysqlbackup/automysqlbackup.conf
  - source: salt://mysql/conf/automysqlbackup.conf
  - mode: 644
  - template: jinja
  - require: 
    - file: mysql_backup_dirs

mysql_automysqlbackup_script:
  file.managed:
  - name: /root/mysql/scripts/automysqlbackup
  - source: salt://mysql/conf/automysqlbackup
  - mode: 755
  - require: 
    - file: mysql_backup_dirs

mysql_automysqlbackup_cron:
  file.managed:
  - name: /etc/cron.daily/automysqlbackup
  - source: salt://mysql/conf/automysqlbackup.cron
  - mode: 755
  - template: jinja
  - require: 
    - file: mysql_backup_dirs

{%- endif %}

{%- endif %}

{%- endfor %}