The State of ProxySQL, 2020 Edition
summary
Overview of actual changes and demos: precise feature list, not fluffy promises. ProxySQL 2.0 adds LDAP authentication, client TLS, AWS Aurora host group handling, native clustering support for PXC/Galera/group replication, MySQL 8 support and a REST API routes engine that executes scripts over HTTP with configurable timeouts. 2.1 focuses on memory cuts (digest normalization, vacuuming stat tables), upgraded connectors and OpenSSL, savepoint handling, fast-routing without per-user entries, a built-in primitive exporter for Prometheus and an enterprise web ui for runtime editing and dashboards.
AI-written summary · about
chapters (22)
- 0:00Intro
- 0:23ProxySQL LLC
- 0:54We're hiring!!!
- 1:05Companies using ProxySQL
- 1:20Agenda
- 2:04The State of ProxySQL, 2019 edition
- 3:30Upgraded Dependencies in 2.1
- 4:09Performance Improvements
- 4:28Memory Optimizations
- 7:04What is REST API?
- 7:55Enable REST API
- 8:22Table restapi_routes
- 9:33Example of REST API
- 11:31ProxySQL 2.0.11
- 12:55ProxySQL 2.0.14
- 16:23New Cluster features in 2.1
- 17:34stats_mysql_query_digest (2/2)
- 18:32SQLite plugin
- 18:59PROXYSQL SHUTDOWN SLOW
- 19:25Prometheus exporter
- 21:00Grafana Dashboards
- 22:00Enterprise Web UI
related talks
41mProxySQL 2021 Dev Submit
55mProxySQL Use Case Scenarios
50m#ProxySQL Use Case Scenarios
06mRoad to Percona Live 2022 - Oleksandr Kuzminskyi - ProxySQL Talk
58mDecentralized Cluster Nodes
37mScale MySQL beyond limits with ProxySQL
54mProxySQL at Scale
08mMySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out