Programming VIP

  in this paper, we will introduce the operation of MyCat's sub database and sub table. Sub library table I. Introduction to segmentation rules       various segmentation rules supported by myCat are defined in rule.xml. Mod long Sharding by month Sharding by date Splitting by hour Range agreement: plan ...

One: MySQL master-slave configuration 1: MySQL master-slave backup 1.1: Master-slave backup concept What is master-slave backup: a database application of master-slave mode. Master data is identical with Slave data, which can realize multiple ...

There are two ways to subtable a database vertical partitioning A database consists of many tables, each of which corresponds to a different business. Vertical slicing refers to classifying tables by business and distributing them over different databases, thus sharing data or pressure among different libraries.Advantage: - Clear business an ...

> Original address: MyCAT Source Analysis: [Single Library Form] Query > MyCat-Server with annotated address: https://github.com/YunaiV/Mycat-Server > (vii) This series is updated every 1-2 weeks. You are welcome to subscribe, follow and collect GitHub: https://github.com/YunaiV/Blog 1. Overview 2. Receiving requests and parsing SQ ...

1.mycat Download Official website: http://mycat.org.cn/about.html 2. Create a mycat 1.6 directory and upload the mycat service package tar -zxvf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz 3. Configuration of server. XML <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mycat:server SYSTEM "server.dtd"> <mycat:se ...

Distributed MySql Deployment Scheme Solution System Environment mysql master-slave backup MyCat Middleware Build haproxy load agent keepalived for single point failure mycat-eye monitoring web Overall structure of experimental environment supplement Solution describe 1. Start mysql master-slave backup 2. Scheduling and routing using ...

Environmental Science 192.168.2.118 mysql-master/mycat 192.168.2.119 mysql-slave Configure jdk tar -zxf jdk-8u151-linux-i586.tar.gz mv jdk1.8.0_151 /usr/java/ Configure environment variables and take effect vim /etc/profile export JAVA_HOME=/usr/java/ export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib export ...

Database read-write separation is an indispensable and important function for large-scale systems or high-volume Internet applications. For MySQL, the standard read-write separation is the master-slave mode. A write node Master is followed by multiple read nodes. The number of read nodes depends on the pressure of the system, usually the confi ...