MyCAT Read/Write Splitting Architecture
Read/Write splitting means that read and write requests are distributed to different servers to reduce the pressure on the primary server. MyCAT does not provide the data synchronization function. The implementation of its read/write splitting relies on the primary-secondary replication scheme of MySQL.
Figure 1 MyCAT read/write splitting architecture
Parent topic: (Solution 3) MySQL Database Read/Write Splitting Scheme