[mysqld]
basedir				= /u01/app/mnotintt1/usr
datadir				= /u01/mydata/mnotintt1
plugin_dir			= /u01/app/mnotintt1/usr/lib64/mysql/plugin
tmpdir				= /u01/mydata/mytmp
bind-address			= 10.123.119.151
port				= 19001
user				= mnotint
socket				= /u01/mydata/mnotintt1/mysql.sock
pid-file			= /u01/mydata/mnotintt1/mysqld.pid
log-error			= /u01/mydata/mnotintt1/mysqld.err
slow_query_log_file		= /u01/mydata/mnotintt1/mysqld-slow.log
general_log_file		= /u01/mydata/mnotintt1/mysqld.log
plugin-load				= rpl_semi_sync_source=semisync_source.so;rpl_semi_sync_replica=semisync_replica.so;auth_socket=auth_socket.so;audit_log=audit_log.so
autocommit			= 0
skip-external-locking
key_buffer_size			= 256M
max_allowed_packet		= 1M
table_open_cache		= 256
sort_buffer_size		= 1M
read_buffer_size		= 1M
read_rnd_buffer_size		= 4M
myisam_sort_buffer_size		= 64M
thread_cache_size		= 8
#transaction-isolation           = REPEATABLE-READ
transaction-isolation           = READ-COMMITTED
sql_mode			= no_engine_substitution
character-set-server		= utf8mb4
#character-set-client-handshake	= false
#general-log			= 1
table_open_cache_instances	= 2
explicit_defaults_for_timestamp	= true
lower_case_table_names		= 1
#skip-slave-start = 1
server-id			= 1
log-bin				= /u01/myarch/mnotintt1/mysql-bin
binlog_format			= mixed
max_binlog_size			= 104857600
#binlog-do-db			= mnotdb1
#binlog-do-db			= healthcheckdb
replicate_wild_ignore_table		= mysql.%
replicate_wild_ignore_table		= information_schema.%
replicate_wild_ignore_table		= performance_schema.%
replicate-ignore-table		= healthcheckdb.write_test
relay_log_space_limit		= 1073741824

auto_increment_increment	= 2
auto_increment_offset		= 1
rpl_semi_sync_source_timeout = 1000
rpl_semi_sync_source_enabled=ON
rpl_semi_sync_replica_enabled=ON

default-storage-engine		= innodb
innodb_data_home_dir		= /u01/mydata/mnotintt1
innodb_data_file_path		= systemts1:1G:autoextend:max:5G
#innodb_buffer_pool_size		= 4G
#innodb_buffer_pool_size		= 12G
innodb_buffer_pool_size		= 4G
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size		= 32M
innodb_log_group_home_dir	= /u01/mydata/mnotintt1
#innodb_log_file_size		= 50M
#innodb_log_files_in_group	= 5
#innodb_log_file_size		= 2047M
innodb_file_per_table		= 1
innodb_lock_wait_timeout        = 5
innodb_print_all_deadlocks	= 1
innodb_undo_directory		= /u01/mydata/mnotintt1/undotbs
read_only					= true


#added on 5.7.12
relay_log			= mysqld-relay-bin
secure_file_priv		= /u01/mydata/mytmp
innodb_open_files		= 450
innodb_sort_buffer_size		= 52428800
max_user_connections   		= 200
innodb_status_output_locks 	= on
log_timestamps                  = SYSTEM

#revised on 5.7.12
optimizer_switch				= derived_merge=off
innodb_temp_data_file_path				= ibtmp1:512M:autoextend:max:3G
max_heap_table_size				= 67108864
tmp_table_size				= 67108864
max_connections				= 600
innodb_rollback_segments				= 128
innodb_redo_log_capacity				= 8192M
innodb_autoinc_lock_mode				= 2
binlog_expire_logs_seconds				= 259200
tls_version				= TLSv1.2,TLSv1.3
replica_net_timeout				= 3600
authentication_policy				= mysql_native_password,*,
mysqlx				= OFF
audit_log_policy				= LOGINS
audit_log_file				= /var/log/mysql/audit/mnotintt1/mnotintt1-audit.log
audit_log_format				= CSV
audit_log_rotate_on_size				= 1024M
audit_log_rotations				= 5
local_infile				= ON
event_scheduler				= OFF
log_error_verbosity				= 3
innodb_flush_neighbors				= 1
log_replica_updates				= OFF
transaction_write_set_extraction				= OFF
slave_rows_search_algorithms				= INDEX_SCAN,TABLE_SCAN
collation_server				= utf8mb4_general_ci
init_connect				= 'set names utf8mb4 collate utf8mb4_general_ci'
master-info-repository				= FILE
relay-log-info-repository				= FILE
character_set_filesystem				= binary

[client]
port				= 19001
socket				= /u01/mydata/mnotintt1/mysql.sock
default-character-set		= utf8mb4

[mysqldump]
quick
max_allowed_packet		= 16M
default-character-set				= utf8mb4

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size			= 128M
sort_buffer_size		= 128M
read_buffer			= 2M
write_buffer			= 2M

[mysqlhotcopy]
interactive-timeout