# IT Stars Are Not Dreams#MySQL High Availability Clusters for High Availability Based on MyCat Deployment HaProxy

Deploying HaProxy based on MyCat for high availability In a real project, the Mycat service also needs to consider high availability. If the server Mycat is on is down or the Mycat service fails, it needs a standby machine to provide service and the Mycat cluster needs to be considered. 1. High Availability Scheme You can use HAProxy+Keepal ...

Posted on Tue, 18 Feb 2020 11:13:15 -0500 by Bunyip

MyCat realizes the separation of reading and writing + sub database and sub table + global table

Preface MYCAT has powerful functions and simple configuration. As a database middleware, it is a very excellent open source product. For the deployment and installation of MYCAT, please refer to the blog: MyCat deployment installation. This post will show the following functions of mycat: Separation of reading and writing; Sub warehouse and ...

Posted on Tue, 11 Feb 2020 08:59:47 -0500 by mrsocks

Analysis of the sql parsing source code of Mycat

  the SQL parsing of Mycat is divided into two parts: shallow parsing and deep parsing. The following two parts are explained respectively. The version number of Mycat analyzed in this paper is 1.6.7.4-test-20191226161308. For the specific version number information, please refer to io.Mycat.confi ...

Posted on Sun, 19 Jan 2020 22:09:04 -0500 by elwadhos

Database horizontal segmentation (Mycat fragmentation routing principle and global serial number)

Principle of piecewise routing Select * from travelrecord where id in(5000001, 10000001); dn1,dn2,dn3, id=5000001 this data is on dn2, id=10000001 this data is on dn3. Scan dn1 dn2 dn3 all the time, resulting in performance waste. Scan a piece. Missing data. Summary: you can't scan more = =, performance is insufficient, and you can't mi ...

Posted on Sat, 04 Jan 2020 07:12:42 -0500 by jariizumi

Storage - massive data - (mycat core concepts and advanced)

target Master big data processing scheme and HA of database Master why database middleware is needed and what is database middleware Master the characteristics of database middleware required by different scenarios Master the key points of database middleware design   Core concept understanding and working principle review How to solve ...

Posted on Wed, 04 Dec 2019 11:52:56 -0500 by manohoo

mycat sub table sub database

Environment: master: 192.168.225.128 Slave: 192.168.225.129 There are two databases db01 and db02 on the master and slave respectively. users table is stored in db01 and db02, but it is not divided into tables to query which server is sent randomly. Part of the data in the item table is stored in db02 of the master, and the other part is store ...

Posted on Sun, 01 Dec 2019 18:26:32 -0500 by Ameslee

Mycat distributed database architecture solution -- detailed explanation of Server.xml

Echo editor, welcome to reprint, reprint please state the source of the article. Welcome to add echo wechat (wechat: t2421499075) for communication and learning Never lose in a hundred battles, never claim to win, never lose in a hundred defeats, and strive to move forward. ——This is really powerful!!! This file is a system config ...

Posted on Tue, 05 Nov 2019 14:10:34 -0500 by Pro Ninja

Mycat distributed database architecture solution -- details of schema.xml

Echo editor, welcome to reprint, reprint please state the source of the article. Welcome to add echo wechat (wechat: t2421499075) for communication and learning Never lose in a hundred battles, never claim to win, never lose in a hundred defeats, and strive to move forward. ——This is really powerful!!! This file is a system config ...

Posted on Tue, 05 Nov 2019 11:18:59 -0500 by kemu_

Solution of Mycat distributed database architecture

Echo editor, welcome to reprint, reprint please state the source of the article. Welcome to add echo wechat (wechat: t2421499075) for communication and learning Never lose in a hundred battles, never claim to win, never lose in a hundred defeats, and strive to move forward. ——This is really powerful!!! preparation: Please install ...

Posted on Mon, 04 Nov 2019 21:49:27 -0500 by Ausx

Mycat implements MySQL database and table splitting, read-write separation, master-slave switching

Recently, I mainly invested in the project of Ping An cloud MySQL DRDS. I was mainly responsible for the configuration of zookeeper module and the writing of background script. In order to deepen the understanding of the overall architecture of DRDS, I think it is necessary to manually build Mysql di ...

Posted on Thu, 17 Oct 2019 11:38:43 -0400 by cgf2000