|
I installed vanilla MariaDB 10.1.37, and enabled wsrep library.
When I checked default wsrep_provider_option setting, found some wrong points :
(1)
"evs.suspect_timeout" default value (PT5S) is different from reference manual :
https://mariadb.com/kb/en/library/wsrep_provider_options/#evssuspect_timeout
> Default: PT10S
(2)
The magnitude correlation among "evs.suspect_timeout" and "evs.inactive_timeout" and "evs.install_timeout = PT7.5S" is deffer from the codership manual recommendation :
http://galeracluster.com/documentation-webpages/configurationtips.html
recomended :
evs.suspect_timeout < evs.inactive_timeout (default : 15sec) ≦ evs.install_timeout (default : 15sec)
MariaDB default:
|
evs.suspect_timeout < evs.install_timeout (default : 7.5sec) < evs.inactive_timeout (default : 15sec)
|
MariaDB [(none)]> show global variables like "wsrep_provider_%"\G
|
*************************** 1. row ***************************
|
Variable_name: wsrep_provider_options
|
Value: ...(cut)... evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = P1D; ...(cut)...
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.1.37-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|
|