|
-
-
-
- {%- 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
-
-
- innodb_buffer_pool_size=9211M
- innodb_flush_log_at_trx_commit=2
- innodb_file_per_table=1
- innodb_data_file_path = ibdata1:100M:autoextend
-
- 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_flush_method = O_DIRECT
- innodb_autoinc_lock_mode=2
-
- innodb_stats_on_metadata=0
- default_storage_engine=innodb
-
- bind-address={{ service.bind.address }}
-
-
-
-
- character_set_server = utf8
-
-
-
-
- binlog_format=ROW
-
-
-
-
-
-
-
- key_buffer_size = 24M
- tmp_table_size = 64M
- max_heap_table_size = 64M
- max_allowed_packet = 512M
-
-
-
-
- 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
-
-
-
-
-
-
-
- wsrep_provider={{ service.wsrep_provider }}
-
- wsrep_node_address={{ service.bind.address }}
-
- wsrep_provider_options="gcache.size=8192M"
-
-
- wsrep_cluster_name="my_wsrep_cluster"
-
-
- wsrep_cluster_address=gcomm://
-
-
- wsrep_node_name={{ service.bind.address }}
-
-
-
-
-
- wsrep_slave_threads=8
-
-
-
-
-
-
- wsrep_certify_nonPK=1
-
-
-
-
-
-
- wsrep_max_ws_rows=131072
-
-
- wsrep_max_ws_size=1073741824
-
-
- wsrep_debug=0
-
-
- wsrep_convert_LOCK_to_trx=0
-
-
- wsrep_retry_autocommit=1
-
-
- wsrep_auto_increment_control=1
-
-
- wsrep_replicate_myisam=1
-
- wsrep_drupal_282555_workaround=0
-
-
- wsrep_causal_reads=0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- wsrep_sst_method=xtrabackup
-
-
-
-
-
-
-
- wsrep_sst_auth={{ service.admin.user }}:{{ service.admin.password }}
-
-
-
-
-
-
- [MYSQL]
- socket={{ service.socket }}
-
- [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
|