mysql组复制配置文件参数



组复制的配置文件参数：

[root@alimysql01 ~]# cat /etc/my.cnf
[mysqld]
user =mysql         #  mysql
plugin-dir=/opt/mysql/plugin_data
basedir =/usr/local/mysql        #  /usr/local/mysql/
datadir =/opt/mysql         #  /usr/local/mysql/data
server_id        =81        #  0
port          =3306            #  3306
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
symbolic-links=0
socket          =/opt/mysql/mysql.sock        #  /tmp/mysql.sock
#socket=/var/lib/mysql/mysql.sock
auto_increment_increment    =1            #  1
auto_increment_offset      =1            #  1
lower_case_table_names      =1            #  0
secure_file_priv =            #  null
skip-name-resolve
max_heap_table_size = 64M
####: for binlog
binlog_format        =row            #  row
log_bin          =mysql-bin          #  off
binlog_rows_query_log_events    =on            #  off
log_slave_updates      =on            #  off
expire_logs_days      =15            #  0
binlog_cache_size      =32768            #  32768(32k)
binlog_checksum        =none            #  CRC32
sync_binlog        =1            #  1
skip-name-resolve
max_connections = 512
max_connect_errors = 1000000
max_allowed_packet = 32M
interactive_timeout = 1800
wait_timeout = 1800
tmp_table_size = 64M
read_buffer_size = 16M
read_rnd_buffer_size = 32M
####: for error-log
#log_error        =mysql-err.log          #  /usr/local/mysql/data/localhost.localdomain.err

####: for slow query log
 
####: for gtid
gtid_mode        =on            #  off
enforce_gtid_consistency    =on            #  off
 
 
####: for replication
master_info_repository      =table            #  file
relay_log_info_repository    =table            #  file
relay_log_recovery=1
event_scheduler = 1
####: for group replication
transaction_write_set_extraction  =XXHASH64          #  off
loose-group_replication_group_name  ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"    # 
loose-group_replication_start_on_boot  =off            #  off
loose-group_replication_local_address  ="192.168.11.81:24901"        #
loose-group_replication_group_seeds  ="192.168.11.81:24901,192.168.11.82:24902,192.168.11.83:24903"
loose-group_replication_bootstrap_group  =off            #  off
loose-group_replication_single_primary_mode=true
loose-group_replication_enforce_update_everywhere_checks=false
 
####: for innodb
default_storage_engine      =innodb            #  innodb
default_tmp_storage_engine    =innodb            #  innodb
innodb_data_file_path =ibdata1:12M:autoextend    #ibdata1:12M:autoextend默认会在datadir目录下创建ibdata1
innodb_temp_data_file_path  =ibtmp1:12M:autoextend   #ibtmp1:12M:autoextend
innodb_log_group_home_dir    =./            #  ./
innodb_log_files_in_group    =2            #  2
innodb_log_file_size      =48M            #  50331648(48M)
innodb_file_format      =Barracuda          #  Barracuda
innodb_file_per_table      =on             #  on
innodb_page_size      =16k            #  16384(16k)
innodb_thread_concurrency    =0            #  0
innodb_read_io_threads      =4            #  4
innodb_write_io_threads      =4            #  4
innodb_purge_threads      =4            #  4
innodb_print_all_deadlocks    =on            #  off
innodb_deadlock_detect      =on            #  on
innodb_lock_wait_timeout    =3600            #  50
innodb_spin_wait_delay      =6            #  6
innodb_autoinc_lock_mode    =2            #  1
innodb_stats_persistent      =on            #  on
innodb_stats_persistent_sample_pages  =20            #  20
innodb_adaptive_hash_index    =on            #  on
innodb_change_buffering      =all            #  all
innodb_change_buffer_max_size    =25            #  25
innodb_flush_neighbors      =1            #  1
innodb_flush_method      =O_DIRECT          # 
innodb_doublewrite      =on            #  on
innodb_log_buffer_size      =16M            #  16777216(16M)
innodb_max_undo_log_size = 4G
innodb_flush_log_at_timeout    =1            #  1
innodb_flush_log_at_trx_commit    =1            #  1
autocommit=1            #  1
innodb_flush_log_at_trx_commit = 1
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
############
innodb_buffer_pool_size=8096M
innodb_buffer_pool_instances=8
#innodb_additional_mem_pool_size=20M
join_buffer_size=128M
sort_buffer_size=32M

[client]
user=proxysql
password=proxysql