# Standard initial configuration for our servers
# Based off a config generated by Percona Configuration Wizard
# (http://tools.percona.com)

[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysql/mysql.sock

[mysqld]
user                            = mysql
event_scheduler                 = 0

# MyISAM
key_buffer_size                 = 32M

# SAFETY #
max_allowed_packet              = 1G
max_connect_errors              = 1000000
skip_name_resolve
sql_mode                        = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY
sysdate_is_now                  = 1
innodb_strict_mode              = 1

# DATA STORAGE #
datadir                         = /var/lib/mysql
tmpdir                          = /media/raid0/tmp

# BINARY LOGGING #
log_bin                         = /media/binlog/mysql-bin
expire_logs_days                = 4
sync_binlog                     = 0
binlog_format                   = MIXED

# REPLICATION #
skip_slave_start               = 1
log_slave_updates              = 1
relay_log                      = /media/binlog/relay-bin
relay_log_recovery             = 1
slave_net_timeout              = 60
sync_master_info               = 0
sync_relay_log                 = 0
sync_relay_log_info            = 0
server_id                      = 95
master_info_repository         = table
relay_log_info_repository      = table
slave_exec_mode                = IDEMPOTENT
slave_parallel_workers         = 16
slave_compressed_protocol      = 1
slave_pending_jobs_size_max    = 1G

# CACHES AND LIMITS #
tmp_table_size                 = 32M
max_heap_table_size            = 32M
query_cache_type               = 0
query_cache_size               = 0
max_connections                = 2000
thread_cache_size              = 50
open_files_limit               = 65535
table_definition_cache         = 4096
table_open_cache               = 4096
table_open_cache_instances     = 4
max_prepared_stmt_count        = 1000000

# INNODB #
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size           = 16384M
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 25607M
innodb_doublewrite             = 0
innodb_write_io_threads        = 16
innodb_read_io_threads         = 16
innodb_file_format             = Barracuda

# LOGGING #
log-error=/var/lib/mysql/mysqld.log
log_queries_not_using_indexes  = 1
slow_query_log                 = 1
slow_query_log_file            = /var/lib/mysql/mysql-slow.log
log_warnings                   = 2

# TIMEOUTS #
wait_timeout                   = 60
interactive_timeout            = 60

[mysqld_safe]
log-error=/var/log/mysql/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid