Compare Scenarios

Migration Step 1

Both scenarios define a migration step at this stage. Realtime Collaborative Editor: triggered by 'User-visible edit conflicts > 5% of sessions; poll interval '. E-Commerce Order Platform: triggered by 'Payment provider timeout causing full checkout rollback and '.

Migration Step 2

Both scenarios define a migration step at this stage. Realtime Collaborative Editor: triggered by 'Data loss complaints from users editing simultaneously; conf'. E-Commerce Order Platform: triggered by 'Product search p99 > 1s; faceted navigation (category + pric'.

Migration Step 3

E-Commerce Order Platform has a defined migration; Realtime Collaborative Editor does not at this stage.

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 .

PostgreSQL pg_locks showing high RowExclusiveLock contention on inventory_items for specific sku_ids; checkout p99 > 2s for contended SKUs; deadlock errors appearing in application logs during sale events; effective checkout throughput for hot SKUs well below per-request checkout latency would predict

Tier 1: Flash Sale Inventory Contention: Concurrent saga checkout attempts competing for the same inventory row via row-level locking. Recommended evolution: Introduce a per-SKU checkout serialization queue at the application layer : all concurrent checkout requests for the same SKU are queued and processed serially, converting lock contention into queue latency. Alternatively, use PostgreSQL advisory locks with non-blocking trylock: requests that cannot acquire the lock immediately return a "sold out" response rather than queuing. For very high flash sale volumes, pre-allocate inventory slots (reserve N slots per sale event, each slot is a row with one reservation) to spread lock contention across N rows instead of one. .

Checkout p99 tracking payment provider p99 almost linearly; connection pool utilization on the payment service rising during payment provider slowdowns; circuit breaker trip events appearing in payment service metrics; saga timeout events correlated with payment provider latency spikes

Tier 2: Payment Provider Latency Amplifying Checkout Latency: Checkout saga holding a database connection and an inventory reservation open for the duration of the payment provider call: payment latency directly amplifies connection pool pressure. Recommended evolution: Decouple the payment step from the synchronous checkout saga: reserve inventory and create the order record synchronously, then process payment asynchronously. The customer receives an "order confirmed, payment processing" state immediately; the payment step runs as a separate saga step triggered by an event. This reduces the synchronous checkout latency to the inventory reservation time, not the payment provider round-trip time. .