At the MySQL and Heatwave Summit 2025 today, Readyset announced a new data systems architecture pattern named Readyset QueryPilot . This architecture which can front a MySQL or PostgreSQL database infrastructure, combines the enterprise-grade ProxySQL and Readyset caching with intelligent query monitoring and routing to help support applications scale and produce more predictable results with varied workloads.
ProxySQL offers many features for MySQL and PostgreSQL including query rewriting, query routing, read/write splitting, fully configurable load balancing, connection pooling and connection multiplexing. Readyset provides a SQL wire-compatible cache for MySQL and PostgreSQL that can provide dramatic improvements in query latency and throughput performance with an existing application. Implementing a Readyset cache is significantly easier than implementing a traditional cache, but does require some initial analysis to choose the best queries to cache. Check out this Readyset Tutorial for more information. By using the flexible plugin architecture of ProxySQL, Readyset QueryPilot adds a sidcar to automatically monitor database load and query patterns and more intelligently determine which queries can be implemented using caching, snapshot and prepare these query caches and dynamically route queries when the cache is available. These real-time adjustments require no manual tuning or intervention enabling applications to benefit from caching with no-code changes and minimal configuration.
I’ve included some of the slides presented today here for viewing. I look forward to evaluating this new product offering. This will be a great option for AWS RDS and GCP CloudSQL managed database offerings as well as self-managed databases installations.
- Current Operational Data Systems Architecture
- New Operational Data Systems Architecture
