PmaControl logo PmaControl
PmaControl › Topologie Dot3

Topologie Dot3

Overview

Dot3 is the PmaControl mapping engine. It automatically generates an interactive SVG map of your entire MariaDB / MySQL infrastructure via Graphviz.

  • Standalone, master/slave, Galera, InnoDB Cluster servers
  • Proxies: ProxySQL, MaxScale, HAProxy
  • VIP servers with failover history
  • Galera arbitrator (garb) as virtual node
  • Configurable semantic coloring

Execution

# Génération via CLI
php /srv/www/pmacontrol/glial dot3 run

# Reconstruction historique à une date donnée
php /srv/www/pmacontrol/glial dot3 run "2026-01-15 14:30:00"

Dot3 can also be run via the web interface. The topology is cached (MD5 in dot3_information) and regenerated only if the infrastructure has changed.

Groups and subgraphs

Dot3 organizes servers into Graphviz groups:

  • Galera Cluster — Subgraph per cluster, with wsrep segments
  • Master/Slave — Replication links with status (OK, delay, stopped, error)
  • ProxySQL — Hostgroups with status (online, shunned, offline)
  • MaxScale — Services and backends
  • InnoDB Cluster — Primary/Replica with group_replication_*
  • VIP — Current destination (solid line) and previous (dotted)

Legend and colors

Colors are configurable in the dot3_legend table. Color code types:

  • NODE_* — Server status (OK, KO, UNKNOWN)
  • GALERA_* — Galera status (SYNCED, DONOR, DESYNCED, JOINER, DISCONNECTED)
  • SEGMENT_* — wsrep segments (OK, KO, PARTIAL)
  • REPLICATION_* — Replication (OK, DELAY, STOPPED, ERROR_SQL, ERROR_IO, BUG, BLACKOUT)
  • PROXYSQL_* — ProxySQL (ONLINE, SHUNNED, OFFLINE_SOFT, OFFLINE_HARD, MIRRORING)
  • MAXSCALE_* — MaxScale (RUNNING, DOWN, UNSYNC)