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

     1  # This file is auto-included when MariaDB 10 is detected.
     2  
     3  # Semi-sync replication is required for automated unplanned failover
     4  # (when the primary goes away). Here we just load the plugin so it's
     5  # available if desired, but it's disabled at startup.
     6  #
     7  # VTTablet will enable semi-sync at the proper time when replication is set up,
     8  # or when a primary is promoted or demoted based on the durability policy configured.
     9  plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
    10  
    11  # MariaDB 10 is unstrict by default in some versions.
    12  sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
    13  
    14  # Enable strict mode so it's safe to compare sequence numbers across different server IDs.
    15  gtid_strict_mode = 1
    16  innodb_stats_persistent = 0
    17  
    18  # When semi-sync is enabled, don't allow fallback to async
    19  # if you get no ack, or have no replicas. This is necessary to
    20  # prevent alternate futures when doing a failover in response to
    21  # a primary that becomes unresponsive.
    22  rpl_semi_sync_master_timeout = 1000000000000000000
    23  rpl_semi_sync_master_wait_no_slave = 1
    24  
    25  # MariaDB 10 does not have crash safe binlogs by default.
    26  sync_binlog = 1
    27  expire_logs_days = 3
    28  # MariaDB 10 uses MIXED mode by default which is not supported by VReplication.
    29  binlog_format = ROW
    30  # MariaDB 10 does not support full replica binary logs by default, which we
    31  # need for backups and restores.
    32  log_slave_updates
    33  
    34  # Some MariaDB 10 versions set this to 1 hour, which can cause hidden replication lag and
    35  # unexpected Vitess issue as the mariadbd instance thinks it's caught up when it is not.
    36  slave_net_timeout = 60
    37  
    38  # In MariaDB 10 the default charset is latin1.
    39  character_set_server = utf8
    40  collation_server = utf8_general_ci
    41