I have set from ProxySQL admin interface:
SET admin-restapi_enabled='true';
SET admin-restapi_port=6070;
LOAD ADMIN VARIABLES TO RUNTIME;
SAVE ADMIN VARIABLES TO DISK;
and append prometheus.yml to add ProxySQL instance:
- job_name: 'proxysql'
scrape_interval: 5s
static_configs:
- targets: ['10.0.0.1:6070']
and then import the JSON:
ProxySQL-Fleet-Overview.json and ProxySQL-Host-Statistics.json
But I received errors saying:
"Failed to upgrade legacy queries Datasource Prometheus was not found"
The dashboard is not showing any data at all.
Please note I am not using docker.