Group Replication script extracts ... start ... if [ "$CONF" = "gr" ]; then if [ "$FLOWCONTROL" == "default" ]; then $HOME/works/scripts/mystart.sh $CNF-$NODE_IDX.cnf --plugin-load=group_replication.so --slave-parallel-workers=16 --slave-transaction-retries=10\ --slave-parallel-type=logical_clock --group_replication_auto_increment_increment=9 --transaction_write_set_extraction=XXHASH64\ --log-bin=mybinlog --log-slave-updates --binlog-checksum=NONE else if [ "$FLOWCONTROL" == "0" ]; then $HOME/works/scripts/mystart.sh $CNF-$NODE_IDX.cnf --plugin-load=group_replication.so --slave-parallel-workers=16 --slave-transaction-retries=10\ --slave-parallel-type=logical_clock --group_replication_auto_increment_increment=9 --transaction_write_set_extraction=XXHASH64\ --group_replication_flow_control_mode=DISABLED --log-bin=mybinlog --log-slave-updates --binlog-checksum=NONE else $HOME/works/scripts/mystart.sh $CNF-$NODE_IDX.cnf --plugin-load=group_replication.so --slave-parallel-workers=16 --slave-transaction-retries=10\ --slave-parallel-type=logical_clock --group_replication_auto_increment_increment=9 --transaction_write_set_extraction=XXHASH64\ --group_replication_flow_control_mode=QUOTA --group_replication_flow_control_certifier_threshold=1000 \ --group_replication_flow_control_applier_threshold=1000 --log-bin=mybinlog --log-slave-updates --binlog-checksum=NONE fi fi fi ... config ... if [ "$CONF" = "gr" ]; then if [ "$NODE_IDX" = "1" ]; then $HOME/works/scripts/myexec.sh $CNF-$NODE_IDX.cnf " CHANGE MASTER TO MASTER_USER='root', MASTER_PASSWORD='rmysql' FOR CHANNEL 'group_replication_recovery'; SET GLOBAL transaction_write_set_extraction=XXHASH64; SET GLOBAL slave_preserve_commit_order=on; SET GLOBAL slave_parallel_type=LOGICAL_CLOCK; SET GLOBAL slave_parallel_workers=16; SET GLOBAL sync_relay_log_info=0; SET GLOBAL sync_master_info=0; SET GLOBAL sync_relay_log=0; SET GLOBAL binlog_row_image=full; SET GLOBAL group_replication_single_primary_mode=FALSE; SET GLOBAL group_replication_group_name='8b94f357-aab4-11df-86ab-c80aa9429562'; SET GLOBAL group_replication_local_address='${NODE_LIST[$(($NODE_IDX-1))]}'; SET GLOBAL group_replication_group_seeds='${NODES}'; SET GLOBAL group_replication_bootstrap_group=1; SET GLOBAL group_replication_compression_threshold=0; SET GLOBAL group_replication_gtid_assignment_block_size=1000000;" else $HOME/works/scripts/myexec.sh $CNF-$NODE_IDX.cnf " CHANGE MASTER TO MASTER_USER='root', MASTER_PASSWORD='rmysql' FOR CHANNEL 'group_replication_recovery'; SET GLOBAL transaction_write_set_extraction=XXHASH64; SET GLOBAL slave_preserve_commit_order=on; SET GLOBAL slave_parallel_type=LOGICAL_CLOCK; SET GLOBAL slave_parallel_workers=16; SET GLOBAL sync_relay_log_info=0; SET GLOBAL sync_master_info=0; SET GLOBAL sync_relay_log=0; SET GLOBAL binlog_row_image=full; SET GLOBAL group_replication_single_primary_mode=FALSE; SET GLOBAL group_replication_group_name= '8b94f357-aab4-11df-86ab-c80aa9429562'; SET GLOBAL group_replication_local_address= '${NODE_LIST[$(($NODE_IDX-1))]}'; SET GLOBAL group_replication_group_seeds='${NODES}'; SET GLOBAL group_replication_compression_threshold=0; SET GLOBAL group_replication_gtid_assignment_block_size=1000000;" fi $HOME/works/scripts/myexec.sh $CNF-$NODE_IDX.cnf "START GROUP_REPLICATION;" ...