Vijay Siva Vijay Siva

I have an index and my query is still slow

To prevent query performance degradation, we generally add indexes to frequently accessed columns. For the most part, this simple strategy will fine, but what if you have an index and your query is still slow? How do we debug these issues and are there any solutions?

Read More
Vijay Siva Vijay Siva

Replication Lag: Messages from the Future

What are some problems we might have when we have multiple services sending messages to each other with different views of the same data? This post will go into one of those problems: receiving messages from the future.

Read More
Vijay Siva Vijay Siva

Replication Lag: Read-Your-Writes Consistency

For ready heavy workloads, one of the most common database patterns to increase your application’s ability to handle many concurrent reads is to move to a Single-Leader replication pattern. But with every distributed system, you leave yourself open to numerous consistency issues. This post will cover how to guarantee read your writes consistency in a single-leader database architecture

Read More