# @thatcodergirlie on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DSCvvEYkVcZ
- **Gondola URL:** https://gondola.cc/posts/61414785-thatcodergirlie-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/7a40ec8f70.jpg
- **Posted:** 2025-12-09T12:35:32.000+00:00
- **Account Owner:** Ayushi Sharma | Coding | Software Engineer (@thatcodergirlie) — https://gondola.cc/thatcodergirlie

## Caption

Comment “DB” and I’ll share the Strategies for Scaling databases medium article in your DM 🙌🏻

Save & Share with your friends to help them in their u upcoming interviews 🤝🏻

———————————————————————————

First, you’ll stabilise the system immediately:

1. Apply rate limiting / throttling on expensive APIs so the DB isn’t hammered by sudden spikes.

2. Temporarily disable non-critical features & background jobs (reports, heavy analytics, cron queries) to free DB capacity for core flows (checkout, payments, login).

3. Push as much as possible to cache (Redis) – hot reads like product details, inventory, homepage, user profile → from cache, not DB.

4. Move reads to replicas if available (read–replica setup) so primary handles mostly writes.

5. Check slow queries & kill obviously bad ones (full table scans, missing filters, ad-hoc reports) to quickly drop CPU.

Finally you can say:

“Once the system is stable, I’ll profile the slow queries, add proper indexes, enforce pagination, and plan capacity (read replicas / sharding) so this doesn’t happen in the next sale.” ✅

{ data structures, algorithms, coding, tech, interviews, tech interviews, data structures and algorithms, google, Microsoft, Amazon, uber, software engineer, coding life, work life balance, code, java, learning, upskilling, career, job, opportunities, system design, low level system design, high level system design, HLD, LLD, roadmap, system design roadmap, scalable systems, databases, caching, redis}

#coding #softwaredeveloper #softwareengineer #datastructure #codinglife #systemdesign #datastructuresandalgorithms #softwareengineering #algorithms #interviewpreparation #codinginterview #microsoft #scalablesystems #databases #chatgpt #engineering #caching #amazon #flipkart #computerscience #computerengineering #codingisfun #jobs #hld #lld  #opportunity #interviewtips #interviewprep

## Stats

- **Views:** 17,465
- **Likes:** 485
- **Shares:** 0
- **Comments:** 335

## Tags

codinglife, chatgpt, algorithms, softwareengineering, engineering, flipkart, scalablesystems, microsoft, amazon, softwaredeveloper, lld, databases, caching, softwareengineer, hld, datastructure, computerscience, interviewtips, interviewprep, codinginterview, opportunity, computerengineering, datastructuresandalgorithms, interviewpreparation, codingisfun, coding, jobs, systemdesign

---
Copyright (c) Gondola