September Product Update

2 min read

•

about 1 month ago

Spooky season is here, and so are the latest updates from Readyset:  

QueryPilot Demo: It's Not Broken, It's Just That Fast.

QueryPilot automatically finds and optimizes your most expensive queries with zero manual tuning or configuration. Its performance is so instant that results are ready before you even realize the query ran.

In this demo, Tanmay and Mike show how simple it is to get started with QueryPilot, and how effortlessly you can scale workloads. 

MySQL users → Join the beta,  first 2 months free.

Postgres users → Sign up for the private preview waitlist.

💬 Readyset Product Updates

Readyset Cloud

We’ve introduced Observability Clusters, providing cloud-based visibility into on-premises Readyset deployments. Key benefits include: 

  • Centralized Visibility: Monitor self-hosted deployments from a cloud interface.
  • Secure by Design: Only metadata and metrics ever leave your environment.
  • Faster Response: Real-time metrics and alerts for rapid troubleshooting.
  • Seamless Deployment: Deploy and operate like any other Readyset cluster.

We’ve added Query Blacklisting in QueryPilot for precise control over caching while keeping recommendations focused on high impact queries. Key benefits include: 

  • Avoid Stale Data: Prevent caching for queries that require fresh results.
  • Cleaner Analysis: Exclude low-value queries from recommendations.
  • Targeted Decisions: Focus caching on performance-critical workloads.
  • Flexible Controls: Blacklist queries individually or by pattern.

Readyset Core

  • Catch Silent Mismatches Before They Matter: Introduced a new query sampler thread in the Readyset Adapter that continuously samples queries and validates their results against the upstream database. It flags potential mismatches early, so you can catch and debug issues before they impact production workloads.
  • Full Materialization Is Now GA: Queries without predicates (fully materialized queries) are now generally available. This expands Readyset’s query coverage, particularly for analytical and dashboard-style workloads that benefit from caching entire tables.
  • Faster Debugging with Enhanced SHOW Commands: SHOW READYSET TABLES now responds immediately and surfaces real-time table states such as compaction or index creation. It also includes percentage-based progress indicators, making it easier to monitor performance during snapshots and schema changes.
  • TLS for MySQL Upstreams: Readyset now supports TLS for upstream MySQL connections, enabling secure, production-grade deployments without workarounds.
  • Better Feature Visibility: SHOW READYSET STATUS now lists which advanced features, such as Top-K, post-lookups, and straddled joins, are enabled, providing clearer visibility into runtime behavior.
  • And more!

Check out the full release here. 

🆕 New on the Blog

Collation improvements in Readyset

Sorting text sounds trivial, until you account for languages, accents, and scripts. This post shows where MySQL’s collation model breaks, and how Readyset extended ICU4X to deliver correct, collation-aware query performance.

September Event Recap

PGDay Austria - September 4, 2025

Tanmay and I had a fantastic time at PGDay Austria, where we presented a keynote, “Data Gravity is Real: But You Can Bend It.” We showed how unifying the operational database and query engine can simplify data pipelines and eliminate latency.

Later, we demoed how Readyset scales read performance in PostgreSQL far beyond its native capabilities. Thanks to everyone who stopped by the booth to talk shop, share ideas, and be part of the conversation.

🧑‍💻Request Features

Keen to use Readyset but your database or cloud environment are not supported? Reach out to support@readyset.io and let us know.

🤝 Get Involved

We love hearing from you! If you want to get involved with Readyset, you can:

Authors

R

Readyset