Skip to main content

Main Runtime

Overview​

ProxySQL's Admin interface exposes configuration and runtime tables accessible via MySQL protocol. There are 62 configuration and runtime tables across MySQL, PostgreSQL, and system categories.

Configuration Layers​

Every configuration item exists in three layers:

LayerTable PrefixDescription
Memory(no prefix)In-memory working copy — edit here
Runtimeruntime_Active configuration used by worker threads
Diskdisk.Persisted to SQLite (proxysql.db)

Key Table Categories​

Server Management​

  • mysql_servers / pgsql_servers — Backend database servers organised into hostgroups
  • mysql_replication_hostgroups — Read/write split based on read_only
  • mysql_group_replication_hostgroups — Group Replication topology
  • mysql_galera_hostgroups — Galera Cluster topology
  • mysql_hostgroup_attributes / pgsql_hostgroup_attributes — Per-hostgroup settings

User Authentication​

  • mysql_users / pgsql_users — Frontend/backend credentials, default hostgroup, SSL requirements, connection limits

Query Routing​

  • mysql_query_rules / pgsql_query_rules — Pattern matching, rewriting, caching, routing, and load balancing
  • mysql_query_rules_fast_routing / pgsql_query_rules_fast_routing — Optimised routing by username, schema, and flags

Other Tables​

  • scheduler — Automated task execution
  • global_variables — Key-value configuration store
  • mysql_collations — Character set and collation reference
  • proxysql_servers — ProxySQL cluster node definitions
  • restapi_routes — REST API endpoint configuration

See Also​