Deployment Architecture of MyCAT Database Sharding

Data sharding is to divide data in a table into multiple shards. Each shard has the same schema and columns, but also entirely different rows. Such shards are logical shards, which are distributed on a separate database node. Database nodes are physical shards. One physical shard accommodates a plurality of logical shards. Database sharding helps to facilitate horizontal scaling, which means you can add more hosts and storage nodes to a distributed database to enhance its storage and computing capabilities. MyCAT provides multiple sharding rules, for example, MyCAT distributes data to different databases based on a modulo operation on a specific column and based on a specific range.

Figure 1 Deployment architecture of MyCAT database sharding