MySQL-Server/my3_gr.cnf at main · khollman5/MySQL-Server · GitHub

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
63
64
65
66
67
68
69
70
71
72
73
[client]
port				=3303
socket				=/opt/mysql/5714GR/mysql_5714GR3.sock

[mysql]
no-beep
port				=3303
no-auto-rehash
compress
show-warnings
#prompt                          = \R:\m \d>\_
prompt                          ='server3> '
user                            =root
password                        =oracle

[mysqld_safe]
log-error			=/opt/mysql/5714GR/mysqld_5714GR3.log

[mysqld]
user				=mysql
port				=3303
basedir				=/usr/local/mysql-advanced-5.7.14-linux-glibc2.5-x86_64
datadir				=/opt/mysql/5714GR/data3
lc_messages_dir                 =/usr/local/mysql-advanced-5.7.14-linux-glibc2.5-x86_64/share
socket				=/opt/mysql/5714GR/mysql_5714GR3.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_5714GR3.log
#slow-query-log			=1
#slow_query_log_file		=khollman_5714GR3-slow.log
#long_query_time			=10
log-error			=khollman_5714GR3.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			=3
log-slave-updates		=TRUE
gtid-mode			=ON
enforce-gtid-consistency	=TRUE
master-info-repository		=TABLE
relay-log-info-repository	=TABLE
relay-log                       =5714GR3_relay
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			=3303
log-bin				=5714GR3
binlog_format			=ROW
report-host			=127.0.0.1
#replicate-do-db			=nexus
# Group Replication requirement:
transaction-write-set-extraction=MURMUR32
binlog-checksum			=NONE
plugin-dir			=lib/plugin
plugin-load			=group_replication.so
group_replication_group_name    ="8a94f357-aab4-11df-86ab-c80aa9429562"
group_replication_local_address =127.0.0.1:10303
group_replication_peer_addresses=127.0.0.1:10301,127.0.0.1:10302,127.0.0.1:10303
group_replication_recovery_retry_count= 2
group_replication_recovery_reconnect_interval= 120
group_replication_start_on_boot	=1