Storage Tier Topology
Data & State Architecture (MySQL + Redis)
Dual storage tier topology delineating MySQL transactional durability from Redis ephemeral match state and queue clusters.
Dual Storage Tier Architecture: MySQL ACID & Redis Ephemeral
Interactive ArchitectureDual Storage Tier Architecture · MySQL + Redis
Architectural separation between sub-millisecond in-memory match queues and ACID-compliant transactional financial ledgers.
Dual-Tier Storage Topology
STORAGE TIER SPECIFICATION
Consistency: Single-threadedRedis In-Memory Cluster — Domain Responsibilities
Assigned Data Domains & Entities
Active Matchmaking Queue Clusters
Live Room Socket Subscriptions
Ephemeral Match State & Timers
API Rate Limiter Token Buckets
Persistence & Recovery SLA
In-Memory with RDB snapshots; non-critical state discardable on cold reboot.
Concurrency & Transaction Isolation
Single-threaded event loop atomicity per key partition.
Pillar 01
Redis In-Memory Cluster
Sub-millisecond matchmaking queues, live socket rooms, and rate limiter buckets.
Pillar 02
MySQL ACID Transactional Store
Permanent user accounts, three-balance financial ledgers, and match audit logs.
Pillar 03
State Synchronization Protocol
Clean boundary ensuring no financial ledger data is stored in ephemeral memory.
Dual-Tier Storage Architecture Highlights
- Row-level locking for wallet balance mutations in MySQL
- Redis key partitioning with TTLs for active game rooms
- Point-in-time recovery and continuous WAL replication