| # All files in this package is subject to the GPL v2 license |
| # More information is in the COPYING file in the top directory of this package. |
| # Copyright (C) 2011 severalnines.com |
| {%- if pillar.galera.master is defined %} |
| {%- from "galera/map.jinja" import master with context %} |
| {%- set service = master %} |
| {%- endif %} |
| {%- if pillar.galera.slave is defined %} |
| {%- from "galera/map.jinja" import slave with context %} |
| {%- set service = slave %} |
| {%- endif %} |
| |
| [mysqld] |
| datadir=/var/lib/mysql |
| bind-address={{ service.bind.address }} |
| port=3306 |
| max_connections={{ service.get('max_connections', 20000) }} |
| default-storage-engine=innodb |
| binlog_format=ROW |
| collation-server=utf8_general_ci |
| init-connect='SET NAMES utf8' |
| character-set-server=utf8 |
| default-storage-engine=innodb |
| log_error=/var/log/mysql/error.log |
| skip-external-locking |
| skip-name-resolve |
| |
| myisam_sort_buffer_size=64M |
| wait_timeout=1800 |
| open_files_limit=102400 |
| table_open_cache=10000 |
| key_buffer_size=64M |
| max_allowed_packet=256M |
| query_cache_size=0 |
| query_cache_type=0 |
| |
| innodb_file_format=Barracuda |
| innodb_file_per_table=1 |
| innodb_buffer_pool_size=3138M |
| innodb_log_file_size=627M |
| innodb_read_io_threads=8 |
| innodb_write_io_threads=8 |
| innodb_io_capacity=500 |
| innodb_flush_log_at_trx_commit=2 |
| innodb_flush_method=O_DIRECT |
| innodb_doublewrite=0 |
| innodb_autoinc_lock_mode=2 |
| innodb_locks_unsafe_for_binlog=1 |
| |
| wsrep_cluster_address="gcomm://{% for member in service.members %}{{ member.host}}:4567{% if not loop.last %},{% endif %}{% endfor %}/?pc.wait_prim=no" |
| wsrep_provider={{ service.wsrep_provider }} |
| wsrep_cluster_name="openstack" |
| |
| wsrep_slave_threads=8 |
| wsrep_sst_method=xtrabackup-v2 |
| wsrep_sst_auth={{ service.admin.user }}:{{ service.admin.password }} |
| wsrep_node_address={{ service.bind.address }} |
| wsrep_provider_options="gcache.size = 256M" |
| wsrep_provider_options="gmcast.listen_addr = tcp://{{ service.bind.address }}:4567" |
| |
| [xtrabackup] |
| parallel=4 |
| |
| [sst] |
| streamfmt=xbstream |
| transferfmt=socat |
| sockopt=,nodelay,sndbuf=1048576,rcvbuf=1048576 |