Readyset: A Transparent Caching Layer for MySQL and Postgres

Summary

Readyset is a MySQL and Postgres wire-compatible caching layer designed to accelerate queries and scale read throughput horizontally. It intelligently caches select statement results and incrementally updates them as underlying data changes, eliminating manual cache invalidation. This powerful tool provides the performance of an in-memory key-value store without requiring application rewrites.

Use at your own risk

OSRepos shares public repositories for knowledge and discovery only. Any installation, execution, configuration, or use of code from these repositories is the user's own responsibility. Always review the repository, source code, dependencies, licenses, and security implications before running or installing anything. OSRepos is not responsible for issues, damages, or losses resulting from third-party repositories.

Introduction

Readyset is an innovative, transparent database cache for Postgres and MySQL. It acts as a wire-compatible caching layer, sitting between your application and database to dramatically speed up queries and enhance read scalability. Built in Rust, Readyset automatically keeps cached query results in sync with your database by leveraging its replication stream, offering the performance of an in-memory key-value store without the complexity of manual cache invalidation or application rewrites. It supports existing ORMs and database clients seamlessly.

Installation

Getting started with Readyset is straightforward. For a quick setup, you can run the following command:

bash -c "$(curl -sSL https://launch.readyset.io)"

Alternatively, Readyset can be installed via a Docker image or a Linux binary. For comprehensive instructions, refer to the official getting started guide.

Examples

To see Readyset in action and understand its capabilities, explore the interactive demo. The getting started guide also provides practical steps on how to connect Readyset to your database and begin caching queries effectively.

Why Use Readyset

Readyset stands out by offering a unique approach to database caching. Unlike traditional caching solutions that often require application changes or manual cache invalidation, Readyset operates transparently. It automatically updates cached results, ensuring data consistency with your primary database. This makes it an ideal solution for applications needing high read throughput and low latency, especially for complex SQL queries, without the operational overhead typically associated with performance optimization. Learn more about its advantages in the Why Readyset article.