System Design Interview

The system design interview is an open-ended conversation. So as a candidate, we need to follow well-defined steps to solve system design questions: 1) Requirements clarifications 2) Capacity estimation 3) Database design 4) Creating high-level design 5) Designing core components 6) Scaling the design 7) Resolving key bottlenecks.

Whether NoSQL or SQL databases are more appropriate for a given use case depends on a variety of factors, including the nature of the data, the application requirements, and the available resources and expertise. In this blog, we will discuss the key differences between SQL and NoSQL databases that software developers must consider when making a decision.

The concept of database replication has evolved significantly in the last two decades due to the increasing use of distributed databases instead of databases with just a single node. In this blog, we will discuss the definition, types, advantages, disadvantages, and various tradeoffs related to database replication in distributed systems.

In database replication, master-slave replication is also known as active/passive or leader-based replication. There are two types of nodes in this architecture: Master and slave. The single master (leader) node works as the primary database, while one or more slave (follower) nodes maintain copies of the Master’s data.

Pastebin is a online content hosting service where users can store and share content in the form of text or images over the internet by generating a unique URL so that anyone can access the content via that URL. Users can also update the content if they are logged in. This blog will focus on pastebin system design and discussion around various components.

Hadoop is an open-source framework that addresses the analytical and operational needs of Big Data by overcoming the limitations of traditional data analysis methods. With support for highly scalable and fault-tolerant distributed file systems, it allows for parallel processing. It comprises four main components - HDFS, YARN, MapReduce, and Hadoop Common.