Oct 23, 2022 · Databases

Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It

After a write to the MySQL master, reads from a slave can return old or missing data due to replication lag, and this article explains the underlying asynchronous replication mechanisms, the involved threads, and presents practical solutions such as forcing master reads, delay detection, semi‑sync mode, GTID waiting, and middleware implementations like Sharding‑JDBC, MyCat, and MaxScale.

GTIDLagRead-Write Split

0 likes · 11 min read

Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It

dbaplus Community

Sep 17, 2022 · Databases

Choosing the Right Redis Deployment: Features, Architectures, and Best Practices

This article examines Redis 6.0 and 5.0 new features, compares various deployment architectures—including master‑replica, cluster, and read/write‑split—and provides practical guidance, code examples, and performance considerations to help engineers select the optimal Redis setup for production environments.

ClusterDatabase ArchitectureMaster-Replica

0 likes · 12 min read

Choosing the Right Redis Deployment: Features, Architectures, and Best Practices