[server] sql_mode = "" [mysqld] report_host = db23321k1 report_port = 23321 bind_address = 0.0.0.0 socket = /var/run/mysqld/mysqld_23321.sock datadir = /var/lib/mysql/port_23321/data default_storage_engine = InnoDB pid-file = /var/lib/mysql/port_23321/data/mysqld.pid log_error = mysqld_error.log # Error messages -> log_error_verbosity = 1 # Error and warning messages -> log_error_verbosity = 2 # Error, warning, and information messages -> log_error_verbosity = 3 log_error_verbosity = 2 log_slave_updates = ON log_syslog = ON log_syslog_include_pid = ON log_syslog_tag = mysql_23321 # relay_log_recovery=OFF, denn diese Option macht keinen Sinn mehr, seit es die GTID gibt. #relay_log_recovery = OFF relay_log = mysql-relay-bin relay_log_index = mysql-relay-bin.index relay_log_info_repository = TABLE relay_log_space_limit = 4G character_set_server = utf8 # 1M = 1048576 collation_server = utf8_unicode_ci expire_logs_days = 3 explicit_defaults_for_timestamp = ON interactive_timeout = 28800 master_info_repository = TABLE master_verify_checksum = ON max_allowed_packet = 64M max_binlog_size = 100M max_connect_errors = 1000 max_connections = 1000 max_relay_log_size = 100M net_read_timeout = 90 net_write_timeout = 90 port = 23321 query_cache_limit = 0 query_cache_min_res_unit = 0 query_cache_size = 0 query_cache_type = OFF skip_external_locking = ON skip_name_resolve = ON sync_binlog = 1 sync_master_info = 1 sync_relay_log_info = 1 ignore-db-dir = lost+found log-error = mysqld.log symbolic-links = 0 server-id = 1 log_bin = mysql-bin log_bin_index = mysql-bin.index #gtid_mode = ON #enforce_gtid_consistency = ON open_files_limit = 65000 connect_timeout = 90