Rahul Desirazu, Author at Yugabyte

February 21, 2023

Can Distributed Databases Achieve Transactional Consistency on Async Standbys? Yes, They Can.

In this blog post, we will discuss how to maintain transactional read guarantees on an async standby configured through cross cluster replication. This feature has bearing on any user who runs a transactional application in a distributed setup. We think that may apply to many people reading this blog.

How to Handle Runaway Queries in a Distributed SQL Database

May 28, 2019

By Rahul Desirazu

Distributed SQL How It Works

How to Handle Runaway Queries in a Distributed SQL Database

Runaway queries are queries that scan through a large set of data. Such queries consume vast amounts of I/O and CPU resources of the database in the background, even if the results appear as harmless timeouts to the end user or the client application. How do runaway queries get executed in the first place, anyway? Everyone who uses databases has at some point or another entered SELECT * from some_large_table, only to realize they forgot to add a LIMIT n clause.

…

Author: Rahul Desirazu

Learn More to Accelerate Your Retail Business