The reigning champion of MySQL proxies, ProxySQL, has set its sights to conquer new territory. Today marks the dawn of a new era as ProxySQL unveils its 3.0.0-Alpha release, bringing PostgreSQL – the darling of developers, and the titan of open source databases – under its formidable umbrella.
A Game Changing Expansion
Long respected for its MySQL prowess, ProxySQL is now poised to offer a comprehensive solution for environments utilizing both MySQL and PostgreSQL. This alpha release represents an important evolution in database proxy technology.
“Adding PostgreSQL support is a natural progression for ProxySQL,” says René Cannaò, lead developer, and CEO at ProxySQL. “We’re responding to the needs of our users who work with diverse database environments. Our goal is to provide a unified, high-performance proxy solution that bridges the gap between these two popular open-source databases.”
Key Breakthroughs in ProxySQL v3.0.0-Alpha
PostgreSQL Support: Expanding Capabilities
- Full proxy functionality for PostgreSQL databases, complementing existing MySQL support
- Implementation of Plain Text, MD5, and SCRAM-SHA-256 authentication methods
- SSL connection support for both frontend and backend PostgreSQL connections
- Advanced features including connection multiplexing and connection pool reuse
- Support for executing multiple statements within a single query
Enhanced Architecture and Performance
- Redesigned Query Processor Architecture with dedicated processors for MySQL and PostgreSQL
- Improved handling of malformed packets and transaction detection
- Optimised buffer functionality and packing process for enhanced performance
Comprehensive Configuration and Monitoring Tools
- Introduction of PostgreSQL-specific configuration tables and options
- New statistics tables for detailed monitoring of PostgreSQL connections and queries
- Enhanced error logging and debugging capabilities
Availability and Testing
ProxySQL v3.0.0-Alpha is now available for testing, and evaluation. As an alpha release, it is not recommended for production environments. We encourage our community to:
- Conduct thorough testing in isolated, non-production environments. Reading How to Configure ProxySQL for PostgreSQL for the first time will help you get started
- Report any bugs or issues encountered during testing
- Provide feedback on the new PostgreSQL support feature at the Google Group
About ProxySQL
ProxySQL is an advanced, high-performance SQL proxy that operates as a intermediary between client applications and backend database servers. It employs a multi-threaded architecture for efficient query processing and connection management. Key features include:
- Dynamic query routing based on configurable rules
- Connection pooling to reduce database connection overhead
- Query caching for improved response times
- Load balancing across multiple backend servers
- Query rewriting and filtering capabilities
- Real-time traffic analysis and monitoring
- Support for database failover, and high availability setups
ProxySQL is designed to handle high concurrency workloads, and can scale to manage thousands of concurrent connections. It supports various MySQL compatible databases and, with this release, extends its capabilities to PostgreSQL environments.