25 editable reference diagrams
Databases Architecture Diagrams
Compare database architecture patterns for transactional storage, caching, replication, partitioning and analytical access. These diagrams distinguish where applications write, where they read and which component decides a failover.
Start with access patterns and consistency requirements. A replica is not automatically a backup, and a cache is not automatically authoritative. Identify the write owner, replication lag, connection behavior and tested restore path before increasing topology complexity.
Choose a diagram for your design question
Open a reference to inspect its component flow and trade-offs, then adapt it in the browser-local editor. Manual editing does not require login; AI generation and account storage do.

PostgreSQL application architecture
Manage connection and transaction budgets.
6 components · 5 connections
Explore postgresql application architecture →
PostgreSQL replication architecture
Account for replica lag in reads.
5 components · 4 connections
Explore postgresql replication architecture →
PostgreSQL high availability architecture
Fence an old primary before promoting writes.
6 components · 5 connections
Explore postgresql high availability architecture →
MySQL replication architecture
Verify replication position during failover.
7 components · 5 connections
Explore mysql replication architecture →
MongoDB architecture
Choose document boundaries and shard keys carefully.
5 components · 4 connections
Explore mongodb architecture →
MongoDB sharding architecture
Avoid concentrating traffic on one shard key.
6 components · 5 connections
Explore mongodb sharding architecture →
Cassandra architecture
Consistency depends on replication and quorum choices.
7 components · 6 connections
Explore cassandra architecture →
CockroachDB distributed SQL architecture
Key placement influences distributed transaction cost.
6 components · 5 connections
Explore cockroachdb distributed sql architecture →
Redis caching architecture
Define invalidation before trusting cached reads.
6 components · 5 connections
Explore redis caching architecture →
Redis cluster architecture
Plan slot migration and failover behavior.
6 components · 5 connections
Explore redis cluster architecture →
Elasticsearch architecture
Shard sizing affects recovery and query cost.
7 components · 5 connections
Explore elasticsearch architecture →
OpenSearch cluster architecture
Set retention and shard recovery policies.
8 components · 6 connections
Explore opensearch cluster architecture →
ClickHouse analytics architecture
Choose partition and sort keys from query patterns.
6 components · 5 connections
Explore clickhouse analytics architecture →
Snowflake data warehouse architecture
Compute isolation does not replace data governance.
6 components · 5 connections
Explore snowflake data warehouse architecture →
Databricks lakehouse architecture
Align catalog permissions with storage access.
6 components · 5 connections
Explore databricks lakehouse architecture →
Delta Lake architecture
Readers need a consistent table version.
6 components · 5 connections
Explore delta lake architecture →
Apache Iceberg architecture
Catalog commits determine visible table snapshots.
6 components · 6 connections
Explore apache iceberg architecture →
Apache Hudi architecture
Balance ingestion speed against query merging cost.
7 components · 5 connections
Explore apache hudi architecture →
Object storage architecture
Object semantics differ from filesystem operations.
6 components · 5 connections
Explore object storage architecture →
Distributed file storage architecture
Protect metadata as well as file chunks.
5 components · 4 connections
Explore distributed file storage architecture →
Database sharding architecture
Choose keys that distribute real workload.
6 components · 5 connections
Explore database sharding architecture →
Database connection pooling architecture
Too many pooled connections can still overload storage.
5 components · 4 connections
Explore database connection pooling architecture →
Read replica routing architecture
Route consistency-sensitive reads deliberately.
5 components · 4 connections
Explore read replica routing architecture →
Cache aside architecture
Handle concurrent misses without stampeding storage.
5 components · 5 connections
Explore cache aside architecture →
Write through cache architecture
Define the failure order of dual writes.
5 components · 4 connections
Explore write through cache architecture →