Skip to content

Instantly share code, notes, and snippets.

@fipar

fipar/example_my.cnf

Created November 18, 2016 17:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fipar/b69a205fc5c2968e4ca82d0cc79b5260 to your computer and use it in GitHub Desktop.
Save fipar/b69a205fc5c2968e4ca82d0cc79b5260 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example_my.cnf
[mysqld]
tmpdir = /tmp
# Threads
max_connections = 200
# networking
skip-name-resolve
#####################
#InnoDB settings
#####################
innodb_buffer_pool_size = 1G
#####################
#Query cache
#####################
query_cache_type = 0
query_cache_size = 0
query_cache_limit = 0
#########################
# Galera Options
#########################
wsrep_on = ON
wsrep_provider = /usr/lib/libgalera_smm.so
wsrep_provider_options =
wsrep_cluster_name = pxc_bootstrap
wsrep_cluster_address = gcomm://192.168.55.101,192.168.55.102,192.168.55.103
wsrep_node_address = 192.168.55.101
wsrep_log_conflicts = 1
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = sstuser:sstpass
# Galera overrides
binlog_format = ROW
innodb_autoinc_lock_mode = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment