Compare Scenarios

Migration Step 1

Both scenarios define a migration step at this stage. API Gateway Platform: triggered by 'PostgreSQL hot path query p99 > 2ms under sustained request '. Realtime Collaborative Editor: triggered by 'User-visible edit conflicts > 5% of sessions; poll interval '.

Migration Step 2

Both scenarios define a migration step at this stage. API Gateway Platform: triggered by 'Rate limit enforcement allowing requests above the configure'. Realtime Collaborative Editor: triggered by 'Data loss complaints from users editing simultaneously; conf'.

Migration Step 3

API Gateway Platform has a defined migration; Realtime Collaborative Editor does not at this stage.

Redis command latency p99 > 0.5ms; gateway hot path p99 exceeding 2ms with Redis as the bottleneck (not upstream service); Redis CPU > 60% sustained; Lua script execution visible in SLOWLOG at > 0.1ms frequency

Tier 1: Redis Rate Limit Throughput: Single Redis instance processing all rate limit Lua scripts serially for all tenants across all gateway replicas. Recommended evolution: Shard rate limit counters across Redis Cluster nodes by hashing tenant_id to a cluster slot; this distributes Lua script execution across nodes proportional to tenant count; ensure tenant_id-keyed counters use hash tags ({tenant_id}) so all keys for a tenant land on the same slot and Lua scripts can operate on them atomically; do not use Redis Cluster without testing Lua script compatibility against your cluster topology first .

Tenant reports that rate limit increase takes > 30 seconds to take effect across all gateway replicas; configuration change audit log shows primary PostgreSQL write completing, but gateway replicas still routing to old backend endpoints beyond the expected cache TTL window

Tier 2: Configuration Propagation Latency: Local in-process cache TTL too long, or cache invalidation signal (Redis pub/sub or Kafka) not reaching all replicas. Recommended evolution: Implement configuration change notification via Redis pub/sub: PostgreSQL configuration writes also publish a config_invalidated event to a Redis channel; each gateway replica subscribes to this channel and flushes the affected local cache key on receipt; this reduces propagation latency from TTL duration to sub-second pub/sub delivery without eliminating the local cache that protects Redis from per-request configuration lookups .

Server memory growing with active connections; file descriptor limits approached; new WebSocket connections refused

Tier 1: WebSocket Connection Ceiling: WebSocket server process connection limit or OS file descriptor ceiling. Recommended evolution: Increase file descriptor limits (ulimit); move to dedicated WebSocket server tier; implement connection multiplexing (multiple documents per connection where safe) .

Consecutive writes to the same document causing lock contention; write latency rising; auto-save batching queue depth increasing

Tier 2: Database Write Contention: High-frequency auto-save operations conflicting at the document row level; row-level locking under concurrent user edits . Recommended evolution: Move to operational transformation or CRDT-based conflict resolution; batch writes and resolve conflicts in-process before database commit; consider append-only event log for document operations .