Tagged articles
9 articles
Page 1 of 1
21CTO
21CTO
Apr 4, 2023 · Databases

How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained

This article compares two methods for synchronizing MySQL data with Redis cache—using MySQL triggers combined with a UDF function, and parsing MySQL binlog via tools like Canal—detailing their workflows, advantages, limitations, and implementation considerations.

Canalbinlogcache synchronization
0 likes · 6 min read
How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained
Top Architect
Top Architect
Mar 20, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers with a UDF function and parsing MySQL binlog streams—detailing their processes, advantages, limitations, and related open‑source tools like Canal.

CanalUDFcache synchronization
0 likes · 7 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
Java Architect Essentials
Java Architect Essentials
Mar 13, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two technical solutions for keeping MySQL data in sync with Redis cache—using a MySQL trigger with a UDF function and parsing MySQL binlog events—while also reviewing the Canal open‑source tool and discussing their trade‑offs and implementation details.

CanalRedisUDF
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
JD Tech
JD Tech
Jul 26, 2018 · Backend Development

Why Design Caches? Multi‑Level Cache Strategies, Synchronization Schemes, and Common Pitfalls

This article explains the motivation behind cache design, compares CPU and application‑level caches, discusses multi‑level and distributed caching, outlines synchronization methods, eviction policies, and answers frequent cache‑related questions to help reduce database load and improve system performance.

Backend PerformanceCache EvictionCaching
0 likes · 13 min read
Why Design Caches? Multi‑Level Cache Strategies, Synchronization Schemes, and Common Pitfalls