Database Sharding and User Registration Implementation for a Train Booking System
User Table Structure
The original table structure is designed as follows. Due to the large user base, database sharding becomes necessary.
Sharding Strategy Design
Based on the system design assumptions, the 12306 system needs to support approximately 1 billion registered users, with roughly 10 million new users annually. Before implementing da ...
Posted on Sat, 20 Jun 2026 16:47:10 +0000 by ari_aaron
Understanding and Implementing ShardingSphere-JDBC for Distributed Databases
When discussing distributed database middleware, Apache ShardingSphere-JDBC is a prominent solution. This guide delves into its core concepts and practical applications.
The ShardingSphere Ecosystem
Apache ShardingSphere is a robust distributed database ecosystem comprising two primary products:
ShardingSphere-Proxy: Positioned as a transpare ...
Posted on Wed, 17 Jun 2026 16:05:16 +0000 by yobo