End-to-End Data Consistency Verification for MySQL in DTS

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

End-to-End Data Consistency Verification for MySQL in DTS

Aikesheng Open Source Community

Jul 12, 2021 · Databases

Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL

The article explains how to improve indexing of long string columns in MySQL by using generated columns with CRC32/MD5 hashes, functional indexes introduced in MySQL 8.0.13, and prefix indexes, providing code examples and performance considerations.

CRC32Function IndexPrefix Index

0 likes · 4 min read

Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL

Python Programming Learning Circle

May 30, 2020 · Backend Development

Analyzing Bilibili Comment API and Building a Search Tool

This article describes how to discover Bilibili's comment XML APIs, decode the embedded CRC32‑hashed user IDs, choose an appropriate database schema, and implement a Python‑PHP tool that retrieves, filters, and displays comments based on video CID and keyword.

APIBilibiliCRC32

0 likes · 6 min read