BestHub
Sign in
Su San Talks Tech
Su San Talks Tech
Dec 11, 2025 · Databases

How to Scale a 900 M‑Row Message Table to 60 B Rows Without Downtime

This article details a comprehensive sharding strategy for a high‑traffic message table, explaining why early partitioning is essential, how to design language‑based vertical shards combined with hash‑based horizontal shards, calculate table counts and virtual nodes, and execute a zero‑downtime migration using dual‑writes and gradual traffic rollout.

MySQLPerformance optimizationhorizontal partitioning
0 likes · 16 min read
How to Scale a 900 M‑Row Message Table to 60 B Rows Without Downtime
Tech Freedom Circle
Tech Freedom Circle
Nov 28, 2025 · Databases

How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)

The article analyzes a JD interview question on scaling a MySQL order table from 100 million to billions of rows, detailing four practical expansion strategies—stop‑service migration, double‑write migration, ShardingSphere middleware, and dual‑VIP routing—each with step‑by‑step procedures, code samples, risk assessments, and validation methods to enable near‑instant capacity growth without service interruption.

MySQLShardingSpheredatabase scaling
0 likes · 42 min read
How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)
Architecture Digest
Architecture Digest
Apr 18, 2022 · Operations

Zero‑Downtime Migration of 2000 Microservices to a Multi‑Cluster Managed Kafka at Wix

This article details how Wix migrated its 2000 microservices from a self‑hosted Kafka cluster to a multi‑cluster Confluent Cloud setup with zero downtime, describing the design decisions, partitioning strategy, Greyhound SDK usage, replication service, migration orchestrator, and best‑practice recommendations.

Confluent CloudGreyhound SDKKafka
0 likes · 17 min read
Zero‑Downtime Migration of 2000 Microservices to a Multi‑Cluster Managed Kafka at Wix