You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The mysql backend monitoring relies on sharing the same global variables for setting up hostgroup monitoring. This has the immediate effect that all backends must share the same monitoring user (monitor_username and monitor_password) , thus if this credentials don't exist in the mysql server, the heartbeats/ping will fails and potentially already working connections from other valid mysql_users will be killed by the hostgroup manager.
Incidentally, I am experiencing this issue when sharing the same config between unix socket connections that are authenticated using username:password credentials and IAM authenticated connections to mysql. Although an immediate workaround is to have two proxysql services running with different configs, it would make more sense for my set up to have all the hostgroups configured using the same instance.
The text was updated successfully, but these errors were encountered:
The mysql backend monitoring relies on sharing the same global variables for setting up hostgroup monitoring. This has the immediate effect that all backends must share the same monitoring user (
monitor_username
andmonitor_password
) , thus if this credentials don't exist in the mysql server, the heartbeats/ping will fails and potentially already working connections from other validmysql_users
will be killed by the hostgroup manager.Incidentally, I am experiencing this issue when sharing the same config between unix socket connections that are authenticated using username:password credentials and IAM authenticated connections to mysql. Although an immediate workaround is to have two proxysql services running with different configs, it would make more sense for my set up to have all the hostgroups configured using the same instance.
The text was updated successfully, but these errors were encountered: