Tagged articles
Database Synchronization
10 articles · Page 1 of 1
The article introduces ActionOMS, a customized version of OceanBase Migration Service that adds automated performance and fault diagnosis, explains its architecture, showcases a real‑world case of Oracle‑to‑OceanBase synchronization, and demonstrates how the tool improves migration throughput and reduces latency.
ActionOMSDatabase SynchronizationOceanBase
0 likes · 11 min read

The Vivo Internet Storage R&D team's article describes an end‑to‑end MySQL data‑consistency verification tool for DTS that uses fixed‑size chunking and CRC32/MD5 fingerprint aggregation to quickly compare source and target tables, pinpoint mismatched rows, and enable automated or manual correction while minimizing impact on replication.
CRC32DTSDatabase Synchronization
0 likes · 13 min read

This article explains why cache‑DB consistency is a long‑standing challenge, compares naive full‑load and delete‑cache approaches, analyzes concurrency and failure scenarios, and presents reliable solutions such as updating the database first followed by cache deletion using message queues or binlog subscriptions.
Cache ConsistencyDatabase SynchronizationRedis
0 likes · 19 min read

This article examines data consistency between Redis cache and MySQL database, explains common cache execution strategies such as Cache‑Aside, Read‑Through, Write‑Through, and Write‑Behind, analyzes four update sequences for consistency risks, and proposes solutions like delayed double‑delete, transactional guarantees, retry mechanisms, and binlog‑based cache invalidation.
Cache AsideCache ConsistencyDatabase Synchronization
0 likes · 18 min read

This article explores common misconceptions and practical strategies—including write ordering, delayed double‑delete, retry mechanisms, and scheduled cleanup jobs—to ensure reliable dual‑write consistency between MongoDB and traditional relational databases.
BackendData ConsistencyDatabase Synchronization
0 likes · 10 min read

This article provides a step‑by‑step tutorial on deploying a DBLE cluster, configuring sharding.xml, db.xml and user.xml, creating test tables, installing DTLE, performing full MySQL‑to‑DBLE data migration, then switching to GTID‑based incremental synchronization with detailed troubleshooting tips and best‑practice recommendations.
DBLEDTLEDatabase Synchronization
0 likes · 15 min read

This article shares practical experience with TiDB Data Migration (DM), covering its background, architecture, key features, online DDL support, common error handling such as duplicate‑key issues, large‑scale import tuning, configuration limits, and cleanup recommendations for reliable MySQL‑to‑TiDB synchronization.
DMDatabase SynchronizationPerformance Tuning
0 likes · 16 min read

This article introduces ClickHouse, a column‑store OLAP database, explains its advantages over row‑store systems, guides installation on macOS, details migration strategies from MySQL, presents performance benchmarks showing 200‑fold speedups, and discusses synchronization methods, pitfalls, and practical tips.
ClickHouseColumnar DatabaseDatabase Synchronization
0 likes · 6 min read

This article describes how a testing team replaced manual SQL updates with an automated solution using Alibaba's open‑source DataX framework and a custom QDataManager system to synchronize baseline database tables across multiple test environments, improving efficiency and reliability.
Configuration ManagementDataXDatabase Synchronization
0 likes · 6 min read

This article chronicles the development, design decisions, and technical achievements of Alibaba's Data Replication Center (DRC), a real‑time heterogeneous database synchronization platform that has become a core infrastructure for multi‑active data centers, large‑scale e‑commerce, and cloud services.
AlibabaDRCDatabase Synchronization
0 likes · 19 min read
