System Design Examples

Question 1

Cassandra

Answer 1

• Apache
• Distributed
• wide-column store - allows name and format of columns to change
• blend of tabular and key-value
• easy replication
• multiple masters
• NoSQL database
• Uses CQL (SQL-like)

Question 2

MongoDB

Answer 2

• JSON-like documents
• schema free
• single master, some downtime when handling backups
• more setup for replication

Question 3

MySQL

Answer 3

• relational database (SQL)
• highly vertically scalable
• horizontally scalable with configuration