Pulkit Gupta

Detailed explanation of database replication, covering its necessity, types of algorithms (Single Leader, Multi-Leader, Leaderless), and strategies like synchronous and asynchronous replication, including handling node outages.

A continuation of database replication, focusing on multi-leader replication, its advantages, real-world scenarios (e.g., Google Calendar), and issues like write conflicts and their solutions (avoidance vs. detection).

Exploration of database sharding and partitioning, its necessity for large datasets and performance, and different algorithms like Partition by Key Range and Partition by the Hash of Key, discussing their pros and cons.

Discusses the importance of database transactions and the ACID properties (Atomicity, Consistency, Isolation, Durability), illustrating them with real-world scenarios and addressing single-object vs. multi-object operations.

Delves into transaction isolation levels (Read Committed, Repeatable Read, Serializable) and their impact on concurrency control, including the challenges of race conditions and how different databases implement isolation.