[mysqld]
skip_name_resolve
skip_external_locking

proxy_protocol_networks = 10.96.52.4,10.96.52.5,::1,localhost

character_set_server = utf8mb4
collation_server     = utf8mb4_unicode_ci
init_connect         = 'SET NAMES utf8mb4'

bind_address = 10.96.53.2
server_id    = 1

aria_log_dir_path   = /var/log/mysql

lower_case_table_names = 1

general_log     = 0
long_query_time = 2
slow_query_log  = 1
log_queries_not_using_indexes = 1
min_examined_row_limit        = 100

alter_algorithm = COPY
transaction_isolation = READ-COMMITTED

innodb_flush_method            = O_DIRECT
innodb_file_per_table          = 1
innodb_data_home_dir           = /var/lib/mysql
innodb_data_file_path          = ibdata1:10M:autoextend
innodb_log_group_home_dir      = /var/lib/mysql
innodb_buffer_pool_size        = 3G
innodb_buffer_pool_instances   = 3
innodb_log_file_size           = 1G
innodb_log_files_in_group      = 2
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout       = 30

performance_schema  = OFF
tmp_table_size      = 64M
max_heap_table_size = 64M
query_cache_size    = 0
thread_cache_size   = 256
wait_timeout        = 300
interactive_timeout = 300

table_open_cache            = 65535
table_open_cache_instances  = 8

table_definition_cache      = 33167

max_allowed_packet      = 64M
bulk_insert_buffer_size = 64M

max_connections = 256

log_bin             = /var/log/mysql/mysql-bin
log_bin_index       = /var/log/mysql/mariadb-bin.index
binlog_format       = row
expire_logs_days    = 7
#sync_binlog        = 1
max_binlog_size     = 1G

#relay_log           = /var/log/mysql/relay-bin
#relay_log_index     = /var/log/mysql/relay-bin.index
#relay_log_info_file = /var/log/mysql/relay-bin.info
#log_slave_updates
#read_only

key_buffer_size         = 128K
myisam_sort_buffer_size = 4M

ssl-ca   = /etc/mysql/ssl/root.rsa.crt
ssl-cert = /etc/mysql/ssl/server.rsa.crt
ssl-key  = /etc/mysql/ssl/server.rsa.key
tls_version = TLSv1.2,TLSv1.3

default_time_zone = +00:00
