readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.54k stars 125 forks source link

Add failover capability #1341

Open altmannmarcelo opened 4 months ago

altmannmarcelo commented 4 months ago

Description

When a primary database goes does, one of the secondaries will take over and be promoted to the primary.

Readyset should be able to adjust to the new primary, by changing the url string it is connected to and also allow for pointing to the new Binary Log File and Position (MySQL) or WAL (PostgreSQL).

Change in user-visible behavior

Requires documentation change