ProxySQL

Monitoring

PmaControl connects to the ProxySQL admin interface (port 6032) to collect:

• Hostgroup configuration and routing rules
• Connection and query statistics
• Backend status (ONLINE, SHUNNED, OFFLINE_SOFT, OFFLINE_HARD)
• Mirroring configuration

Configuration import

PmaControl can import ProxySQL configuration from the internal SQLite file. Features:

• Automatic import of hostgroups and backends
• Association with already monitored MariaDB / MySQL servers
• Auto-configuration based on detected topology
• Admin connection test before import

Dot3 topology

ProxySQL is displayed in Dot3 with:

• Links to each backend with hostgroup status
• ProxySQL cluster (peer-to-peer) with bidirectional double arrow
• Color codes: ONLINE (green), SHUNNED (orange), OFFLINE_SOFT (gray), OFFLINE_HARD (red), MIRRORING (purple)