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 MoreImplementing MySQL Database Master-Slave Replication
This document provides a detailed introduction to how to configure Master-Slave Replication in MySQL database, accompanied by configuration steps and simple test cases. The key points summarized are as follows: ### Configuration Steps #### 1. Select servers as master and slave - Choose one MySQL server as the master and another as the slave. #### 2. Setup on the master server - First, add the following configurations to the master's `/etc/my.cnf` or `my.ini` configuration file:
Read More