This article presents a step‑by‑step practice of migrating massive billing data to 32 sharded databases with Sharding‑Proxy, covering background, objectives, four migration solutions, detailed proxy installation and configuration, debugging, migration workflow, data validation, common issues and their resolutions.
This talk walks through Sharding-Proxy’s role within Apache ShardingSphere, detailing its architecture, SQL lifecycle from protocol decoding to routing, rewriting, execution, and result merging, while highlighting core principles, performance bottlenecks, and practical optimization techniques for high‑throughput, low‑latency database proxying.
This article provides a comprehensive technical overview of Sharding-Proxy, covering its transparent MySQL‑protocol design, internal architecture, PreparedStatement optimization, HikariCP tuning, result‑set streaming, memory‑strict and connection‑strict modes, and practical configuration tips for high‑performance database proxying.
