Implementing Read-Write Splitting with Mycat Middleware for One-Master-One-Slave and Two-Master-Two-Slave Topologies
2018-07-07
248 views
后端
Mycat
Master-Slave Replication
Read-Write Splitting
one master, one slave
Dual Master and Dual Slave
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