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

MySQL Optimization (Ultra-Complete Version)

7. MySQL Subdatabase Subtable (1) Introduction to the concept of sub-database and sub-table MySQL has two ways of splitting database tables: vertically and horizontally.Vertical splitting: Vertical splitting refers to splitting tables into different database tables by module (in principle, or without breaking the third paradigm), which is comm ...

Posted on Tue, 27 Aug 2019 14:12:43 -0400 by shiggins

springboot+mycat sub-table sub-library

Preface When the volume of business is getting bigger and bigger, when the single form data exceeds tens of millions, or even hundreds of millions, it will be really time-consuming to query in a table. In the distributed system, table-based database is also a common method to solve this kind of bottleneck. Today I will choose springboot+mycat f ...

Posted on Tue, 30 Jul 2019 08:24:55 -0400 by scotthoff

Mycat catlets cross-library JOIN and global JOIN

The catlet-based library JOIN provides good support for database tables to be Repositoried by type, while global tables with DDL implementations at each node can also implement direct JOIN operations.When a table is set to a global table, it can be JOIN manipulated with any table. Mysql repository Here we create m and n database instance names ...

Posted on Sat, 22 Jun 2019 14:13:22 -0400 by Joe

SUSE12SP3-Mycat Installation

Catalog Preface Environmental Science Installation instructions install 1,mycat 2,mycat-eye Preface Introduce yourself. mycat: http://www.mycat.io/ Environmental Science System: SUSE12SP3 Software Edition Explain java jdk1.7.0_79 Other versions are also available, see Official Website. Previous articles included installation tutoria ...

Posted on Sun, 12 May 2019 05:12:29 -0400 by knighthawk1337

Implementation of mysql read-write separation by mycat based on jeesz distributed architecture

Copyright Statement: This article is the original article of the blogger. It can not be reproduced without the permission of the blogger. Catalog (?)[+] mycat is one data base Middleware, based on Ali's open source cobar products, is developed by several aspiring people who work together to complete and open source. Provid ...

Posted on Sat, 20 Apr 2019 15:45:33 -0400 by pesale86

myCat Reading-Writing Separation Practice

Clear purpose Testing the read-write separation function of myCat; (This article only records the practice process of myCat read-write separation, other related issues are not described) The necessary environment MySQL Cluster (mine is 1 master 2 slave) myCat environment Configure myCat MYCAT_HOME/conf/schema.x ...

Posted on Wed, 17 Apr 2019 05:24:34 -0400 by Mick33520