Is possible to set graceful close of connections to backend in case max_replication_lag threshold is reached?
22 views
Skip to first unread message
Domantas Spečiūnas
Apr 10, 2024, 7:26:36 AM4/10/24
to proxysql
We use proxysql for long running reports and it is an issue if we have short max_replication_lag, cause report can take hours to generate and max_replication_lag should not be bigger then few minutes.
max_replication_lag can be set big(hours), but in that case new application connections also "think" that this mysql backend "is good enough" even if it lags few hours.
Currently it can be solved with some external script, but it looks quite simple solution to change overall max_replication_lag threshold action from SHUNNED to OFFLINE_SOFT.
I saw https://github.com/sysown/proxysql/pull/3533, maybe there some way with current options I missing something?
max_replication_lag can be set big(hours), but in that case new application connections also "think" that this mysql backend "is good enough" even if it lags few hours.
Currently it can be solved with some external script, but it looks quite simple solution to change overall max_replication_lag threshold action from SHUNNED to OFFLINE_SOFT.
I saw https://github.com/sysown/proxysql/pull/3533, maybe there some way with current options I missing something?
Reply all
Reply to author
Forward
0 new messages