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

     1  # This file is auto-included when MySQL 5.7 is detected.
     2  
     3  # MySQL 5.7 does not enable the binary log by default, and 
     4  # info repositories default to file
     5  [mysqld]
     6  gtid_mode = ON
     7  log_slave_updates
     8  enforce_gtid_consistency
     9  expire_logs_days = 3
    10  master_info_repository = TABLE
    11  relay_log_info_repository = TABLE
    12  relay_log_purge = 1
    13  relay_log_recovery = 1
    14  
    15  # In MySQL 5.7 the default charset is latin1
    16  
    17  character_set_server = utf8
    18  collation_server = utf8_general_ci
    19  
    20  # Semi-sync replication is required for automated unplanned failover
    21  # (when the master goes away). Here we just load the plugin so it's
    22  # available if desired, but it's disabled at startup.
    23  #
    24  # VTTablet will enable semi-sync at the proper time when replication is set up,
    25  # or when a primary is promoted or demoted based on the durability policy configured.
    26  plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
    27  
    28  # When semi-sync is enabled, don't allow fallback to async
    29  # if you get no ack, or have no slaves. This is necessary to
    30  # prevent alternate futures when doing a failover in response to
    31  # a master that becomes unresponsive.
    32  rpl_semi_sync_master_timeout = 1000000000000000000
    33  rpl_semi_sync_master_wait_no_slave = 1
    34  
    35  ## Specific edits for this external_db ##
    36  log_bin
    37  server-id = 1
    38  general_log = 1
    39  general_log_file = /var/log/mysql/query.log
    40  
    41  slow_query_log = 1
    42  long_query_time = 1 # seconds
    43  slow_query_log_file = /var/log/mysql/slow.log