osmap.yaml

# vim: ft=sls
# vim: sts=2 ts=2 sw=2 et ai

  {% if grains.os == 'MacOS' %}
MacOS:
  macos:
    user:  {{ salt['pillar.get']('mysql:user', salt['cmd.run']("stat -f '%Su' /dev/console")) }}
    group: {{ salt['pillar.get']('mysql:group', salt['cmd.run']("stat -f '%Sg' /dev/console")) }}
  {% endif %}

Debian:
  service: mysql

Ubuntu:
  service: mysql
  devpkg: libmysqlclient-dev
  config:
    sections:
      mysqld:
        tmpdir: /tmp
        log_error: /var/log/mysql/error.log
    append: |
      !includedir /etc/mysql/conf.d/

CentOS:
  # https://mariadb.com/blog/rhel7-transition-mysql-mariadb-first-look
  {%- if salt['grains.get']('osmajorrelease')|int in [7] %}
    {% set fork = 'mariadb' %}
    {% set service = 'mariadb' %}
  {%- else %}
    {% set fork = 'mysql' %}
    {% set service = 'mysqld' %}
  {%- endif %}

  config_directory: /etc/my.cnf.d/
  server_config:
    file: server.cnf
    sections:
      mysqld_safe:
        log_error: /var/log/{{ fork }}/mysqld.log
        pid_file: /var/run/{{ fork }}/mysqld.pid
      mysqld:
        socket: /var/lib/mysql/mysql.sock
        bind_address: 127.0.0.1

Fedora:
  serverpkg: mariadb-server
  clientpkg: mariadb
  service: mariadb
  pythonpkg: python2-mysql
  config_directory: /etc/my.cnf.d/

  server_config:
    file: server.cnf
    sections:
      mysqld_safe:
        log_error: /var/log/mariadb/mariadb.log
        pid_file: /var/lib/mysql/mysql.pid
      mysqld:
        socket: /var/lib/mysql/mysql.sock
        bind_address: 127.0.0.1

  galera_config:
    file: galera.cnf
    sections:
      mysqld:
        bind-address: 0.0.0.0
        binlog_format: ROW
        default-storage-engine: innodb
        innodb_autoinc_lock_mode: 2