-------------------  5.6.39 /etc/mysql/my.cnf  ----------------------
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0


[mysqld]
group-concat-max-len=102400
slave-skip-errors = all

net_write_timeout = 500

slow-query-log = 1
long_query_time = 111

# CACHE
query_cache_type = 1
query_cache_limit       = 1M
query_cache_size        = 100M

sync_binlog = 1
bind-address            = 10.1.1.1

server-id               = 11111

#auto-increment-increment=32
#auto-increment-offset=17
auto-increment-increment=16
auto-increment-offset=16

log-bin=mysql-bin
log-bin-index=mysql-bin.index
gtid-mode=ON
log-slave-updates
enforce-gtid-consistency


expire_logs_days        = 2
max_binlog_size         = 500M

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir         = /tmp
language	= /usr/share/mysql/english
skip-external-locking
innodb_flush_log_at_trx_commit=1

skip-name-resolve
back_log	= 200
log-error       = /var/log/mysql/error.log
explicit_defaults_for_timestamp = 1

binlog-format=mixed

max_connect_errors      = 3600
key_buffer_size		= 128M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
max_connections        = 200

read_buffer_size	= 1M
innodb_buffer_pool_size = 55G
innodb_log_file_size    = 16M

[mysqldump]
quick
quote-names
max_allowed_packet	= 16M


[isamchk]
key_buffer_size		= 16M

!includedir /etc/mysql/conf.d/

----------------------------------------------------------------------------------------


-------------------  5.7.36 /etc/mysql/my.cnf  ----------------------

#
# Ansible managed
#

[mysql_safe]
pid_file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld]
group-concat-max-len=102400
slave-skip-errors = all
skip-name-resolve = 1
server-id = 101
gtid-mode = ON
skip-external-locking = 1
max_binlog_size = 100M
port = 3306
tmpdir = /var/tmp
max_connect_errors = 3600
#myisam-recover = BACKUP
innodb_buffer_pool_size = 55G
innodb_flush_method = O_DIRECT
basedir = /usr
max_allowed_packet = 16M
datadir = /var/lib/mysql
enforce-gtid-consistency = 1
max_connections = 1500
table_open_cache = 5000
query_cache_type = 1
slow-query-log = 1
back_log = 200
explicit_defaults_for_timestamp = 1
innodb_log_file_size = 16M
sql_mode = NO_ENGINE_SUBSTITUTION
thread_stack = 192K
query_cache_limit = 1M
read_buffer_size = 1M
binlog-format = row
user = mysql
replicate-do-db = xxxxxx
pid-file = /var/run/mysqld/mysqld.pid
thread_cache_size = 8
innodb_flush_log_at_trx_commit = 1
log-bin-index = mysql-bin.index
query_cache_size = 64M
binlog-do-db = xxxxx
socket = /var/run/mysqld/mysqld.sock
slow-query-log-file = /var/log/mysql/mysqld-slow.log
log-error = /var/log/mysql/error.log
log-slave-updates = 1
expire_logs_days = 2
binlog-ignore-db = mysql
long_query_time = 111
key_buffer_size = 128M
log-bin = mysql-bin

[mysqldump]
quick = 1
quote-names = 1
max_allowed_packet = 64M


# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d 

----------------------------------------------------------------------------------------