Skip to content

Instantly share code, notes, and snippets.

@jayjanssen
Created March 11, 2014 15:18
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 jayjanssen/9487973 to your computer and use it in GitHub Desktop.
Save jayjanssen/9487973 to your computer and use it in GitHub Desktop.
PXC config
[mysqld]
datadir = /var/lib/mysql
query_cache_size=0
query_cache_type=0
binlog_format = ROW
innodb_buffer_pool_size = 128M
#^^ or however much you can allocate to MySQL on this machien
innodb_flush_method = O_DIRECT
innodb_file_per_table
innodb_flush_log_at_trx_commit = 0
innodb_autoinc_lock_mode = 2
wsrep_cluster_name = mycluster
wsrep_cluster_address = gcomm://192.168.0.2,192.168.0.3,192.168.0.4
# ^^ change to the ips or locally resolvable hostnames of all cluster nodes
wsrep_node_address = <local ip for cluster replication>
# ^^ only set this if you need to use the non-default NIC
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_provider_options = "gcs.fc_limit=512;gcache.size=1G"
wsrep_slave_threads = 4
wsrep_sst_method = xtrabackup
wsrep_sst_auth = sst:secret
# ^^ change secret to some other password
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment