### MANAGED BY PUPPET ###

[client]
port = 3306
socket = /home/mysql/data/mysqld.sock

[isamchk]
key_buffer_size = 16M

[mysql]
default-character-set = utf8mb4
no_auto_rehash

[mysql_install_db]
auth-root-authentication-method = socket

[mysqld]
back_log = 1024
basedir = /usr
bind-address = 10.16.10.103
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
datadir = /home/mysql/data
delay_key_write = OFF
event_scheduler = ON
explicit_defaults_for_timestamp = ON
innodb_buffer_pool_instances = 6
innodb_buffer_pool_size = 6G
innodb_doublewrite = 0
innodb_file_per_table
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_flush_neighbors = 0
innodb_log_buffer_size = 128M
innodb_log_file_size = 768M
innodb_log_group_home_dir = /home/mysql/log
innodb_numa_interleave = 1
innodb_purge_threads = 1
innodb_strict_mode = OFF
innodb_thread_concurrency = 12
innodb_thread_sleep_delay = 0
interactive_timeout = 600
join_buffer_size = 8M
key_buffer_size = 1024M
log-error = /var/log/mysql/error.log
loose-cgroup-plugin-base-group = mysql-users
loose-cgroup-plugin-controllers = cpu
max_allowed_packet = 32M
max_binlog_size = 100M
max_connect_errors = 10000
max_connections = 4096
max_delayed_threads = 0
max_heap_table_size = 256M
max_user_connections = 272
memlock
myisam-recover-options = OFF
myisam_sort_buffer_size = 64M
myisam_use_mmap
open_files_limit = 159754
performance_schema = OFF
pid-file = /var/run/mysqld/mysqld.pid
plugin-load = cgroup_plugin=cgroup_plugin.so
port = 3306
read_buffer_size = 8M
read_rnd_buffer_size = 8M
server_id = 40
skip-external-locking
skip_character_set_client_handshake = ON
skip_name_resolve = ON
slow_query_log = ON
socket = /home/mysql/data/mysqld.sock
sort_buffer_size = 128M
sql_mode = "NO_ENGINE_SUBSTITUTION"
ssl = false
ssl-ca = /etc/mysql/cacert.pem
ssl-cert = /etc/mysql/server-cert.pem
ssl-key = /etc/mysql/server-key.pem
table_definition_cache = 39312
table_open_cache = 77824
table_open_cache_instances = 12
thread_cache_size = 256
thread_stack = 256K
tmp_table_size = 256M
tmpdir = /home/mysql_tmpdir
user = mysql
wait_timeout = 600

[mysqld-5.0]
myisam-recover = BACKUP

[mysqld-5.1]
myisam-recover = BACKUP

[mysqld-5.5]
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M

[mysqld-5.6]
expire_logs_days = 10
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
max_tmp_tables = 16
myisam-recover-options = OFF
query_cache_limit = 16M
query_cache_min_res_unit = 8K
query_cache_size = 128M
query_cache_type = 1

[mysqld-5.7]
expire_logs_days = 10
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
log_timestamps = SYSTEM
max_tmp_tables = 16
myisam-recover-options = OFF
query_cache_limit = 16M
query_cache_min_res_unit = 8K
query_cache_size = 128M
query_cache_type = 1

[mysqld-8.0]
default-authentication-plugin = mysql_native_password
disable_log_bin
log_timestamps = SYSTEM
myisam-recover-options = OFF
mysqlx = 0
skip_ssl

[mysqld_safe]
log-error = /var/log/mysql/error.log
nice = 0
socket = /home/mysql/data/mysqld.sock

[mysqldump]
max_allowed_packet = 32M
quick
quote-names



!includedir /etc/mysql/conf.d