[mysqld]
bind-address            = 0.0.0.0

# replikace
server-id               = 2

datadir                 = /var/lib/mysql/

#auto_increment_increment      = 2
#auto_increment_offset         = 1

log_bin                 = /var/log/mysql/mysql-bin.log
log-slave-updates = 1
disable-gtid-unsafe-statements = 1
expire_logs_days        = 2
max_binlog_size         = 100M
gtid-mode = ON
binlog-format = row
master_info_repository = TABLE
relay_log_info_repository = TABLE
#master_verify_checksum = ON
sync_binlog = 1
# slave multithreaded replication
slave_parallel_workers = 8
skip_slave_start

character-set-server    = utf8
collation-server        = utf8_czech_ci
innodb_file_per_table
default-storage-engine  = InnoDB

key_buffer              = 300M
max_allowed_packet      = 16M
thread_stack            = 256K
thread_cache_size       = 512 
max_connections         = 350

table_open_cache             = 5000
tmp_table_size          = 256M
max_heap_table_size     = 256M

sort_buffer_size        = 8M
join_buffer_size        = 16M
read_buffer_size        = 128K
net_buffer_length       = 1M
myisam_sort_buffer_size = 8M

query_cache_limit       = 15M
query_cache_size        = 256M
query_cache_type        = 1

innodb_thread_concurrency       = 32
innodb_flush_log_at_trx_commit  = 2
innodb_log_buffer_size          = 8M
innodb_log_file_size            = 128M
innodb_lock_wait_timeout        = 90
innodb_support_xa               = 0
innodb_flush_method             = O_DIRECT
innodb_max_dirty_pages_pct      = 80
innodb_io_capacity              = 200
innodb_adaptive_flushing        = true
innodb_buffer_pool_instances    = 1
innodb_read_io_threads          = 4
innodb_write_io_threads         = 4
innodb_buffer_pool_size		= 2G

slow-query-log-file     = /var/log/mysql/mysql-slow.log
slow-query-log          = 1
long_query_time=3
log-queries-not-using-indexes

#ft_min_word_len=2
#ft_stopword_file=/etc/mysql/czech-stopwords.txt

net_read_timeout        = 60