#    The MySQL Sandbox
#    Copyright (C) 2006-2015 Giuseppe Maxia
#
#    Licensed under the Apache License, Version 2.0 (the "License");
#    you may not use this file except in compliance with the License.
#    You may obtain a copy of the License at
#                                                                             
#        http://www.apache.org/licenses/LICENSE-2.0
#                                                                             
#    Unless required by applicable law or agreed to in writing, software
#    distributed under the License is distributed on an "AS IS" BASIS,
#    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#    See the License for the specific language governing permissions and
#    limitations under the License.


[mysql]
prompt='node1 [\h] {\u} (\d) > '
#

[client]
user               = msandbox
password           = msandbox
port               = 14115
socket             = /tmp/mysql_sandbox14115.sock

[mysqld]
user               = sh
port               = 14115
socket             = /tmp/mysql_sandbox14115.sock
basedir            = /home/sh/MySQLPakcages/5.7.14
datadir            = /home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/data
tmpdir             = /home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/tmp
lower_case_table_names = 0
pid-file           = /home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/data/mysql_sandbox14115.pid
bind-address       = 127.0.0.1
# slow-query-log = on
# slow-query-log-file=/home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/data/msandbox-slow.log
# general-log = on
# general-log-file=/home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/data/msandbox-general.log
#
# additional options passed through 'my_clause' 
#
server-id=101
relay-log-index=mysql-relay
relay-log=mysql-relay
log-bin=mysql-bin
log-error=msandbox.err

ssl-ca = ca.pem
ssl-cert = server-cert.pem
ssl-key = server-key.pem

binlog-row-image = MINIMAL
binlog-rows-query-log-events = ON
log-bin-trust-function-creators = TRUE
expire-logs-days = 90
max-binlog-size = 1G
relay-log-recovery = ON
slave-parallel-type = LOGICAL_CLOCK
slave-preserve-commit-order = ON
slave-rows-search-algorithms = 'INDEX_SCAN,HASH_SCAN'
slave-type-conversions = ALL_NON_LOSSY
sync-master-info = 1000
sync-relay-log = 1000

binlog-format = ROW
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
master-info-repository = TABLE
relay-log-info-repository = TABLE
binlog-checksum = NONE
slave-parallel-workers = 0
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE"

plugin-load = group_replication.so
group_replication = FORCE_PLUS_PERMANENT
transaction-write-set-extraction = XXHASH64
group_replication_start_on_boot = ON
group_replication_bootstrap_group = OFF
group_replication_group_name = 550fa9ee-a1f8-4b6d-9bfe-c03c12cd1c72
group_replication_local_address = '192.168.5.148:6606'
group_replication_group_seeds = '192.168.5.148:6607,192.168.5.148:6608'

early-plugin-load=keyring_file.so
keyring_file_data=/home/sh/sandboxes/multi_msb_mysql-5_7_14/node1/tmp/keyring

group_replication_allow_local_disjoint_gtids_join = ON