
mysql-monitor_galera_healthcheck_max_timeout_count max_transactions_behind column in the admin interface, on a per-hostgroup level (introduced in ProxySQL v2.0).

Nodes can be temporarily shunned if their status is not available which is controlled by the mysql_galera_hostgroups.

The interval at which the proxy should connect to the backend servers in order to monitor the Galera status of a node. mysql-monitor_galera_healthcheck_interval This lazy rounding is done because SSL connections are blocking calls. The current implementation rounds this value to an integer number of seconds less or equal to the original interval, with 1 second as minimum. System VariableĬonnection timeout in milliseconds. The interval at which the Monitor module of the proxy will try to connect to all the MySQL servers in order to check whether they are available or not. Mysql-monitor_replication_lag_use_percona_heartbeat Mysql-monitor_groupreplication_max_transactions_behind_for_read_only Mysql-monitor_groupreplication_max_transactions_behind_count Mysql-monitor_groupreplication_healthcheck_timeout Mysql-monitor_groupreplication_healthcheck_max_timeout_count Mysql-monitor_groupreplication_healthcheck_interval Mysql-monitor_galera_healthcheck_max_timeout_count Mysql-monitor_galera_healthcheck_interval

NOTE: You can click on the variable name to jump to its definition Variable name MySQL Monitor Variables List of MySQL Monitor Variables
