salt
/
galera-formula
forked from ExternalMirrors/galera-formula
Watch 1
Star 0
Fork 0
Code Releases 7 Activity
Saltstack Official Galera Formula
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
199 Commits
12 Branches
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
galera-formula/galera/map.jinja

152 lines
3.9KB
Raw Permalink Blame History 

  1. {% set mysql_version  = pillar.galera.get('version', {}).get('mysql', '5.6') %}

  2. {% set galera_version = pillar.galera.get('version', {}).get('galera', '3')  %}

  3. {% set engine = pillar.galera.get('engine', 'mysql') %}

  4. 

  5. {%- load_yaml as master %}

  6.   default:

  7.     max_connections: 20000

  8.     innodb_buffer_pool_size: '3138M'

  9.   Debian:

  10.     pkgs:

  11. {%- if engine == 'mysql' %}

  12.     - mysql-wsrep-{{ mysql_version }}

  13.     - python-mysqldb

  14.     - libdbd-mysql

  15.     - percona-xtrabackup

  16. {%- else %}

  17.     - mariadb-server

  18.     - mariadb-client

  19. {%- endif %}

  20.     - galera-{{ galera_version }}

  21.     - rsync

  22.     - psmisc

  23.     - netcat

  24.     - socat

  25.     - python-pymysql

  26.     service: {{ engine }}

  27.     wsrep_provider: /usr/lib/galera/libgalera_smm.so

  28.     log_file: /var/log/mysql.log

  29.     socket: /var/run/mysqld/mysqld.sock

  30.     config: /etc/mysql/my.cnf

  31.   RedHat:

  32.     pkgs:

  33.     - galera

  34.     - mariadb-galera-server

  35.     - mariadb

  36.     - MySQL-python

  37.     - rsync

  38.     - percona-xtrabackup

  39.     - psmisc

  40.     - socat

  41.     xtrabackup_repo: http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

  42.     service: mariadb

  43.     wsrep_provider: /usr/lib64/galera/libgalera_smm.so

  44.     log_file: /var/log/mariadb/mariadb.log

  45.     socket: /var/run/mariadb/mysqld.sock

  46.     config: /etc/my.cnf

  47. {%- endload %}

  48. {%- set _pillar = pillar.galera.get('master', {}) %}

  49. {%- if  _pillar|length > 1 %}

  50. {%- set master = salt['grains.filter_by'](master, merge=_pillar, base='default') %}

  51. {%- else %}

  52. {%- set master = salt['grains.filter_by'](master, base='default') %}

  53. {%- endif %}

  54. 

  55. 

  56. {%- load_yaml as slave %}

  57.   default:

  58.     max_connections: 20000

  59.     innodb_buffer_pool_size: '3138M'

  60.   Debian:

  61.     pkgs:

  62. {%- if engine == 'mysql' %}

  63.     - mysql-wsrep-{{ mysql_version }}

  64.     - python-mysqldb

  65.     - libdbd-mysql

  66.     - libmysqlclient18

  67.     - percona-xtrabackup

  68. {%- else %}

  69.     - mariadb-server

  70.     - mariadb-client

  71. {%- endif %}

  72.     - galera-{{ galera_version }}

  73.     - rsync

  74.     - psmisc

  75.     - netcat

  76.     - socat

  77.     - python-pymysql

  78.     service: {{ engine }}

  79.     wsrep_provider: /usr/lib/galera/libgalera_smm.so

  80.     log_file: /var/log/mysql.log

  81.     socket: /var/run/mysqld/mysqld.sock

  82.     config: /etc/mysql/my.cnf

  83.   RedHat:

  84.     pkgs:

  85.     - galera

  86.     - mariadb-galera-server

  87.     - mariadb

  88.     - MySQL-python

  89.     - rsync

  90.     - percona-xtrabackup

  91.     - psmisc

  92.     - socat

  93.     xtrabackup_repo: http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

  94.     service: mariadb

  95.     wsrep_provider: /usr/lib64/galera/libgalera_smm.so

  96.     log_file: /var/log/mariadb/mariadb.log

  97.     socket: /var/run/mariadb/mysqld.sock

  98.     config: /etc/my.cnf

  99. {%- endload %}

  100. {%- load_yaml as slave_oscodename %}

  101.   trusty:

  102.     pkgs:

  103.     - mysql-wsrep-{{ mysql_version }}

  104.     - galera-{{ galera_version }}

  105.     - rsync

  106.     - python-mysqldb

  107.     - libmysqlclient18

  108.     - psmisc

  109.     - netcat

  110.     - percona-xtrabackup

  111.     - socat

  112.     - libdbd-mysql

  113.     - python-pymysql

  114.   xenial:

  115.     pkgs:

  116.     - mysql-wsrep-{{ mysql_version }}

  117.     - galera-{{ galera_version }}

  118.     - rsync

  119.     - python-mysqldb

  120.     - libmysqlclient-dev

  121.     - psmisc

  122.     - netcat

  123.     - percona-xtrabackup

  124.     - socat

  125.     - libdbd-mysql

  126.     - python-pymysql

  127. {%- endload %}

  128. {%- set _pillar = pillar.galera.get('slave', {}) %}

  129. {%- if  _pillar|length > 1 %}

  130. {%- set _oscodename = salt['grains.filter_by'](slave_oscodename, grain='oscodename', merge=_pillar) %}

  131. {%- else %}

  132. {%- set _oscodename = salt['grains.filter_by'](slave_oscodename, grain='oscodename') %}

  133. {%- endif %}

  134. {%- set slave = salt['grains.filter_by'](slave, merge=_oscodename, base='default') %}

  135. 

  136. {% set clustercheck = salt['grains.filter_by']({

  137.   'Debian': {

  138.     'config': '/etc/mysql/my.cnf',

  139.     'enabled': False,

  140.     'user': clustercheck,

  141.     'password': clustercheck,

  142.     'port': '9200'

  143.     },

  144.   'RedHat': {

  145.     'config': '/etc/my.cnf',

  146.     'enabled': False,

  147.     'user': clustercheck,

  148.     'password': clustercheck,

  149.     'port': '9200'

  150.     },

  151. }, merge=pillar.galera.get('clustercheck', {})) %}