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.

BinlogCanalDatabase Replication
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.

CanalDatabase ReplicationUDF
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.

BinlogCanalDatabase Replication
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
Architecture Digest
Architecture Digest
Mar 18, 2021 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache: Trigger + UDF and Binlog Parsing (Canal)

The article explains two technical methods for keeping MySQL and Redis in sync—using MySQL triggers with a custom UDF to write directly to Redis, and parsing MySQL binlog streams (or using Alibaba's Canal) to propagate changes, while discussing their suitable scenarios, challenges, and implementation details.

BinlogCanalDatabase Replication
0 likes · 5 min read
Two Approaches to Synchronize MySQL Data with Redis Cache: Trigger + UDF and Binlog Parsing (Canal)
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 Evictioncache synchronization
0 likes · 13 min read
Why Design Caches? Multi‑Level Cache Strategies, Synchronization Schemes, and Common Pitfalls