Announcing ProxySQL 3.0.6 and the New Multi-Tier Release Strategy
Today is a milestone day for the ProxySQL project. We are announcing not just one, but three distinct releases that represent our new approach to balancing production stability with cutting-edge innovation.
Stability at the Core, Innovation at the Edge
As ProxySQL has grown to power some of the world’s most demanding database infrastructures, our community’s needs have diversified. Some users require absolute, “boring” stability for mission-critical production environments. Others are eager to leverage the latest advancements in observability and Generative AI.
To serve everyone effectively, we are introducing a Multi-Tier Release Strategy:
- Stable Tier (v3.0.x): The gold standard for production. This tier focuses on core hardening, protocol compatibility, and essential bug fixes.
- Innovative Tier (v3.1.x): For early adopters who want production-ready features that push the boundaries of observability and performance.
- AI/MCP Tier (v4.0.x): Our experimental playground for the future of database proxies, featuring native AI integrations and agentic workflows.
ProxySQL 3.0.6: The New Stable Standard
ProxySQL 3.0.6 is a recommended upgrade for all users. This release significantly expands our PostgreSQL capabilities and addresses important edge cases in protocol handling.
Key Highlights of 3.0.6:
- Replication Lag Monitoring for PostgreSQL: We’ve introduced native support for tracking replication lag on PostgreSQL backends. This allows ProxySQL to make more intelligent routing decisions based on real-time data freshness.
- Advanced PostgreSQL Query Logging: ProxySQL now offers advanced query logging for PostgreSQL with parity to the MySQL
eventslogbehavior, providing deep visibility into query patterns and execution history. - Enhanced PostgreSQL Compatibility: We are continuing our journey to make ProxySQL a first-class citizen for the PostgreSQL ecosystem. This release adds support for common
psqlmeta-commands (like\d,\dt, and\l) directly in the Admin interface. - Authentication Hardening: We’ve resolved a concurrency issue in the SCRAM authentication protocol where non-thread-safe functions could lead to authentication failures under high load.
- Operational Observability: New protocol-specific labels in Prometheus metrics eliminate ambiguity in hybrid MySQL/PostgreSQL environments, making your monitoring dashboards cleaner and more accurate.
- Expanded Platform Support: Official support for macOS (Darwin/Apple Silicon) is now live, along with updated packaging for Fedora 43.
Looking Ahead: Innovation and AI
While 3.0.6 brings the stability you rely on, we are also releasing ProxySQL 3.1.6 (Innovative) and ProxySQL 4.0.6 (AI/MCP) today.
ProxySQL 3.1.6 introduces our new Embedded Time-Series Database (TSDB) and Fast Forward Traffic Observer (FFTO), providing unprecedented visibility into your traffic. ProxySQL 4.0.6 goes even further, introducing a native Model Context Protocol (MCP) stack and Generative AI integrations to pave the way for intelligent, autonomous database management.
A Heartfelt Thank You to Our Contributors
This multi-tier release was made possible by the incredible work of our community. We want to extend a special thank you to @rahim-kanji, @wazir-ahmed, @JavierJF, @Gonlo2, @mirostauder, @evkuzin, @orbisai0security, and @mevishalr for their significant contributions.
Stay tuned over the coming days as we publish deep-dive posts into the revolutionary features of our Innovative and AI tiers, as well as detailed walkthroughs of our new PostgreSQL monitoring capabilities!