Replica Lag

Command Palette

Search for a command to run...

Replica Lag

UpdatedMarch 5, 2025

•1 min read•View as Markdown

Danny Crasto

I am developer/code-reviewer/debugger/bug-fixer/architect/teacher/builder from dubai, uae

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

8 Simple reminders

You Should Tell Yourself

Jul 22, 2026·1 min read·14

Design a url shortner

A URL shortener is a proxy service that provides a mapping between the short and full representation of a URL. The short URL has the advantage of being small. The service can also provide useful analy

Jul 19, 2026·2 min read·218

No regrets

Listening to the Mel Robbins's podcast on regrets was a 'ear'-opener. One can have reqrets of action or inaction. 4 types of reqrets foundation - should've done the work boldness - should've taken t

Jul 15, 2026·1 min read·23

Design a distributed unique id generator

We need to create a unique ID generator for our high-traffic web application, generating about 10K IDs/second. The IDs can't simply be monotonically increasing integers, which are good for data access

Jul 9, 2026·2 min read·143

Design a distributed unique id generator

luck surface area

doing + telling

Jun 24, 2026·1 min read·90

Danny's blog

75 posts

I like computers

Websites are inherently read heavy. There are various technologies that help to serve content from CDNs to application level caching. Databases can also be configured with read only replicas. Read queries can routed to these servers alleviating the load on the master database. However, replicas can lag behind the master if

There are DDLs on the master that needs to be replicated
Under provisioned read replicas are trying to keep up with busy master

These would lead to inconsistent reads by the application. To avoid lag, one could

Direct all traffic to master to reduce load on replicas allowing them to catch up
Spin up a beefier Read replica before the DDL and drop lagging replicas

Always monitor your application and database during these updates with respective alerts setup. CPU is the only host metric that will be throttled. Breaching memory and disk space limits will result in node termination and irrecoverable application degradation, respectively.

References:

What is a CDN?
Read Replicas
Django’s Multi database router

#databases #replication #metrics #django #cdn

29 views

Archive
Recommendations
Privacy
Terms

Sitemap RSS