MyCat for MySQL Middleware

I. MyCat Basic Concepts 1. What is MyCat A thoroughly open source, large database cluster for enterprise application developmentTransaction enabled, ACID enabled, enhanced database that can replace MySQLAn enterprise database that can be considered a MySQL cluster to replace the expensive Oracle clusterA new type of SQL Server which combines ...

Posted by mike1313 on Sun, 16 Feb 2020 15:40:39 -0800

Mycat Integration MySQL 8.x Trample Practice

Mycat currently does not fully support versions of MySQL 8 or above, which may cause problems such as incorrect passwords when Mycat connects to MySQL 8 because the new version does not encrypt the password the same way as the old version.There is also the time zone issue, and the new version of the connection requires additional time zone par ...

Posted by Dawg on Sat, 11 Jan 2020 14:26:02 -0800

Separation of reading and writing of mysql through mycat

The master-slave configuration of mysql follows the configuration of the previous blog: https://www.cnblogs.com/MasterSword/p/9434169.html MYCAT download address: http://www.mycat.io/ Trial version: Mycat-server-1.6-release # cd /usr/local # mv ~/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz /usr/local # tar -zxvf Mycat-server-1.6-RELEA ...

Posted by bla5e on Sat, 04 Jan 2020 07:06:32 -0800

Solution of Mycat distributed database architecture -- Separation of reading and writing by Mycat

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!!! After the installation, we h ...

Posted by simonoc on Mon, 04 Nov 2019 18:45:35 -0800

Summary of distributed DBLE partition algorithm series

Original: Guan Changlong   We have introduced six common segmentation algorithms of DBLE and MyCat through the previous six articles, so let's make a summary! DBLE and MyCat corresponding algorithm name and similarities and differences The seventh DBLE fragmentation algorithm jumpStringHash In addition to the above six common sharding ...

Posted by troublemaker on Wed, 30 Oct 2019 21:34:50 -0700

The use of Druid in Spring and Spring Book projects

What is it? One kind of database connection pool, manages and releases the connection of database, realizes the reuse of connection, and can compare thread pool. Parameter configuration What can we do? 1, Connection Pool 2, Monitoring 3, Encryption 4, Extending JDBC How do you use it? Adding ...

Posted by LightningSt on Wed, 02 Oct 2019 09:51:18 -0700

MYSQL Asynchronous Replication

Replication, replication is a highly available foundation, and the underlying layers of middleware such as MHA, mycat all rely on replication principles Master master master instance slave Slave slave Classification: default asynchronous replication, semi-synchronous replication after version 5.5, new GTID replication at version 5.6, multi-sour ...

Posted by Gast on Wed, 14 Aug 2019 22:04:55 -0700

MaCat: Subdatabase and subtable MySQL database

The premise of this article is: mycat is configured correctly and starts normally. 1,schema.xml <table>label: DataNode -- Slice node specifies (value: name attribute value in dataNode) Rule ------- Fragmentation rule selection (value: name attribute value in rule tag) [root@dras-test conf]# vim schema.xml 1 <?xml version ...

Posted by revjoe on Sun, 07 Jul 2019 10:18:58 -0700

Implementing Principle of SQL ON MongoDB

(iv) Focus on Wechat Public Number: [Taro Back-end Cabin] Welfare: RocketMQ/MyCAT/Sharing-JDBC All Source Analysis Articles List RocketMQ/MyCAT/Sharing-JDBC Chinese Annotation Source GitHub Address Every message you leave about the source code will be answered carefully. Even if you don't know how to read the source code, you can ask. New so ...

Posted by MrAlaska on Tue, 11 Jun 2019 12:25:20 -0700

Deep understanding of JavaScript inheritance features and best practices

Inheritance is the pattern of code reuse. JavaScript can simulate class-based patterns and support other more expressive patterns. But keeping it simple is usually the best strategy. JavaScript is a prototype-based language, that is, it can inherit other objects directly. 1 pseudo class The prototype of JavaScript is not to inherit objects dire ...

Posted by misty on Thu, 23 May 2019 13:32:59 -0700