##############################
## UpSQL 8.0.18 ##
##############################
[mysqld]
# basic settings #
user = upsql
server_id = 2344
port = 60014
socket = /etc/mysock/upsql.sock
basedir = /usr/local/upsql-2.4.0-centos7-x86_64
datadir = /home/upsql/upsql/data
tmpdir = /home/upsql/upsql/data
innodb_log_group_home_dir = /home/upsql/upsql/redolog
innodb_undo_directory = /home/upsql/upsql/undolog
log_bin = /home/upsql/upsql/binlog/phy-30-22-upsql-bin
relay_log = /home/upsql/upsql/relaylog/phy-30-22-upsql-relay

default_time_zone = "+08:00"
default_authentication_plugin = mysql_native_password
character_set_server = utf8mb4
transaction_isolation = READ-COMMITTED
explicit_defaults_for_timestamp = 1
max_allowed_packet = 16M
lower_case_table_names = 0
open_files_limit = 10240
secure_file_priv = ""
plugin_load = "group_replication.so;rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"

# connection settings #
interactive_timeout = 31536000
wait_timeout = 31536000
lock_wait_timeout = 3600
skip_name_resolve = 1
max_connections = 10000    # ulimit -n >= 1834
thread_cache_size = 1536
thread_stack = 512K
max_connect_errors = 50000
connect_timeout = 60
binlog_checksum = NONE

# table cache performance settings #
table_open_cache = 4096
table_definition_cache = 4096
table_open_cache_instances = 64

# session memory settings #
read_buffer_size = 8M         # 影响ORDER BY性能，缓存嵌套查询结果
read_rnd_buffer_size = 16M    # 提升ORDER BY性能
sort_buffer_size = 16M        # 提升ORDER BY和GROUP BY性能
join_buffer_size = 16M        # 联表查询且无索引可用时使用
tmp_table_size = 32M          # 复杂查询使用内存临时表大小，超过限制则会创建临时文件
key_buffer_size = 32M

# log settings #
slow_query_log = 1
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_throttle_queries_not_using_indexes = 10
expire_logs_days = 10
log_bin_trust_function_creators = 1
binlog_cache_size = 4M
max_binlog_cache_size = 4G
binlog_gtid_simple_recovery = 1
log_timestamps = system

# innodb settings #
innodb_data_file_path = ibdata1:1G:autoextend
innodb_buffer_pool_size = 64G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 512M
innodb_log_files_in_group = 7
innodb_lru_scan_depth = 4096
innodb_lock_wait_timeout = 60
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
innodb_flush_method = O_DIRECT
innodb_undo_tablespaces = 3
innodb_thread_concurrency = 80    # cores * 2
innodb_write_io_threads = 20      # cores / 2
innodb_read_io_threads = 20       # cores / 2
innodb_print_all_deadlocks = 1
innodb_sort_buffer_size = 64M
innodb_stats_persistent_sample_pages = 64
innodb_online_alter_log_max_size = 4G
innodb_log_buffer_size = 128M
innodb_rollback_on_timeout = ON
innodb_purge_threads = 8
innodb_page_cleaners = 8
innodb_undo_log_truncate = 1
innodb_sync_spin_loops = 30
innodb_spin_wait_delay = 6

# replication settings #
gtid_mode = ON
enforce_gtid_consistency = 1
master_verify_checksum = ON
 
# master settings #
auto_increment_increment
auto_increment_offset

# slave settings #
master_info_repository = TABLE
relay_log_info_repository = TABLE
slave_parallel_type = LOGICAL_CLOCK
slave_parallel_workers = 64
slave_rows_search_algorithms = "INDEX_SCAN,HASH_SCAN"
log_slave_updates = 1
relay_log_recovery = 1

# semi-sync replication settings #
loose_rpl_semi_sync_master_enabled = 1
loose_rpl_semi_sync_slave_enabled = 1
loose_rpl_semi_sync_master_timeout = 3000

# DBPM settings #

# ETL settings #
#Please use comma as separator

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on

# group replication settings #
binlog_checksum=NONE
loose-group_replication_group_name="0843ba7b-0d7d-41dd-90ab-753bd6e00b8f"
transaction_write_set_extraction=XXHASH64
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.21.30.22:34901"
loose-group_replication_group_seeds= "172.21.30.22:34901,172.18.63.20:34901,172.18.63.13:34901"
loose_group_replication_ip_whitelist = "172.21.30.22,172.18.63.20,172.18.63.13"
loose-group_replication_bootstrap_group= off
slave_preserve_commit_order = on