| # 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] |
| user=mysql |
| basedir=/usr/ |
| datadir=/var/lib/mysql |
| socket={{ service.socket }} |
| pid_file=mysqld.pid |
| port=3306 |
| log_error={{ service.log_file }} |
| log_warnings=2 |
| #log_output=FILE |
| ### INNODB OPTIONS |
| innodb_buffer_pool_size=9211M |
| innodb_flush_log_at_trx_commit=2 |
| innodb_file_per_table=1 |
| innodb_data_file_path = ibdata1:100M:autoextend |
| ## You may want to tune the below depending on number of cores and disk sub |
| innodb_read_io_threads=4 |
| innodb_write_io_threads=4 |
| innodb_io_capacity=200 |
| innodb_doublewrite=1 |
| innodb_log_file_size=1024M |
| innodb_log_buffer_size=96M |
| innodb_buffer_pool_instances=8 |
| innodb_log_files_in_group=2 |
| innodb_thread_concurrency=64 |
| #innodb_file_format=barracuda |
| innodb_flush_method = O_DIRECT |
| innodb_autoinc_lock_mode=2 |
| ## avoid statistics update when doing e.g show tables |
| innodb_stats_on_metadata=0 |
| default_storage_engine=innodb |
| |
| bind-address={{ service.bind.address }} |
| |
| # CHARACTER SET |
| #collation_server = utf8_unicode_ci |
| #init_connect='SET NAMES utf8' |
| character_set_server = utf8 |
| |
| # REPLICATION SPECIFIC |
| #server_id must be unique across all mysql servers participating in replication. |
| #server_id=SERVERID |
| binlog_format=ROW |
| #log_slave_updates=1 |
| #log_bin=binlog |
| #relay_log=relay-bin |
| #expire_logs_days=7 |
| #gtid_mode=ON |
| #enforce_gtid_consistency=1 |
| # OTHER THINGS, BUFFERS ETC |
| key_buffer_size = 24M |
| tmp_table_size = 64M |
| max_heap_table_size = 64M |
| max_allowed_packet = 512M |
| #sort_buffer_size = 256K |
| #read_buffer_size = 256K |
| #read_rnd_buffer_size = 512K |
| #myisam_sort_buffer_size = 8M |
| skip_name_resolve |
| memlock=0 |
| sysdate_is_now=1 |
| max_connections={{ service.get('max_connections', 20000) }} |
| thread_cache_size=512 |
| query_cache_type = 0 |
| query_cache_size = 0 |
| table_open_cache=1024 |
| lower_case_table_names=0 |
| # 5.6 backwards compatibility |
| #explicit_defaults_for_timestamp=1 |
| # |
| |
| # Desired SST donor name. |
| #wsrep_sst_donor= |
| |
| # Protocol version to use |
| # wsrep_protocol_version= |
| [MYSQL] |
| socket={{ service.socket }} |
| #default_character_set=utf8 |
| [client] |
| socket={{ service.socket }} |
| default_character_set=utf8 |
| [mysqldump] |
| max_allowed_packet = 512M |
| socket={{ service.socket }} |
| default_character_set=utf8 |
| [MYSQLD_SAFE] |
| pid_file=mysqld.pid |
| log_error={{ service.log_file }} |
| basedir=/usr/ |
| datadir=/var/lib/mysql |