-
Notifications
You must be signed in to change notification settings - Fork 1
/
my.cnf
55 lines (55 loc) · 1.43 KB
/
my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
#
[mysqld_safe]
wsrep_cluster_address = gcomm://10.1.1.1:4567,gcomm://10.1.1.2:4567,gcomm://10.1.1.3: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_instances = 16
innodb_buffer_pool_size = 40G # XXX 64GB RAM
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 = XXX # XXX
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_provider_options = "gcache.size=4G"
wsrep_slave_threads = 8
wsrep_sst_auth = "mysqluser:mysqlPASSWORD" # XXX
wsrep_sst_method = xtrabackup
#
# XXX You *MUST* change!
server-id =