vitess.io/vitess@v0.16.2/examples/compose/external_db/mysql/mysql56.cnf (about)

     1  [mysqld]
     2  # Options for enabling GTID
     3  # https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-howto.html
     4  gtid_mode = ON
     5  log_bin
     6  log_slave_updates
     7  enforce_gtid_consistency
     8  
     9  # Crash-safe replication settings.
    10  master_info_repository = TABLE
    11  relay_log_info_repository = TABLE
    12  relay_log_purge = 1
    13  relay_log_recovery = 1
    14  
    15  # Native AIO tends to run into aio-max-nr limit during test startup.
    16  innodb_use_native_aio = 0
    17  
    18  # Semi-sync replication is required for automated unplanned failover
    19  # (when the master goes away). Here we just load the plugin so it's
    20  # available if desired, but it's disabled at startup.
    21  #
    22  # VTTablet will enable semi-sync at the proper time when replication is set up,
    23  # or when a primary is promoted or demoted based on the durability policy configured.
    24  plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
    25  
    26  # When semi-sync is enabled, don't allow fallback to async
    27  # if you get no ack, or have no slaves. This is necessary to
    28  # prevent alternate futures when doing a failover in response to
    29  # a master that becomes unresponsive.
    30  rpl_semi_sync_master_timeout = 1000000000000000000
    31  rpl_semi_sync_master_wait_no_slave = 1
    32  server-id = 1
    33  # Remove ONLY_FULL_GROUP_BY until queries are fixed
    34  sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    35  
    36  general_log = 1
    37  general_log_file = /var/log/mysql/query.log
    38  
    39  slow_query_log = 1
    40  long_query_time = 1 # seconds
    41  slow_query_log_file = /var/log/mysql/slow.log