# The following options will be passed to all MySQL clients [client] port = 3306 socket = /data/failovertest/mysql.sock # The MySQL server [mysqld] tmpdir = /data/failovertest/tmp performance_schema innodb_flush_method=O_DIRECT port = 3306 socket = /data/failovertest/mysql.sock datadir =/data/failovertest/failovertest log-error=/data/failovertest/failovertest/mysqld_error.log slow_query_log =ON connect_timeout=60 max_connections=600 #Set max_allowed_packet to the max allowed value max_allowed_packet = 1073741824 sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES,STRICT_TRANS_TABLES' skip_name_resolve = ON log-bin=/data/binlog_failovertest/failovertest/mysql-bin binlog_format=mixed sync_binlog = 1 server-id = 6218 expire_logs_days=3 #skip-networking read_only=ON ########################## # REPLICATION PARAMETERS # ########################## relay_log=/data/binlog_failovertest/relaylog/relay-log-bin relay_log_space_limit=1073741824 max_relay_log_size=134217728 skip-slave-start = TRUE log-slave-updates = TRUE master-info-repository = TABLE ## GTID settings enforce-gtid-consistency gtid-mode = ON ################################## # CROSS ENGINE MEMORY PARAMETERS # ################################## query_cache_type = 0 query_cache_size = 0 table_open_cache = 512 sort_buffer_size = 2M thread_cache_size = 8 ############################### # MyISAM ESPECIFIC PARAMETERS # ############################### #Disable file system locks to handle concurrency over MyISAM tables skip-external-locking #Cache for MyISAM Index blocks key_buffer_size = 384M #Each thread that does a sequential scan for a MyISAM table allocates a buffer of this size (in bytes) for each table it scans read_buffer_size = 2M # By thread - When reading rows from a MyISAM table in sorted order following a key-sorting operation, the rows are read through this buffer to avoid disk seeks read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M ############################### # InnoDB ESPECIFIC PARAMETERS # ############################### autocommit=on transaction-isolation = READ-COMMITTED innodb_data_home_dir = /data/failovertest/failovertest innodb_data_file_path = ibdata1:12M;ibdata2:100M:autoextend innodb_log_group_home_dir = /data/failovertest/failovertest innodb_file_per_table innodb_buffer_pool_size = 4G #innodb_buffer_pool_instances=3 #innodb_additional_mem_pool_size = 20M innodb_log_file_size = 500M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_buffer_pool_dump_at_shutdown=ON innodb_buffer_pool_load_at_startup=ON [mysql] #no-auto-rehash [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout