The Curious Engineer

All blogs / Databases

Readyset Blog

readyset.io/blog

The Readyset blog — engineering deep-dives, product updates, and lessons from teams running PostgreSQL and MySQL at scale.

DatabasesPerformance / optimizationDistributed systems / cloudRust

’23’24’25’26
Posts
151 from 28 Nov 2023 to 29 Oct 2026
Posting
weekly (77 in the last year)
Kind
company blog
Feed
https://readyset.io/blog/rss.xml

2026 73

  1. Introducing Automatic Failover and Multi Server Support
  2. A TTL Cache Needs To Know the Query
  3. Black October: What Actually Happened, and What To Patch
  4. Readyset HA with ProxySQL and MySQL
  5. NewsIntroducing Readyset: High-Performance SQL Caching EngineToday, we’re excited to launch Readyset. Our mission is to help developers build faster applications without writing extra code. To accomplish this, we're building a high-performance SQL caching engine and performance monitoring solution t
  6. Meet the RDST Agent
  7. NewsReadySet: next-generation SQL caching, freely availableToday we’re announcing ReadySet Core, a freely available version of ReadySet that you can run anywhere from your own laptop to any cloud provider, on as many nodes as you need.Readyset2022-06-16·1 min read
  8. What Is a Wire-Compatible SQL Caching Proxy?
  9. Database CachingWhy hasn't caching gotten easier?Imagine you’re a developer for a large-scale e-commerce website that sells popular merchandise for sports teams (like my very own Golden State Warriors). One day, you receive an angry email that sales are lower than they ought to be, given your levels
  10. September Product Update 2026
  11. EngineeringHow are MySQL and Postgres ENUMs different?The Hidden Complexities of ENUM Data Types Halloween’s approach means it's the spooky month, and there’s nothing more spooky than the horrors lurking behind everyday database features. The humble enum may seem friendly and innocent enough, but le
  12. What's New in RDST: Free Inference and an Apache 2.0 License
  13. TutorialsDatabase caching in 10 minutes with Readyset and HelmTL;DR: You can now deploy Readyset to Kubernetes, via Helm, and start caching your database in minutes. Introducing Fast Deployment with Helm and Readyset Database caching can work wonders. By keeping a small, frequently accessed working
  14. Cache Invalidation for SQL Queries: How To Stop Writing It Yourself
  15. Product UpdatesNovember Product UpdatesWe had a busy October! Here's what's new this month in ReadySet.Readyset2022-11-01·2 min read
  16. August Product Update 2026
  17. EngineeringHow much does Rust's bounds checking actually cost?Rust prevents out-of-bounds memory accesses and buffer overruns via runtime bounds checks - what’s the cost of those bounds checks for a real-world, production application?Readyset2022-11-30·12 min read
  18. How Readyset Rewrites Your SQL: Subqueries in HAVING, ORDER BY, JOIN ON
  19. Product UpdatesDecember Product UpdatesHappy Holidays from the ReadySet team! We’ve been hard at work building the next generation of SQL caching, and in December, we shipped something for everybody. Here’s a quick overview of some of the changes we made this past month: Expanded SQL support We now
  20. July Product Update
  21. Product UpdatesApril Product UpdatesThis month's newsletter features some exciting news and updates from our community. We're excited to hear what you think! Please share your feedback in our community Discord or on Twitter (@readysetio). 🎓 Systems Distributed 2023: Why Caching Is Hard This past Feb
  22. Introducing Adaptive Cache for Dynamically Managing Freshness
  23. NewsTeam Member Spotlight: Vladimir RodionovWe are thrilled to welcome Vladimir Rodionov to the ReadySet Engineering team! He has spent over two decades solving difficult data-related problems at companies like Cloudera, Hortonworks and CarrierIQ. Additionally, he is the founder of CarrotDB and BigB
  24. Your Database Bill Is Climbing Faster Than Your Traffic
  25. NewsTeam Member Spotlight: Jason BrownWe are thrilled to welcome Jason Brown to the ReadySet Engineering team! His passions lie within the intersection of distributed systems and databases, and he has spent the past two decades developing and supporting massive scale OLTP databases at Apple, Netflix
  26. Nobody wants a cache
  27. Product UpdatesJune Product UpdatesThis month brings a new release of ReadySet, along with some new ways for you to get involved with the community. We're excited to hear what you think! Please share your feedback on Github, on Twitter (@readysetio), or by replying directly to this message. 🎉 New Qu
  28. June Product Update
  29. The Real Cost of Read Replicas (and When They Stop Paying Off)
  30. EngineeringStateful Property Testing in RustIntroduction Most developers have written unit tests: you feed your code some inputs and verify the outputs. Property tests automate this process. Instead of manually creating inputs, your test generates them for you and validates the input/output pairs ag
  31. Product UpdatesJuly Product UpdatesWe're excited to share our team’s progress this month as we continue on our path towards building a fully drop-in, transparent SQL cache for MySQL & Postgres databases. This month brings a new release of ReadySet, along with some ways for you to get involved in the
  32. Caching Supabase with Readyset over IPv6: the AWS and Docker pieces that have to line up
  33. NewsTeam Member Spotlight: Ron HoughAt ReadySet, we are building an agile team that can move cautiously but nimbly via strategic engineering investments. We strongly believe one such key lynchpin engineering investment is developer tooling and productivity. Ron brings a rich experience in developer
  34. TopK is now Generally Available
  35. Product UpdatesAugust Product UpdatesThe summer is winding down, but our team has been hard at work on a new release and some other goodies. Here’s what we’ve been up to this month: What’s New Expanded query support IN and NOT IN expressions with subqueries on the right-hand side in the projected fi
  36. Readyset Internals: The left-right pattern: lock-free cache
  37. Product UpdatesSeptember Product UpdatesThere’s a lot of exciting new features in our release this month, so let’s dive right in. What's New In this month’s release we expanded query support, adding the ability to use NOT EXISTS in a WHERE clause. We’ve also added the usability improvements to help
  38. Your AI now speaks Readyset: announcing the MCP server
  39. Product UpdatesOctober Product Updates✨What's New? ReadySet just got even better with our latest update: Improved write performance during replication for an even faster ReadySet experience Simplified observability Expanded caching support And more! Check out all the new features, updates, and bug f
  40. Readyset Launches QueryPilot Guard, a Control Plane for AI-Generated Database Queries
  41. Database CachingReadyset on Rails: Read Replica Simplicity, Cache PerformanceNow, you can integrate Readyset into your Ruby on Rails app in the same way you would a traditional read replica: by changing a couple of lines in your database config file. Once integrated, Readyset will give you the perfo
  42. May Product Update
  43. Database CachingDon’t use key-value stores to cache from relational databasesYour app is starting to see traction, and your database is feeling it. Query latencies are creeping up, and you can see it starting to falter under the load. You know you’re only one good story on HN away from an outage. Th
  44. NewsIntroducing Readyset Cloud for AWS PostgresYour database. 1,000x faster queries. In the click of a button. Today, we’re thrilled to announce the official rollout of Readyset Cloud for AWS Postgres users. The scalability of your software is limited by the scalability of your database, and typical
  45. Product UpdatesNovember Product UpdatesWhat’s New In our November release we’ve focused on user experience, making it even easier to get started and caching with ReadySet: You can quickly see how many times a query (proxied or cached) has been hit Know instantly how many clients are connected to Rea
  46. Query OptimizationFinding Slow Queries in Postgres Using DatadogYou’re starting to notice lags in your application's performance. Page loads are slowing, and the user experience is being impacted. At the same time, your AWS bills are also starting to creep up. These can be the tell-tale signs of ser
  47. EngineeringThe Role of CAP Theorem in Modern Day Distributed SystemsTwenty years after its debut, what is the role of the CAP theorem in modern-day distributed systems? Stumbling across the CAP theorem is like walking into a discussion (or a debate) already in progress. Imagine how others might feel
  48. Database ScalingMedical Joyworks Improves Page Load Times by 500% With ReadySetAbout Medical Joyworks Medical Joyworks is a medical education company specializing in gamified learning, catering to a diverse audience, ranging from medical students to pharmaceutical companies. They elevate healthcare
  49. Product UpdatesIntroducing the Readyset QuickstartWe’re excited to introduce the Readyset quickstart – the fastest and simplest way to test out Readyset. Our new quickstart guides you through the entire Readyset experience with either a demo database or your own Postgres or MySQL database by running
  50. PostgreSQLA Practical Guide to Caching: What to Cache and WhenCaching is a Goldilocks problem. Caching too much leads to stale data, memory bloat, and a lot of cache management. Caching too little leads to longer latencies, higher database load, and the need to provision more and more storage. The a
  51. EngineeringHow Database Replication Works Under the HoodReplicating data is a process you will encounter if you build a product. At the very least, you’ll want some kind of backup for your primary database, either through taking a snapshot or having a secondary “follower” database mirroring your pri
  52. TutorialsHow To Use Readyset Cloud To Scale Your ApplicationReadyset Cloud is a query caching platform that helps development teams improve the performance and scalability of their applications without code rewrites, query optimization, or infrastructure overhauls. This blog walks through the overar
  53. Product UpdatesJanuary Product UpdatesReadyset Cloud Available for AWS Postgres Readyset Cloud is a query caching platform that helps development teams improve the performance and scalability of their applications without code rewrites, query optimization, or infrastructure overhauls. Now, it's avai
  54. PostgreSQLWhat Is the N+1 Query Problem? How to Detect and Fix ItThe N+1 query problem makes your app run one query per record instead of one total, quietly multiplying database load until pages crawl. Here’s how to spot it across Rails, Django, Hibernate, and Prisma, detect it in Postgres and MySQL
  55. TutorialsOptimizing Performance: A 2024 Updated Guide to Setting Up Caching in LaravelLaravel is an excellent framework for those who want to use PHP. It pairs well with other languages, offers clean code, and includes features for a full-stack application out-of-the-box. One of those features is ca
  56. Product UpdatesFebruary Product UpdatesReadyset Cloud Now Available for AWS Postgres Readyset Cloud is now available for AWS Postgres users. When using Readyset Cloud, you can expect a drop-in integration and support for caching complex queries and automatically keeping the result sets up-to-date. T
  57. PostgreSQLHow Platform Engineers Can Automate Postgres MaintenanceDatabase maintenance is a crucial ingredient for sustained performance and data integrity. For platform engineers, automating routine tasks within a PostgreSQL environment ensures both reliability and relieves team members from repeti
  58. MySQLIntegrating Readyset with ProxySQL for MySQL workloadsProxySQL is a high-performance, high-availability proxy for MySQL, serving as an intermediary between MySQL clients and servers to optimize and manage database traffic. It provides advanced query routing, directing queries to the most approp
  59. Product UpdatesMarch Product UpdatesGet Started With Readyset Cloud Readyset Cloud is a SQL caching platform that helps you build performant, real-time applications without any code changes or switching databases. Sign up to start caching your queries today, or schedule a demo to explore how Readyse
  60. MySQLAutomatic MySQL Query Cache with Readyset and ProxySQLIn our previous blog post we announced Readyset version stable-240328 comes with the ability to integrate with ProxySQL. This version inspired the creation of a dedicated scheduler for integrating Readyset with ProxySQL, bringing the ability
  61. PostgreSQLMastering Query Rewriting for Faster PostgreSQL PerformanceWhen you first spin up your app, the emphasis is on getting started and getting data to your clients. But when you don’t have throughput, you are also not going to have enough concurrency to unveil bad queries. But then you have su
  62. PostgreSQLOptimizing SQL Pagination in PostgresSQL pagination is a technique to retrieve a subset of records from a Postgres table or result set. It allows you to divide large datasets into smaller, manageable chunks called "pages" and retrieve them one page at a time. Understanding Pagination in Po
  63. Product UpdatesApril Product UpdatesApril is officially over and it’s time for an update on what we’ve been shipping at Readyset! Let’s take a look at what’s changed since March: Partner with Readyset Readyset is looking for design partners to build out additional MySQL and PostgreSQL functionality
  64. MySQLMySQL 5.7 EOL: The End of MySQL Query CacheBack in October 2023, MySQL 5.7 reached end-of-life. With it went support for some of the earlier functionality of MySQL. No more updates, no more security patches, and, in some cases, no more customer support (or, rather, extended support continues, b
  65. MySQLMySQL 8.4 - What is new?MySQL 8.0 has been known for its innovative pace, introducing new breaking changes in minor releases within the 8.0 series, which has been a great debate among the MySQL community and a long ask to have a more stable release cadence within the same minor series. Oracle h
  66. PostgreSQLGetting started with Django, PostgreSQL, and ReadysetReal-world applications face performance challenges with growing data and user traffic. Caching mitigates these challenges by storing frequently accessed data, reducing database fetches, improving response times, and enhancing applicatio
  67. MySQLMySQL: Binary Log Transaction CompressionIntroduction MySQL 8.0.20 introduced a binary log transaction compression feature designed to save storage space and reduce network bandwidth usage by applying compression to each transaction. This feature can be enabled dynamically without restarting th
  68. Product UpdatesMay Product UpdatesMay is over, the days are getting hotter, and it’s time for an update on what we’ve been shipping at Readyset! Let’s take a look at what’s changed since April: Readyset Query Support is Expanding Readyset has partnered with some of the largest MySQL and Postgres sho
  69. Product UpdatesJune Product UpdatesHello July! With another month over, it’s time for an update on what we shipped at Readyset in June. Let’s take a look at what’s changed: Readyset at AWS Summit in NYC Our VP of Product, Tanmay, is in New York City this week for the AWS Summit on July 10th, 2024. T
  70. NewsReadyset Cloud is Now Available on AWS Marketplace!We are thrilled to announce that Readyset Cloud is now available on AWS Marketplace! This marks a significant milestone in our journey to make our product more accessible and user-friendly for our customers. Readyset Cloud supports out-of-the-bo
  71. NewsReadyset Cloud Support Now Available for Supabase Database!Readyset is excited to announce the support for its revolutionary database scaling and query caching platform, Readyset Cloud, for Supabase Database, a hosted PostgreSQL database trusted by millions of developers. As your application gro
  72. Product UpdatesJuly Product UpdatesAs we dive into August, it’s time to take a look at what the Readyset team was up to in July! Readyset BYO-VPC Is Live Readyset BYO-VPC has been our most requested feature, and we’re thrilled to announce that it is now live! With BYO-VPC, customers can use their ow
  73. MySQLIntroducing Hash Join AlgorithmJoins are a concept in relational databases, allowing the combination of data from two or more tables. Joins establish a relationship between two tables using a common key, which is used to lookup data from one table to another. There are different types of joins

2025 40

  1. Product UpdatesAugust Product UpdatesWe hope you're enjoying the start of September. Let's check out what's new at Readyset! Product Updates Readyset Cloud BYO-VPC is live! Customers can now deploy Readyset and maintain full control over their cloud environment. Check out this short video walkthroug
  2. MySQLReadyset Cloud Adds Support for MySQL - Unleash Unmatched Database PerformanceReadyset is thrilled to announce the availability of MySQL database support in Readyset Cloud! This marks a significant milestone for MySQL users who have long sought an efficient way to speed up their database querie
  3. Product UpdatesSeptember Product Updates👋 Happy fall! September has been a busy month for the Readyset team, and we’re excited to share some of our new releases. Let’s check out what’s new at Readyset! Product Updates Readyset Cloud 🐬 MySQL Support on Readyset Cloud Readyset Cloud now supports MySQL
  4. MySQLMigrating From RDS MySQL 5.7 to RDS MySQL 8.0 Using Blue/Green Deployment and ReadysetOverview MySQL 5.7 has reached EOL in October 2023 forcing users to migrate to MySQL 8.0. Migrating from MySQL 5.7 to MySQL 8.0 offers significant performance improvements and new features, but the removal of
  5. Product UpdatesOctober Product Updates👋 Hope everyone had a great October and enjoyed spooky season! Here’s a look at what’s new at Readyset. 🚨 ClickFunnels Reduces Database Workload by 85% with Readyset ClickFunnels, a leading marketing and lead generation platform, reduced its database workload by
  6. Query OptimizationDemystifying EXPLAIN and EXPLAIN ANALYZEYou've crafted the ideal SQL query. It's beautiful. A work of art. Then, it takes seconds to execute and hangs your entire application. What went wrong? You need a way to look under the hood of SQL and understand the inner workings of your qu
  7. Database CachingWhy Query Caching Is the Most Cost-Effective Way To Scale Databases — and Everyone’s Missing ItScaling databases is no small task, and in the rush to find fast, affordable solutions, teams often overlook a key technique: query caching. By intelligently caching database queries, we’re
  8. Product UpdatesNovember Product Update👋 Hello December! Hope everyone had a great November and for those who celebrated, a wonderful Thanksgiving. Before we dive in, a quick note: our VP of Product, Tanmay Sinha, and I are currently at AWS re:Invent and would love to connect with you! If you’re atte
  9. Product UpdatesDecember Product Update👋 Hello 2025 – Hope you’re settling into the new year and had a joyful holiday season! Let's dive into what's new at Readyset. Readyset MySQL Interactive Demo In November, we launched our interactive demo for Postgres, and we're excited to announce that the demo
  10. EngineeringTracing Large Memory Allocations in Rust with BPFtraceTracing memory allocations is critical when debugging performance or memory-related issues in high-performance applications. However, Rust still lacks a good toolset to do so and often some techniques require code changes such as chang
  11. Database ScalingHorizontal scaling with Postgres replicationModern applications demand scalability to support growing user bases, real-time responsiveness, and large data volumes. But as applications grow, vertical scaling by adding more compute resources has an upper limit. Once those limits are hi
  12. NewsReadyset and PerformanceDB Join Forces to Revolutionize MySQL Database Scaling in BrazilAt Readyset, our mission has always been to empower businesses by providing innovative database scaling solutions that help organizations maximize the performance of their existing Postgres and MySQL infrastr
  13. Product UpdatesJanuary Product Update👋 Hello – it’s our first product update of 2025, so let’s kick the year off with some big updates. Readyset 🤝 PerformanceDB We’re elated to announce our new partnership with PerformanceDB with the goal of improving MySQL database scaling for businesses in Brazil!
  14. Product UpdatesFebruary Product Update👋 Hello – hope everyone had a great February! Let’s catch up on what’s new at Readyset. 🚨 Grupo Ótima Digital Cuts Database Load and Scales MySQL Infrastructure with Readyset Grupo Ótima Digital, a leading messaging solutions provider in Brazil, reduced its MySQ
  15. TutorialsGetting Started with Readyset on MySQLOptimizing MySQL and PostgreSQL performance is crucial for modern applications, especially those with read-heavy workloads. Readyset is a drop-in SQL caching engine that sits between your application and the database. It automatically caches query resul
  16. TutorialsGetting Started with Readyset on PostgreSQLPostgreSQL is one of the most potent relational databases, but performance can become a bottleneck as queries become complex. One of the most effective ways to reduce query latency without modifying application logic is caching, and Readyset provid
  17. Query OptimizationOptimizing SQL Pagination in MySQLIn our blog post on Optimizing SQL Pagination in Postgres, we explained how to optimize SQL pagination for Postgres. As a counterpart, we’ve decided to write one for MySQL pagination. Like PostgreSQL, MySQL offers several ways to handle pagination,
  18. NewsReadyset Cloud Is Now AWS FTR Approved: A New Era for Scalable PostgreSQL and MySQL CachingWe’re excited to announce a major milestone: Readyset Cloud has officially achieved AWS Foundational Technical Review (FTR) approval! This certification validates that Readyset meets AWS’s high standards f
  19. Product UpdatesMarch Product UpdateHello and happy Spring! Hope everyone had a great March. Let’s dive into what the Readyset team has been up to. 🎉 AWS Foundational Technical Review Approved We’re thrilled to announce that Readyset has completed and passed the AWS Foundational Technical Review (FTR
  20. NewsAnnouncing a Strategic Partnership Between Readyset and CYBERTEC to Accelerate PostgreSQL PerformanceWe are excited to announce a strategic technology partnership between Readyset, the leading provider of SQL query caching solutions, and CYBERTEC PostgreSQL International GmbH, the premier Postgr
  21. EngineeringA Deep Dive on Readyset Behind PgBouncerThe title of this post sets the stage for a compelling discussion, and I’ll start with a direct spoiler: Readyset is about performance. It delivers exceptional query acceleration because it behaves as an intelligent cache—without relying on traditio
  22. Database ScalingVertical Scaling of MySQL vs. Horizontal Scaling with Readyset: A Cost and Performance Analysis in the CloudScaling relational databases in the cloud often creates a tension between cost and performance. As workloads grow—especially read-heavy ones powering analytics, dashboards, or
  23. TutorialsReadyset Private on Azure VM: A Hands-On Guide to Caching Performance (MySQL Edition)"What if scaling reads didn’t require replicas, rewrites, or added infrastructure complexity? This post walks you through running Readyset—a caching layer purpose-built for real-time SQL acceleration—on Azu
  24. Product UpdatesApril Product UpdateHi there, hope your spring is off to a great start! Here’s what’s new at Readyset: 🎉 Readyset Private on Azure VM (MySQL Edition) You can now deploy Readyset privately on an Azure VM with MySQL and see performance gains from milliseconds to microseconds! Setting up
  25. Database ScalingDatabase Performance: The Hidden Engine of Competitive AdvantageIn today's digital economy, milliseconds matter — and not in abstract ways. Every additional millisecond of application response time erodes user satisfaction, increases abandonment rates, and compounds operational ineff
  26. Query OptimizationIdentifying Cacheable Queries: Using tools like pt-query-digest or the MySQL sys schema to pinpoint queries that would benefit from cachingIntroduction It’s common for DBAs to optimize queries to address bottlenecks and reduce resource contention. However, in production workloads,
  27. Database CachingLess Work is Faster: Database Caching Done RightEvery engineer eventually confronts the complexities of scaling applications and systems. At first glance, the solution seems straightforward: add more cores, introduce replicas, or distribute workloads. However, at scale, each decision
  28. Product UpdatesMay Product UpdateHi there, hope you’re enjoying a great start to the summer season! Let’s dive into what’s new at Readyset: 📝 We're Taking Applications for QueryPilot Private Beta We’re now accepting applications for the private beta of QueryPilot, our new smart, single endpoint that
  29. Database CachingWhen and Why to Cache a Query: Addressing Developer Pain PointsA PostgreSQL community member recently sparked a lively discussion on Reddit about database caching strategies. The genuine frustrations expressed in the responses highlighted the need for simpler, more reliable solutions
  30. Database ScalingReadyset: Scale PostgreSQL and MySQL Performance by 100x Without Code ChangesReadyset is a database scalability and query caching platform designed to dramatically accelerate query performance without requiring code changes. Based on nearly a decade of research at MIT on database cac
  31. Database CachingWhen Query Optimization Isn’t Enough: Solving MySQL Overload with CachingConsider the perfect scenario: the database is running on reliable hardware, MySQL has been finely tuned, and queries have been reviewed and optimized. Despite this, sustained business growth inevitably leads to
  32. Product UpdatesJune Product UpdateHi there, hope you’re keeping cool as summer heats up! Let’s dive into what’s new at Readyset: 💬 Product Updates Readyset Cloud Improved concurrency management and cache reliability enabling a more predictable and resilient system. Improvements include thread-safe r
  33. Database CachingReadyset QueryPilot Automates Query Caching for MySQLQueryPilot is Readyset’s automatic query caching engine for MySQL. It automatically identifies and caches your most expensive queries at the SQL layer, with no code changes or manual tuning. Today, we're announcing the Public Beta
  34. Product UpdatesJuly Product UpdateAugust’s here, and we’re kicking it off with a bang. Here’s what’s new at Readyset: 🛫 Introducing Readyset QueryPilot: Zero-Touch Caching for OLTP Workloads We’re excited to announce the public beta for Readyset QueryPilot for MySQL, our smart database scaling solut
  35. EngineeringOptimizing Straddled Joins in Readyset: From Hash Joins to Index Condition PushdownIntroduction Readyset is designed to serve queries from cached views with sub-millisecond latency. This post focuses on the cold path—cases where a cache miss forces execution against the base tables. In th
  36. Database ScalingWordPress with QueryPilot: Instant Database Scaling Without Code ChangesIntroduction We at Readyset, recently launched the public beta of QueryPilot, an automatic query caching layer designed to make scaling relational databases effortless. QueryPilot analyzes real-time query traffic
  37. EngineeringBehind the Magic: How Readyset Speeds Up Queries with Streaming DataflowDatabase performance is often the bottleneck in high-traffic web applications. Whether you're serving user dashboards, product catalogs, or personalized content, the same SQL queries get executed repeatedly. Caching s
  38. Query OptimizationReadyset Now Supports SQL Window Functions.We're excited to announce that Readyset now supports SQL Window Functions. This powerful addition means you can now cache more of your complex queries without modifying a single line of application code, bringing the performance benefits o
  39. EngineeringCollation improvements in ReadysetHow often do you think about alphabetization? Software engineers don’t typically think a lot about it. How hard can it be to sort 26 letters, or maybe twice as many if you count lower and upper case? But examination of real world alphabetization quickly r
  40. Product UpdatesAugust Product UpdateAs the world starts adding Earth, Wind and Fire back on to their playlists, here’s what’s new at Readyset: Scaling WordPress Instantly with Readyset QueryPilot Last month we launched Readyset QueryPilot, our zero-touch automatic caching solution, in beta for MySQL

2024 33

  1. NewsReadyset MySQL BR Conf 2025 Challenge – Sorteio de R$500Obrigado por participar do MySQL BR Conf 2025 e celebrar os 30 anos do MySQL! Tivemos um tempo fantástico conectando com vocês e mal podemos esperar para ver os resultados do desafio. Como participar para ter a chance de ganhar um prêmio em
  2. Product UpdatesSeptember Product UpdateSpooky 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 i
  3. EngineeringHow Readyset Handles Window Functions Under the HoodHow Readyset Supports and Optimizes Window Functions Window Functions are an integral part of SQL performance and query optimization, and they're widely supported in production databases today. To achieve our goal of helping our users sc
  4. Database ScalingDoes Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers?It Might Be Time to Rethink How You Scale MySQL for Peak Demand As Black Friday and Cyber Monday approach, many engineering teams prepare for their annual database performance stress test. The surging traf
  5. Product UpdatesOctober Product UpdateAs traffic spikes approach for the holiday season, we’ve rolled out new improvements to help you keep database performance fast and predictable. Here’s what’s new: 💬 Product Updates Readyset Core * Smarter Time-Series Aggregations: We introduced Bucket(timestampt
  6. EngineeringReadyset Adds New Query Capabilities With the Bucket FunctionReadyset is a cache layer that sits between the application and the database, acting as a cache for supported queries and proxying unsupported queries upstream. This means that any query Readyset supports is theoretically suppor
  7. Product UpdatesNovember Product UpdateAs we sled our way into the holiday season, here’s what’s new at Readyset: 💬 Product Updates Readyset Core Smarter Table Renames: Readyset now detects RENAME TABLE and ALTER TABLE ... RENAME TO operations and automatically re-snapshots the affected tables, maint
  8. NewsA Look Back at 20252025 was the year we started noticing things we couldn’t easily explain away. We shipped a lot, but what stuck with us were the patterns we kept seeing in production. Traffic didn’t line up with application releases. Queries that looked reasonable in isolation would end up des
  9. AI & DatabasesPredictions About the Effect of AI on Enterprise Software and InfrastructureWe embarked on an exercise to predict how Enterprise infrastructure (including data infrastructure), will change with AI. Along the way, we made several observations about software and processes in general. I'm
  10. Database ScalingThe Hidden Complexity of Postgres Scaling ArchitecturesThe OpenAI Postgres scaling article has been making the rounds, and for good reason. The piece does two things extremely well. First, it shows just how Postgres can be pushed far beyond what most teams assume is possible. Second,
  11. AI & DatabasesThe Database Is About to Lose Its Last Line of DefenseFor a long time, most serious database incidents shared a common root cause: a human made a mistake. It could be a poorly written query that caused a spike or a permission was too broad or maybe a review didn’t happen. Database secu
  12. Product UpdatesJanuary Product UpdateLet’s dive into our first product update of 2026! 💬 Product Updates Readyset Core MySQL Replication Server UUID Support: Added the --replication-server-uuid option to set a server UUID in MySQL. This UUID is now reported in SHOW REPLICAS. OOM Prevention for Large
  13. Engineering/brutal-review and the new 80/20 rule(Mistakes and em-dashes are my own.) We have a Claude Code command in our monorepo which is a good example of what I’m calling the "80/20 token rule": if it takes 20M LLM tokens to write a feature, you should spend 80M on ensuring quality: safety measu
  14. MySQLMySQL 9.6: Foreign Key Cascade Operations Finally Hit the Binary LogFor years, MySQL users working with Change Data Capture (CDC), and replication environments have dealt with a fundamental architectural limitation: foreign keys were handled by the Storage Engine (InnoDB) and cascading operatio
  15. MySQLReplication Internals: Decoding the MySQL Binary Log - Part 1: Introduction and Data TypesThis is the first post in a series where we dive deep into the MySQL binary log format. We'll manually read binary log files byte by byte to understand exactly what goes under the hood of MySQL replication
  16. AI & DatabasesVibe Coding a High-Performance App with Readyset QueryPilotIn this blog post, we are going to use "Vibe Coding" to build an application and explore Readyset QueryPilot, a tool designed to automatically analyze and cache queries in a MySQL workload. The goal is to prove that even for au
  17. MySQLReplication Internals: Decoding the MySQL Binary Log Part 2: File Header and Common Event HeaderIn this second post of our series, we examine the binary log file header and the 19-byte common event header that every event shares. The Binary Log File Header (Magic Number) Every MySQL binary log
  18. Database CachingBest of Both Worlds: Introducing Readyset Shallow CacheReadyset has always been defined by our incremental dataflow engine. It compiles your SQL into a dataflow graph where base table nodes ingest the replication stream (binlog/WAL) from tables being replicated to Readyset. Internal
  19. Product UpdatesFebruary Product UpdateIt’s been a busy month with lots of updates, let’s dive into them: Readyset Shallow Cache This month we introduced Readyset Shallow Cache, a new caching layer designed to expand Readyset’s query coverage. Readyset’s deep caching engine has always delivered sub-m
  20. MySQLReplication Internals: Decoding the MySQL Binary Log Part 3: FORMAT_DESCRIPTION_EVENT — The Self-Describing EventIn this third post of our series, we decode the FORMAT_DESCRIPTION_EVENT — the critical first event in every binary log that tells us how to interpret everything that follows. Introd
  21. MySQLReplication Internals: Decoding the MySQL Binary Log Part 4: PREVIOUS_GTIDS_LOG_EVENT — Tracking Transaction HistoryIn this fourth post of our series, we decode the PREVIOUS_GTIDS_LOG_EVENT — the event that tracks which GTIDs were recorded in prior binary log files, enabling replicas to determi
  22. MySQLReplication Internals: Decoding the MySQL Binary Log Part 5: GTID_LOG_EVENT — The Global Transaction IdentifierIn this fifth post of our series, we decode the GTID_LOG_EVENT — the event that marks every transaction with a globally unique identifier. Introduction Every transaction in a GTID-enab
  23. Product UpdatesMarch Product UpdateSpring is here, and March kept us busy. Grab a coffee and see what the Readyset team has been up to. Hussle Technology Eliminates Peak-Season Database Load with Readyset Hussle Technology, a global leader in direct sales and field-sales enablement software, was fac
  24. MySQLReplication Internals: Decoding the MySQL Binary Log - Part 6: QUERY_EVENT — DDL Statements and Transaction BoundariesIn this sixth post of our series, we decode the QUERY_EVENT — the workhorse event that records DDL statements and transaction boundaries. Introduction The QUERY_EVENT (event typ
  25. Database CachingQuery Hints: Let Your Application Decide What Gets CachedWe kept hearing the same thing from customers: "We already know which queries need caching. Why do we need to go through the DBA to set it up?" Fair point. So we built Query Hints: The Old Way Was Slow for the Wrong Reasons Cac
  26. MySQLReplication Internals: Decoding the MySQL Binary Log Part 7: TABLE_MAP_EVENT – Table Metadata for Row-Based ReplicationIn this seventh post of our series, we decode the TABLE_MAP_EVENT — the event that maps a numeric table ID to a database/table name and the column layout that the row events im
  27. MySQLReplication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWSIn this eighth post of our series, we decode the three row events — WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT — that carry the actual row data for INSERT, UPDATE,
  28. MySQLIntroducing MySQL GTID Support and Zero-Downtime Failover in ReadysetOne of the most requested features since Readyset first supported MySQL has been GTID-based replication. With the latest release, Readyset now fully supports MySQL Global Transaction Identifiers (GTIDs), and with it, a capabil
  29. AI & DatabasesWhy LLMs Write Incorrect SQL (and What That Means for Your Database)Most LLM-generated SQL doesn't fail. It runs and returns results, and that's exactly what makes it dangerous. The errors don't surface until they're already in your data. AI-assisted development has made it easier than
  30. MySQLReadyset Is Ready for MySQL 9.7 - Three Commands With rdstMySQL 9.7.0 LTS landed today, and we had the pleasure of watching the announcement live — and we were the first ones to download. If you've already pulled the binaries and you're poking at it in a lab, here's the news: Readyset already s
  31. EngineeringHow Readyset Rewrites Your SQL: Inside the Query Transformation PipelineWhy Query Rewriting Matters for Dataflow Most databases work the same way: a query arrives, the engine builds an execution plan, scans tables, joins rows, filters, aggregates, and returns the result. Every time the qu
  32. Product UpdatesIntroducing rdst: The Client-Side SQL Performance ToolkitReadyset has always been about making database scaling effortless. Today, we’re extending that mission from the server to the developer’s terminal with rdst, a production-native, AI-powered CLI that helps teams write better quer
  33. MySQLReplication Internals: Decoding the MySQL Binary Log Part 9: XID_EVENT — Transaction CommitIn this ninth post of our series, we decode the XID_EVENT — the smallest event in the binary log, and the one that marks every transactional commit. Introduction Every DML transaction we've decoded so far

2023 5

  1. Product UpdatesApril Product UpdateHello, April was a big month at Readyset. Let’s catch up on what’s new. Introducing rdst: The Client-Side SQL Performance Toolkit Our mission has always been to make database scaling as easy as possible. We’re excited to share the next step in that journey: rdst. r
  2. MySQLReplication Internals: Decoding the MySQL Binary Log Part 10: ROTATE_EVENT — Closing the File and Pointing at the Next OneIn this tenth post of our series, we decode the ROTATE_EVENT — the event that closes a binary log file and tells every reader, replica or local, where to look next. Introduc
  3. Database CachingCaching real GitLab queries on Azure Postgres with ReadysetGitLab on Azure Postgres is expensive once a few teams start hammering the REST API. The bill grows because Postgres has to serve the same project list, issue count, and dashboard rollup over and over again, on top of the rea
  4. MySQLReplication Internals: Decoding the MySQL Binary Log Part 11: GTID_TAGGED_LOG_EVENT — Tagged GTIDs and MySQL's New Serialization FrameworkIn this eleventh and final post of our series, we decode the GTID_TAGGED_LOG_EVENT — the event MySQL 8.4 introduced to carry user-defined tags alongside the
  5. EngineeringFrom parser combinators to hand-written TDOP: On adopting sqlparser-rs at ReadysetHow Readyset replaced its homegrown SQL parser with sqlparser-rs, improving performance, reducing maintenance overhead, and tackling a years long backlog of parsing edge cases along the way.Michael Victor Zi