mysql复制参数,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

本文由【waitig】发表在等英博客 本文固定链接：mysql组复制配置文件参数 欢迎关注本站官方公众号，每日都有干货分享！

点赞 (0)赏分享 (0)