Programmer Help

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 ...

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 ...

  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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...