advancedTop 15 System Design Questions

Design a logging and analytics system for 1TB of logs per day.

Ingestion: Kafka as durable buffer; handles burst traffic Storage: Cassandra for time-series raw logs (high write, TTL for retention) Aggregation: Spark Streaming on Kafka → pre-aggregate to Cassandra summary tables Search: Elasticsearch for full-text log search (last 7 days) Redis: real-time counters (errors per minute), alerting thresholds MongoDB: stored queries, dashboard configs, alert rules

Ready to master this question?

Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.

Sign in to generate a response

Next Step

Continue to Design a notification system for a large-scale application (100M users).← Back to all NoSQL questions