Deployment Architecture for MyCAT Database and Table Partitioning

In the database and table partitioning scheme, different service tables (app1-customers, app2-orders, and app3-salary) are stored in different databases (dn1, dn2, and dn3) based on service requirements. MyCAT intercepts SQL statements sent from app1, app2, and app3 and parses the SQL statements, for example, sharding parsing, route parsing, and read/write splitting parsing. Then, the SQL statements are sent to the corresponding database for processing, and the result is returned to the end user. MyCAT is used as the database middleware. Applications only need to connect to the MyCAT layer, and MyCAT performs routing and distribution. Web applications do not need to configure database connections for each application.

Figure 1 Deployment architecture for MyCAT database and table partitioning