Implementing Read-Write Splitting with Mycat Middleware for One-Master-One-Slave and Two-Master-Two-Slave Topologies

This document provides a detailed introduction to how to build a MySQL master-slave cluster using Mycat, along with testing for load balancing and high availability. The following is a summary of the main content: ### I. Environment Preparation 1. **Install the Server**: MyCat, version 2.0, has been installed. 2. **Install the Client**: MySQL-8.0.17 has been installed. 3. **Configuration File Check**: The configurations of `conf/mycat-server.xml` and `schema-mysql.sql` were checked and confirmed.

Read More