Setting Up MySQL Master-Master Replication for High Availability
Network Connectivity Requirements
Ensure bidirectional network commuincation between cluster nodes using ping utility.
C:\Users\administrator>ping 192.168.100.91
Pinging 192.168.100.91 with 32 bytes of data:
Reply from 192.168.100.91: bytes=32 time=2ms TTL=64
Reply from 192.168.100.91: bytes=32 time=1ms TTL=64
Reply from 192.168.100.91: byt ...
Posted on Fri, 18 Sep 2026 16:42:44 +0000 by kaumilpatel
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