зеркало из https://github.com/github/vitess-gh.git
42 строки
1.4 KiB
INI
42 строки
1.4 KiB
INI
# This file is auto-included when MariaDB 10.1 is detected.
|
|
|
|
# Semi-sync replication is required for automated unplanned failover
|
|
# (when the primary goes away). Here we just load the plugin so it's
|
|
# available if desired, but it's disabled at startup.
|
|
#
|
|
# VTTablet will enable semi-sync at the proper time when replication is set up,
|
|
# or when a primary is promoted or demoted based on the durability policy configured.
|
|
plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
|
|
|
|
slave_net_timeout = 60
|
|
|
|
# MariaDB 10.1 default is only no-engine-substitution and no-auto-create-user
|
|
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
|
|
|
|
# enable strict mode so it's safe to compare sequence numbers across different server IDs.
|
|
gtid_strict_mode = 1
|
|
innodb_stats_persistent = 0
|
|
|
|
# When semi-sync is enabled, don't allow fallback to async
|
|
# if you get no ack, or have no replicas. This is necessary to
|
|
# prevent alternate futures when doing a failover in response to
|
|
# a primary that becomes unresponsive.
|
|
rpl_semi_sync_master_timeout = 1000000000000000000
|
|
rpl_semi_sync_master_wait_no_slave = 1
|
|
|
|
|
|
character_set_server = utf8
|
|
collation_server = utf8_general_ci
|
|
|
|
expire_logs_days = 3
|
|
|
|
sync_binlog = 1
|
|
binlog_format = ROW
|
|
log_slave_updates
|
|
expire_logs_days = 3
|
|
|
|
# In MariaDB the default charset is latin1
|
|
|
|
character_set_server = utf8
|
|
collation_server = utf8_general_ci
|