vitess.io/vitess@v0.16.2/config/mycnf/mysql80.cnf (about)

     1  # This file is auto-included when MySQL 8.0 is detected.
     2  
     3  # MySQL 8.0 enables binlog by default with sync_binlog and TABLE info repositories
     4  # It does not enable GTIDs or enforced GTID consistency
     5  
     6  gtid_mode = ON
     7  enforce_gtid_consistency
     8  relay_log_recovery = 1
     9  binlog_expire_logs_seconds = 259200
    10  
    11  # disable mysqlx
    12  mysqlx = 0
    13  
    14  # 8.0 changes the default auth-plugin to caching_sha2_password
    15  default_authentication_plugin = mysql_native_password
    16  
    17  # Semi-sync replication is required for automated unplanned failover
    18  # (when the primary goes away). Here we just load the plugin so it's
    19  # available if desired, but it's disabled at startup.
    20  #
    21  # VTTablet will enable semi-sync at the proper time when replication is set up,
    22  # or when a primary is promoted or demoted based on the durability policy configured.
    23  plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
    24  
    25  # MySQL 8.0 will not load plugins during --initialize
    26  # which makes these options unknown. Prefixing with --loose
    27  # tells the server it's fine if they are not understood.
    28  loose_rpl_semi_sync_master_timeout = 1000000000000000000
    29  loose_rpl_semi_sync_master_wait_no_slave = 1
    30