Please look at the screenshots in my post before. Grafana says 1,1,3 but it’s 1,1,1.
Here is what you wanted:
+--------------+----------+------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | xtradb1 | 3306 | ONLINE | 1000 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | xtradb2 | 3306 | ONLINE | 1000 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | xtradb3 | 3306 | ONLINE | 1000 | 0 | 1000 | 0 | 0 | 0 | |
| 20 | xtradb3 | 3306 | OFFLINE_SOFT | 1000 | 0 | 1000 | 0 | 0 | 0 | |
| 20 | xtradb2 | 3306 | OFFLINE_SOFT | 1000 | 0 | 1000 | 0 | 0 | 0 | |
| 20 | xtradb1 | 3306 | ONLINE | 1000 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+----------+------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
# HELP proxysql_connection_pool_status Connection pool usage statistic.
# TYPE proxysql_connection_pool_status gauge
proxysql_connection_pool_status{endpoint="xtradb1:3306",hostgroup="10"} 1
proxysql_connection_pool_status{endpoint="xtradb1:3306",hostgroup="20"} 1
proxysql_connection_pool_status{endpoint="xtradb2:3306",hostgroup="10"} 3
proxysql_connection_pool_status{endpoint="xtradb2:3306",hostgroup="20"} 3
proxysql_connection_pool_status{endpoint="xtradb3:3306",hostgroup="10"} 1
proxysql_connection_pool_status{endpoint="xtradb3:3306",hostgroup="20"} 3
As you can see the outputs don’t match.