I have a MySQL Cluster setup using the Galera library, I provide access to the cluster through a ProxySQL server. (ProxySQL handles checking MySQL node health etc and sends queries to healthy nodes)
I am trying to configure Grafana to talk to ProxySQL for its database and it just refuses to work. If I point Grafana directly to one of the MySQL cluster members, it works fine. When I point it to the proxySQL server Grafana does not seem to finish starting, the log stops after:
t=2017-11-17T21:34:52+0000 lvl=info msg=“Initializing DB” logger=sqlstore dbtype=mysql
t=2017-11-17T21:34:52+0000 lvl=info msg=“Starting DB migration” logger=migrator
I tested the creds through ProxySQL with the MySQL client using the username/password/DB in the grafana config, works fine, I can select rows etc. I have numerous other applications using this DB cluster through ProxySQL.
I have the log level in Grafana set to trace, is there anything else I can do to see more information on what is going on behind the scenes?
The MySQL config in Grafana:
type = mysql
host = 10.10.10.52:3306
name = grafana_db
user = grafana
password = password
Any help appreciated, thanks!
Jon