[client]
port = 3306
socket = /var/db/mysql/mysql.sock

[mysqld]
read-only = off
ignore-db-dir = backups
log-error = /var/log/mysqld.log
character-set-server = utf8

datadir = /var/db/mysql
socket = /var/db/mysql/mysql.sock
max_connections = 512
port = 3306
skip-external-locking
skip-name-resolve

key_buffer_size = 16M
max_allowed_packet = 256M

table_open_cache = 16384
net_buffer_length = 512K

sort_buffer_size = 232K
read_buffer_size = 8M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 16M

thread_cache_size = 256

# deprecated soon, after 5.7.20
query_cache_type = on
query_cache_size = 128K

max_heap_table_size = 1024M
tmp_table_size = 1024M

innodb_file_per_table = on
innodb_buffer_pool_size = 10G
innodb_flush_log_at_trx_commit = 1

# deprecated in 5.7
#innodb_additional_mem_pool_size = 512M

innodb_log_buffer_size = 256M
innodb_thread_concurrency = 32

relay-log=janus-relay-bin
replicate-ignore-db = mysql
replicate-ignore-db = information_schema
replicate-ignore-db = test
replicate-ignore-db = performance_schema

#read-only = on
server-id = 3
binlog_format = row
log-bin = mysql-bin
log_slave_updates = on
expire_logs_days = 5

slow_query_log = on
slow_query_log_file = '/var/log/mysq-slow.log'
long_query_time = 10

# sql mode - backward compatibility
sql_mode = 'STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION'

# lowered securoty for password policy settings - backward compatibility
validate_password_special_char_count = 0
validate_password_number_count = 0
validate_password_mixed_case_count = 0

[mysqldump]
quick
max_allowed_packet = 128M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

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

[mysqlhotcopy]
interactive-timeout