Storage Tier Topology
Data & State Architecture (MySQL + Redis)
Dual storage tier topology delineating MySQL relational persistence from Redis ephemeral realtime session and caching tiers.
Dual Storage Tier Architecture: MySQL ACID & Redis Ephemeral
Interactive ArchitectureDual Storage Tier Architecture · MySQL + Redis (Reference Pattern)
Architectural separation between in-memory realtime session state and relational persistence for player records and transaction history.
Reference Implementation Pattern
STORAGE TIER SPECIFICATION
Consistency: Single-threadedRedis In-Memory State Tier — Domain Responsibilities
Assigned Data Domains & Entities
Session State Caching (Proposed)
Ephemeral Match Presence (Proposed)
In-Memory State & Timers (Proposed)
Rate Limiting Counters (Proposed)
Persistence & Recovery SLA
In-Memory state; non-critical session state discardable on reboot.
Concurrency & Transaction Isolation
Single-threaded key-level operations.
Pillar 01
Redis Ephemeral State Tier
In-memory session state, presence indicators, and rate limiter counters (Proposed).
Pillar 02
MySQL Relational Data Tier
Permanent user accounts, three-balance movement records, and match history.
Pillar 03
State Separation Protocol
Clean boundary separating persistent account data from ephemeral session memory.
Dual-Tier Storage Architecture Highlights
- ACID transactional integrity for balance movement records in MySQL
- Redis key expiration with TTLs for active game rooms
- Continuous replication and relational recovery practices