[mysqld] user = mysql server_id = 101 default_storage_engine = InnoDB socket = /var/lib/mysql/mysql.sock pid_file = /var/lib/mysql/mysql.pid bind-address = 0.0.0.0 lower_case_table_names = 1 net_read_timeout = 3600 net_write_timeout = 120 performance_schema = off datadir = /mydata/data tmpdir = /mydata/data log_bin = /mydata/data/mysql-bin binlog_format = row expire_logs_days = 2 sync_binlog = 1 max_binlog_cache_size = 68719476736 max_binlog_stmt_cache_size = 68719476736 open_files_limit = 1024 table_open_cache = 2048 innodb_log_file_size = 4G innodb_flush_log_at_trx_commit = 1 innodb_file_per_table = 1 innodb_buffer_pool_size = 25G innodb_flush_method = O_DIRECT transaction_isolation = REPEATABLE-READ innodb-defragment = 1 log_error = /var/log/mysql/mysql-error.log log_queries_not_using_indexes = 1 slow_query_log = 0 slow_query_log_file = /var/log/mysql/mysql-slow.log collation-server = utf8_unicode_ci character-set-server = utf8 init-connect ='SET NAMES utf8' sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES slave_parallel_mode = none slave-skip-errors = 1062 replicate_do_db=zoo3 replicate_ignore_table=zoo3.achtergrond replicate_do_db=gstandaard3 replicate_do_db=gstandaard2 replicate_do_db=gstandaard replicate_do_db=mysql replicate_do_db=agb