Created
March 11, 2014 15:18
-
-
Save jayjanssen/9487973 to your computer and use it in GitHub Desktop.
PXC config
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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