Distributed SQL ACID Latency: TiDB, CockroachDB & Spanner

Prerequisite: Familiarity with the concepts introduced in Part 1 — Double Entry Ledger Schema. Review it first if the terminology in this part is unfamiliar. Answer-first: Distributed SQL engines preserve multi-region ACID serializability by combining Raft/Paxos consensus with bounded clock synchronization protocols such as Spanner TrueTime, CockroachDB HLC, or TiDB Percolator TSO. Selecting optimal commit-wait delays and timestamp allocation strategies minimizes two-phase commit overhead, achieving low transaction latencies across cross-region core banking nodes. Implementing this architecture enforces sub-50ms P99 latency guarantees, strict component isolation, and automated. ...

June 18, 2026 · 12 min · Lê Tuấn Anh

ISO 20022 pacs.008: Parse, Idempotency & Gateway Latency

Prerequisite: Familiarity with the concepts introduced in Part 4 — Saga Pattern. Review it first if the terminology in this part is unfamiliar. Answer-first: ISO 20022 MX messages (pacs.008, pacs.009, camt.053) replace legacy ISO 8583 text formats with structured XML/JSON schemas. Production payment gateways validate MX payloads, ensure idempotency, and translate ISO messages to internal ledger events. Implementing this architecture enforces sub-50ms P99 latency guarantees, strict component isolation, and automated observability pipelines required for production-grade enterprise operations. ...

June 18, 2026 · 13 min · Lê Tuấn Anh