Shopify

Read Consistency with Database Replicas - Shopify

Feb 22, 2021
Read Consistency with Database Replicas - Shopify
SummaryAI, from the source post

Introduces a solution for monotonic read consistency in database replicas by modifying ProxySQL. This involves using a `consistent_read_id` in query comments to hash and deterministically select a replica for a series of related reads, ensuring a coherent data timeline. Addresses two key issues: handling server unavailability by indexing into the full list of configured servers and then disqualifying unavailable ones, and disabling ProxySQL's secondary load balancing for consistent read requests to prevent overriding the hash-based selection.

More from the Data Store Selection and Usage trail