.NET Architecture & System Design Interview Question #69

What is polyglot persistence?

Database Scaling, Partitioning, NoSQL & Data Consistency Mid-Level Intermediate

Quick Interview Answer

Polyglot persistence means using different data-storage technologies within one system because different workloads have different requirements.

Detailed Explanation

Polyglot persistence means using different data-storage technologies within one system because different workloads have different requirements.

For example, transactional orders may use SQL Server, distributed caching may use Redis, and search may use a dedicated search engine. The benefit is workload fit; the cost is more operational complexity, skills, monitoring, backups, and consistency management.

Code Example

Orders -> SQL Server
Cache  -> Redis
Search -> Search engine
Files  -> Object storage