mysql8.0的my.cnf_my.cnf_8.0

[client]

port = 3307

socket = /home/mysql/mysqldb/run/mysql.sock

default-character-set = utf8mb4

#prompt = \\u@\\h:\\d \\r:\\m:\\s >

no-auto-rehash

[mysql]

port = 3307

socket = /home/mysql/mysqldb/run/mysql.sock

default-character-set = utf8mb4

prompt = \\u@\\h:\\d \\r:\\m:\\s >

no-auto-rehash

[mysqld]

server-id = 207

port = 3307

default_storage_engine = InnoDB

character_set_server = utf8mb4

binlog_format = ROW

transaction_isolation = READ-COMMITTED

max-allowed-packet = 512M

max-connections = 1000

max-connect-errors = 1000000

datadir = /home/mysql/mysqldb/data

log_bin = /home/mysql/mysqldb/binlogs/mysql-bin

socket = /home/mysql/mysqldb/run/mysql.sock

pid-file = /home/mysql/mysqldb/run/mysql.pid

log_error = /home/mysql/mysqldb/logs/error.log

slow_query_log_file = /home/mysql/mysqldb/logs/slow.log

tmpdir = /home/mysql/mysqldb/tmp

innodb_buffer_pool_size = 20G

innodb_log_file_size = 1G

innodb_log_files_in_group = 5

innodb_data_file_path = ibdata1:500M;ibdata2:500M:autoextend

innodb_temp_data_file_path = ibtmp1:500M;ibtmp2:500M:autoextend:max:5120M

innodb_flush_method = O_DIRECT

default-time-zone = '+8:00'

gtid_mode = ON

enforce_gtid_consistency = ON

binlog_checksum = NONE

log_slave_updates = 1

relay_log_info_repository = TABLE

master_info_repository = TABLE

binlog_expire_logs_seconds = 2592000

# 默认使用mysql_native_password 插件认证

default_authentication_plugin = mysql_native_password

slow-query-log = 1

long_query_time = 1

#read-only = 1

#

#plugin_load_add = 'group_replication.so'

#group_replication_group_name = 'ec9566ae-5bb7-11ea-b099-cb85388b10ae'

#group_replication_start_on_boot = off

#group_replication_local_address = "dbcluster207:33071"

#group_replication_group_seeds =