Skip to content

Instantly share code, notes, and snippets.

@gslin
Created May 13, 2013 03:32
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 gslin/5565994 to your computer and use it in GitHub Desktop.
Save gslin/5565994 to your computer and use it in GitHub Desktop.
# [mysqld_safe]
wsrep_urls = gcomm://10.1.1.101:4567,gcomm://10.1.1.102:4567,gcomm://10.1.1.103:4567,gcomm://
#
# Default values.
[mysqld]
binlog_format = ROW
character_set_server = utf8
collation_server = utf8_general_ci
datadir = /var/lib/mysql
default_storage_engine = InnoDB
expire_logs_days = 7
innodb_additional_mem_pool_size = 64M
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_size = 512M
innodb_data_file_path = ibdata1:64M;ibdata2:64M:autoextend
innodb_file_format = Barracuda
innodb_file_per_table
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_io_capacity = 1600
innodb_locks_unsafe_for_binlog = 1
innodb_log_file_size = 64M
innodb_read_io_threads = 64
innodb_support_xa = FALSE
innodb_write_io_threads = 64
key_buffer_size = 32M
log-bin = mysqld-bin
log-queries-not-using-indexes
log-slave-updates
long_query_time = 1
max_allowed_packet = 64M
max_connect_errors = 4294967295
max_connections = 4096
port = 3306
skip-name-resolve
slow_query_log = 1
table_cache = 4096
thread_cache = 1024
tmpdir = /srv/tmp
transaction_isolation = REPEATABLE-READ
user = mysql
wait_timeout = 60
#
# Galera
wsrep_cluster_name = db-test
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_provider_options = "gcache.size=128M"
wsrep_slave_threads = 8
wsrep_sst_auth = "x:x"
wsrep_sst_method = xtrabackup
#
# XXX You *MUST* change!
server-id = 65893
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment