System Design 2/3

Here's a chance to power up your professional life as a software developer. Don't miss out on our latest blogs. Subscribe to our Newsletter today!

How does database sharding work in SQL server? Explained with examples

Gourav Dhar

Jan 9, 20235 min read

SYSTEM DESIGN

How does database sharding work in SQL server? Explained with examples

The literal meaning of shard means "a small part of something big". Sharding is the process of dividing a whole into smaller parts.

Is the Load Balancer a Reverse Proxy? Reverse Proxy vs Load Balancer

Gourav Dhar

Jan 6, 20234 min read

SYSTEM DESIGN

Is the Load Balancer a Reverse Proxy? Reverse Proxy vs Load Balancer

Load Balancers and Reverse Proxies, both are components that can be used in a typical system architecture.

Database Sharding vs Partitioning - What are the differences

Gourav Dhar

Jan 4, 20234 min read

SYSTEM DESIGN

Database Sharding vs Partitioning - What are the differences

Database sharding splits a database server into multiple smaller data stores.

Can the load balancer be a single point of failure?

Gourav Dhar

Dec 19, 20225 min read

SYSTEM DESIGN

Can the load balancer be a single point of failure?

A single point of failure is a problem that can bring down an entire system or network. It can be caused by hardware, software, human error,

What is the CAP theorem? Is the CAP theorem still valid?

Gourav Dhar

Dec 12, 20224 min read

SYSTEM DESIGN

What is the CAP theorem? Is the CAP theorem still valid?

The CAP theorem states that a distributed database system cannot simultaneously provide consistency, availability, and partition tolerance.

What is a CDN (Content Delivery Network)? How does CDN work and where is it used?

Gourav Dhar

Nov 28, 202212 min read

BACKEND DEVELOPMENT SERIES

What is a CDN (Content Delivery Network)? How does CDN work and where is it used?

A CDN or Content Delivery Network is a network of servers that work together to deliver content faster to end-users.

How Database Indexing Makes Your Query Faster in a Relational Database - The Complete Guide

Gourav Dhar

Nov 22, 202212 min read

BACKEND DEVELOPMENT SERIES

How Database Indexing Makes Your Query Faster in a Relational Database - The Complete Guide

A database index is a data structure that improves the performance of database queries by making them faster.

What is an SSL/TLS Certificate and How do they Secure Your Website? - Backend Development Series

Gourav Dhar

Nov 14, 202212 min read

BACKEND DEVELOPMENT SERIES

What is an SSL/TLS Certificate and How do they Secure Your Website? - Backend Development Series

Why is it safe to give your personal information on one website and not another? What makes one website safer and more secure than another?

What is OSI Model? 7 layers of the OSI Model Explained (2023)

Gourav Dhar

Nov 7, 202211 min read

BACKEND DEVELOPMENT SERIES

What is OSI Model? 7 layers of the OSI Model Explained (2023)

OSI stands for Open Systems Interconnection. It can be defined as a conceptual framework that maps the various functions of a comm ...

What are WebSockets? Everything you need to know about WebSockets! (2023)

Gourav Dhar

Oct 31, 20228 min read

BACKEND DEVELOPMENT SERIES

What are WebSockets? Everything you need to know about WebSockets! (2023)

If you are someone who wants to explore WebSockets and how they work, or if you are planning to use

Categories

Quick Links