START GROUP_REPLICATION;

ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.

# General replication settings
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_checksum = NONE
log_slave_updates = ON
log_bin = binlog
binlog_format = ROW
transaction_write_set_extraction = XXHASH64
loose-group_replication_bootstrap_group = OFF
loose-group_replication_start_on_boot = OFF
loose-group_replication_ssl_mode = REQUIRED
loose-group_replication_recovery_use_ssl = 1

# Shared replication group configuration
loose-group_replication_group_name = "$serveruuid"
loose-group_replication_ip_whitelist = "$PrivateIpsOfServers"
loose-group_replication_group_seeds = "$PrivateIpsOfServersWithPort"

# Single or Multi-primary mode? Uncomment these two lines
# for multi-primary mode, where any host can accept writes
loose-group_replication_single_primary_mode = OFF
loose-group_replication_enforce_update_everywhere_checks = ON

# Host specific replication configuration
server_id = $serverid
bind-address = "0.0.0.0"
report_host = "$privateip"
loose-group_replication_local_address = "$privateip:33061"

SET SQL_LOG_BIN=0;
CREATE USER 'repl'@'%' IDENTIFIED BY '$mysqlrepl' REQUIRE SSL;
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
FLUSH PRIVILEGES;
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='$mysqlchannel' FOR CHANNEL 'group_replication_recovery';
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
CREATE DATABASE IF NOT EXISTS PricingV2;
CREATE USER 'pricing-worker'@'%' IDENTIFIED BY '$mysqlworker';
GRANT ALL PRIVILEGES ON PricingV2.* TO 'pricing-worker'@'%';
FLUSH PRIVILEGES;
SET GLOBAL group_replication_bootstrap_group=ON;