-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmy5714.cnf
More file actions
62 lines (58 loc) · 1.53 KB
/
Copy pathmy5714.cnf
File metadata and controls
62 lines (58 loc) · 1.53 KB
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
56
57
58
59
60
61
62
[client]
port =3357
socket =/opt/mysql/5714/mysql_5714.sock
[mysql]
no-beep
port =3357
no-auto-rehash
compress
show-warnings
prompt = \R:\m \d>\_
[mysqld_safe]
log-error =/opt/mysql/5714/mysqld_5714.log
[mysqld]
user =mysql
port =3357
basedir =/usr/local/mysql-advanced-5.7.14-linux-glibc2.5-x86_64
datadir =/opt/mysql/5714/data
socket =/opt/mysql/5714/mysql_5714.sock
default-storage-engine =INNODB
sql-mode ="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
lower_case_table_names =1
general-log =1
general_log_file =khollman_5714.log
#slow-query-log =1
#slow_query_log_file =khollman_5714-slow.log
#long_query_time =10
log-error =khollman_5714.err
max_connections =100
query_cache_type =0
query_cache_size =0
innodb_file_per_table =1
explicit_defaults_for_timestamp =1
# Replication
server-id =1
log-slave-updates =TRUE
gtid-mode =ON
enforce-gtid-consistency =TRUE
master-info-repository =TABLE
relay-log-info-repository =TABLE
innodb_flush_log_at_trx_commit =1
sync_binlog =1
sync_master_info =1
slave-parallel-workers =2
slave_transaction_retries =0
binlog-checksum =CRC32
master-verify-checksum =1
slave-sql-verify-checksum =1
binlog-rows-query-log-events =1
report-port =3357
log-bin =khollman_5714
binlog_format =ROW
report-host =khollman-es
#replicate-do-db =nexus
# Group Replication requirement:
transaction-write-set-extraction=MURMUR32
binlog-checksum =NONE
plugin-dir =lib/plugin
plugin-load =group_replication.so