Skip to content

Instantly share code, notes, and snippets.

@alexclear
Created June 10, 2014 04:57
Show Gist options
  • Save alexclear/061bfeae1499a464c992 to your computer and use it in GitHub Desktop.
Save alexclear/061bfeae1499a464c992 to your computer and use it in GitHub Desktop.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
#query_cache_limit = 1M
query_cache_size = 0
binlog_format = ROW
innodb_autoinc_lock_mode=2
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_buffer_pool_size = 4096M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 128M
innodb_log_buffer_size = 32M
default-storage-engine = InnoDB
innodb_file_per_table = 1
max_connections = 250
tmp_table_size=128M
max_heap_table_size=128M
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options = "evs.keepalive_period = PT3S; evs.inactive_check_period = PT10S; evs.suspect_timeout = PT30S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M; gcache.size=256M"
wsrep_cluster_address=gcomm://10.0.2.230,10.0.3.66,10.0.4.124
wsrep_cluster_name="cluster"
wsrep_node_address="10.0.3.66"
wsrep_node_name="cluster_2"
wsrep_sst_method=xtrabackup
wsrep_sst_auth="root:pa$$w0rd"
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment