Tag

Cache Synchronization

1 views collected around this technical thread.

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.

Cache SynchronizationCanalDatabase Replication
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.

Cache SynchronizationCanalDatabase Replication
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
IT Xianyu
IT Xianyu
Jun 2, 2021 · Databases

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

This article explains two methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers combined with a UDF function and parsing MySQL binlog via Alibaba's Canal—detailing their principles, implementation steps, advantages, limitations, and practical deployment considerations.

Cache SynchronizationCanalDatabase Replication
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data to Redis Cache: UDF Trigger and Binlog Parsing (Canal)
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.

Cache SynchronizationCanalDatabase Replication
0 likes · 5 min read
Two Approaches to Synchronize MySQL Data with Redis Cache: Trigger + UDF and Binlog Parsing (Canal)
Top Architect
Top Architect
Mar 15, 2021 · Databases

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

This article explains two technical methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers combined with a UDF function and parsing MySQL binary logs (with Canal)—detailing their workflows, advantages, limitations, and implementation considerations.

Cache SynchronizationCanalDatabase Replication
0 likes · 6 min read
Two Approaches to Synchronize MySQL with Redis Cache: UDF Trigger 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.

Cache EvictionCache Synchronizationbackend performance
0 likes · 13 min read
Why Design Caches? Multi‑Level Cache Strategies, Synchronization Schemes, and Common Pitfalls