Hard Design: Chat System (WhatsApp/Slack)

What Cassandra partition key design supports efficient message retrieval for a conversation?

— Tests your understanding of this concept.

Answer Options

A Partition by user_id

B Partition by message_id

C Partition by conversation_id, cluster by message_id

D Partition by date, cluster by conversation_id

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 22+ more Design: Chat System (WhatsApp/Slack) questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Design: Chat System (WhatsApp/Slack) topic (System Design Cases).

Learn Design: Chat System (WhatsApp/Slack) → Browse All Questions

More Design: Chat System (WhatsApp/Slack) Questions

Why is WebSocket preferred over HTTP for a chat application?

Alice is connected to Chat Server 1. Bob is connected to Chat Server 2. Alice sends Bob a message. How is it delivered?

Why is Cassandra chosen for message storage over PostgreSQL?

A chat server crashes while 50,000 users are connected. What happens to their messages and connections?

What does 'delivered' status mean vs 'read' status in WhatsApp?