Configuring MyCAT Cluster with Dual Masters and Dual Slaves
Prerequisites
For MySQL master-slave setup, refer to: MySQL master-slave setup guide
For MyCAT installation, refer to: Installing MyCAT 2
Network and Service Configuration
IP/Port
Service
Role
8066
mycat
Proxy
3307
master
Primary
3308
slave
Replica
3309
master01
Standby
3310
slave01
Replica
Creating Database Users
On master, ...
Posted on Fri, 03 Jul 2026 17:15:52 +0000 by gintjack
Implementing Database Sharding and Read-Write Splitting with Mycat
Database Shardign Implementation
Mycat Installation and Configuration
Download Mycat from the official repository. For Linux environments, extract the package using:
tar -xvf Mycat-server-1.6.7.1-release-*.tar.gz
The extracted directory includes:
bin: executable scripts
conf: configuration files (schema.xml, server.xml, rule.xml)
lib: require ...
Posted on Thu, 04 Jun 2026 19:21:20 +0000 by visualed
Configuring MySQL Master-Slave Replication with MyCAT for Read-Write Splitting on Windows
Implementing a robust read-write splitting architecture can significantly enhance database performance and availability by distributing query loads across multiple servers. This setup ensures that write operations are hendled by a dedicated primary server, while read requests are served by one or more secondary servers. This document outlines t ...
Posted on Thu, 21 May 2026 16:32:40 +0000 by raku