Aug 15, 2024 · Databases

Architecture Upgrade Challenges and Atomic Write Solutions for Cloud-native Databases

Collaborating across TencentOS and database kernel teams, the article details how architecture upgrades—moving to TKE HouseKeeper, switching to AMD CPUs, and adding a portable 16 KB atomic‑write feature—combined with kernel optimizations like huge‑page support, NUMA‑aware qspinlocks, speculative page‑fault handling, and ORC unwinding to deliver up to 30 % mixed workload and over 100 % write‑only performance gains while reducing memory usage.

NUMAORC unwinderatomic write

0 likes · 16 min read

Architecture Upgrade Challenges and Atomic Write Solutions for Cloud-native Databases

JavaEdge

Aug 25, 2022 · Databases

How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS

The article explains why concurrent write transactions cause lost updates, then details practical solutions such as atomic update statements, explicit row‑level locking, automatic lost‑update detection, compare‑and‑swap (CAS) techniques, and special considerations for multi‑replica databases.

CASConcurrency Controlatomic write

0 likes · 8 min read

How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS