System Design - Template

1. Database (SQL, NoSQL)

  1. Design (DDL).

  2. Storage.

  3. Query: Index

  4. Locking: Concurency.

2. Caching

  1. Design (DDL).

  2. Storage.

  3. Query: Index

  4. Locking: Concurency.

3. Message Queue

  1. Design (DDL).

  2. Storage.

  3. Query: Index

  4. Locking: Concurency.

4. ElasticSearch

  1. Design (DDL).

  2. Storage.

  3. Query: Index

  4. Locking: Concurency.

5. Distributed Communication

  1. API Gateway.

  2. Distributed ID.

  3. Distributed lock.

  4. Distributed transaction.

  5. ZooKeeper

6. Security Storage

  1. Authenticate/Authorization.

  2. Data Encryption.

7. Performance

  1. CDN

  2. Load Balancing.

  3. Caching.

  4. Message Queue.

  5. Database optimization.

8. High availability

  1. Circuit breaker.

  2. Replication.

  3. Timeout/Retry/Back pressure.

Last Updated On October 28, 2025