Articles tagged "Mycat"

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

2018-07-07 223 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.

Installing and Using Mycat for Distributed Database on CentOS

2018-06-30 192 views 后端 Mycat MySQL Distributed Database Sharded Storage CentOS

This article provides a detailed introduction to how to install and configure Mycat in a CentOS environment to achieve basic operations of distributed databases. Below is a summary of the content in the article, along with some possible missing information or steps supplemented. ### I. Environment Preparation 1. **System Requirements**: Ensure that a Java environment (e.g., JDK8) is installed. 2. **Network Configuration**: - Open the firewall and configure rules to allow the service ports of MySQL and Mycat to pass through. - Ensure that the network connections between all nodes are smooth.