ProxySQL 2021 Dev Submit
summary
ProxySQL adds a built-in Prometheus exporter exposing 180+ metrics and Grafana templates, switches to per-thread counters for zero-overhead scraping, and introduces streaming result buffering for prepared statements to cap memory use. Security gains include SPIFFE x.509 SVID auth and live certificate reloads; a client-error ban list and cluster node UUIDs with satellite awareness improve resiliency. The SQL digest refactor yields about 30% parser performance gain, EOF-to-OK protocol support lands, and upcoming QPS limit token-bucket rules throttle queries by user/schema/flags.
AI-written summary · about
chapters (13)
- 0:00Intro
- 1:11Features: Prometheus exporter
- 7:32Grafana Panels examples
- 8:27Features: Prepared statements resulset buffering
- 9:52Features: SPIFFE authentication
- 13:42Features: TLS improvements
- 15:59Features: Client Error Limit
- 18:06Features: Query digests improvements
- 27:08Features: Cluster improvements (v2.4.0)
- 29:55Features: CLIENT_DEPRECATE_EDF support
- 34:56Features: Compatibility improvements (upcoming)
- 37:20Features: QPS Limit rules (upcoming feature)
- 38:53Conclusions
related talks
27mThe State of ProxySQL, 2020 Edition
55mProxySQL Use Case Scenarios
50m#ProxySQL Use Case Scenarios
54mProxySQL at Scale
37mScale MySQL beyond limits with ProxySQL
06mRoad to Percona Live 2022 - Oleksandr Kuzminskyi - ProxySQL Talk
51mInexpensive Datamasking for MySQL with ProxySQL
58mDecentralized Cluster Nodes