Design a Database Connection Pool · System Design Interview

Design a Database Connection PoolDesign the pool an application uses to share a small number of database connections between a much larger number of concurrent requests.What it has to do

A request borrows a connection, uses it, and returns it

A request that finds none free waits rather than opening its own

A connection that has broken is not handed to the next borrower

Scale

Application instances: 800

Concurrent requests per instance: up to 2,000

Out of scope

The database itself

Query optimisation

Read-replica routing

The ORM

Practise this challengeAll system design challenges

LetsDiscuss

Loading your session…