BestHub
Sign in
Architect's Guide
Architect's Guide
Jan 17, 2026 · Backend Development

How We Split a 500M‑Row MySQL Table: Lessons and Strategies

Facing a 50‑million‑row financial transaction table that grew 600,000 rows each month, the team designed a sharding solution using sharding‑jdbc, tackled multi‑datasource transaction and pagination challenges, and executed a staged migration that kept the system stable while eliminating MySQL performance bottlenecks.

Paginationdata-migrationsharding
0 likes · 13 min read
How We Split a 500M‑Row MySQL Table: Lessons and Strategies
Top Architect
Top Architect
Jul 19, 2024 · Databases

Design and Implementation of Database Table Sharding for a Loan Repayment System

The article details a real‑world backend engineering project where a loan repayment service is refactored to use table sharding with ShardingSphere, covering design decisions, table naming, sharding algorithms, historical data migration, dynamic switches, transaction management, code examples, and practical pitfalls.

MySQLbackenddata-migration
0 likes · 19 min read
Design and Implementation of Database Table Sharding for a Loan Repayment System
Architect's Tech Stack
Architect's Tech Stack
Jan 3, 2022 · Operations

Overview of Redis Monitoring, Data Migration, and Cluster Management Tools

This article introduces essential Redis operational tools, covering real‑time monitoring with the INFO command and exporters, data migration using Redis‑shake, consistency checking via Redis‑full‑check, and cluster management through CacheCloud, while highlighting key metrics such as stat, commandstat, cpu, and memory.

CacheCloudPrometheusdata-migration
0 likes · 10 min read
Overview of Redis Monitoring, Data Migration, and Cluster Management Tools