mysql 参数前带 loose 是什么意思了

程序员文章站 2022-07-15 13:27:01

...

mysql 参数前带 loose 是什么意思了？

插件相关的参数只能在插件加载之后设置，如果想启动时设置这些参数并且启动后加载插件到配置文件中，可以在参数前加上“loose-”前缀。

##########################
# group replication
##########################
transaction_write_set_extraction=XXHASH64
# show master status.Executed_Gtid_Set;
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_bootstrap_group=off
loose-group_replication_start_on_boot=off
loose-group_replication_recovery_retry_count=31536000

# singe primary or multi primary mode 
loose-group_replication_single_primary_mode=on
loose-group_replication_enforce_update_everywhere_checks=off
loose-group_replication_local_address= "192.168.56.63:24901"
loose-group_replication_group_seeds="192.168.56.61:24901,192.168.56.62:24901,192.168.56.63:24901"
loose-group_replication_ip_whitelist="192.168.56.0/24,127.0.0.1/8"

参考: