Mar 28, 2016 · Backend Development

How to Keep Cache and Database Consistent: Invalidate First, Serialize Access

This article explains why cache and database can become inconsistent in distributed systems, why the "invalidate‑cache‑then‑write‑DB" rule is preferred, and presents practical serialization techniques—modifying DB and service connection pools—to guarantee per‑key sequential execution while maintaining availability and load balance.

CacheConnection Poolbackend-architecture

0 likes · 11 min read

How to Keep Cache and Database Consistent: Invalidate First, Serialize Access

21CTO

Sep 25, 2015 · Backend Development

Building a High‑Performance Asynchronous MySQL Proxy with Swoole

This article explains how to create an asynchronous MySQL proxy server using the Swoole extension, detailing connection pooling, idle/busy management, request queuing, and providing a complete PHP implementation that reduces MySQL load and network overhead for PHP applications.

AsynchronousBackend DevelopmentConnection Pool

0 likes · 6 min read

Building a High‑Performance Asynchronous MySQL Proxy with Swoole