BestHub
Sign in
Tagged articles

LOGICAL_CLOCK

5 articles · Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2026 · Databases

MySQL Replication Lag Soars to 10 seconds? Three Parallel‑Replication Tricks to Fix It

When MySQL replication latency jumps from milliseconds to 10 seconds, blindly raising replica_parallel_workers won’t help; the article walks through diagnosing the delay, then applies three concrete parallel‑replication optimizations—enabling WRITESET on the source, configuring LOGICAL_CLOCK with appropriate applier workers, and optionally preserving commit order—while showing the required SQL commands, monitoring queries, and rollback steps.

GTIDLOGICAL_CLOCKMySQL
0 likes · 21 min read
MySQL Replication Lag Soars to 10 seconds? Three Parallel‑Replication Tricks to Fix It
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
May 11, 2025 · Fundamentals

Why Unreliable Clocks Threaten Distributed Systems—and How to Fix Them

This article examines the unreliability of physical clocks in distributed systems, compares synchronous and asynchronous network timing, explains the roles of wall and monotonic clocks, and explores logical clocks, snapshot isolation, and practical solutions such as Google Spanner's TrueTime to ensure data consistency.

Data ConsistencyLOGICAL_CLOCKclock synchronization
0 likes · 11 min read
Why Unreliable Clocks Threaten Distributed Systems—and How to Fix Them
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
May 4, 2025 · Fundamentals

Why Unreliable Clocks Threaten Distributed Systems—and How to Fix Them

This article examines how unreliable physical clocks—both wall and monotonic—affect distributed systems, compares synchronous and asynchronous network timing, illustrates conflicts caused by timestamp drift, and presents logical clocks and Google’s TrueTime as robust solutions for achieving consistent ordering and data reliability.

LOGICAL_CLOCKTrueTimeclock synchronization
0 likes · 11 min read
Why Unreliable Clocks Threaten Distributed Systems—and How to Fix Them
dbaplus Community
dbaplus Community
Mar 22, 2020 · Backend Development

Designing Multi‑Data‑Center Redis Cache with Strong Consistency and Failover

This article walks through the evolution of a Redis‑based cache layer for multi‑data‑center deployments, addressing consistency, safety, performance, disk‑space, data loops, timestamp versioning, master‑slave failover, and global numeric aggregation, and culminates in a ready‑to‑use middleware solution.

Cache ConsistencyFailoverLOGICAL_CLOCK
0 likes · 19 min read
Designing Multi‑Data‑Center Redis Cache with Strong Consistency and Failover