Getting started with middleware mycat (1): Deployment and introduction

During the initial testing process, the project originally used kingshard as the middleware, but during the testing process, we found that the join does not support different sub-tables, so we can only choose to give up and change to mycat to do the testing Download address is [root@gzsd-ks01-101110214 download]# wget http://dl.mycat.i ...

Posted by Aptana on Fri, 10 Jul 2020 09:18:41 -0700

HAProxy+Keepalived for Mycat High Availability

In a real project, Mycat services also need to consider high availability. If the server Mycat is on is down, or if the Mycat service fails, it needs a standby machine to provide services and the Mycat cluster needs to be considered.Highly available options:We can use HAProxy+Keepalived with two Mycats to build Mycat clusters for high availabi ...

Posted by LuckyLucy on Wed, 24 Jun 2020 11:21:07 -0700

mycat configuration fragment

Machine information Machine IP Installation services Exposed port 192.168.177.128 mycat service External exposure port 8066 192.168.177.131 mysql1 External exposure port 3306 192.168.177.132 mysql2 External exposure port 3306 1. Install mycat 1.1 download the installation package (it is r ...

Posted by ganesh129 on Tue, 23 Jun 2020 22:20:45 -0700

MySQL Read-Write Separation Reality

1. MySQL Read-Write Separation Concept The principle of MYSQL read-write separation is to let Master database handle transactional add, delete, modify, update operations (create, insert, update, delete) and Slave database handle query operations (select). MySQL read-write separation is based on MySQL master-slave replication, which can guarant ...

Posted by fareedreg on Mon, 08 Jun 2020 10:08:09 -0700

Mycat's database primary key self growth (local timestamp) - yellow Tong

In the local time mode, the policy ID automatically generated by ID= 64 bit binary (42 (MS) + 5 (machine ID) + 5 (business code) + 12 (repeated accumulation). The local time stamp mode is mycat's default, so when you configure it, you need to confirm whether the sequnceHandlerType configuration in your server.xml is 2. To realize the local ...

Posted by amitkrathi on Sat, 02 May 2020 13:08:23 -0700

7 Mycat principle analysis DDL statement processing

Previously, we have talked about how to judge the sql type by Mycat, and then handle it differently for different types of sql [Mycat principle analysis - SQL statement processing] , let's take a look at the DDL statement and how Mycat handles it. In combination with the code in ServerParse.java, let's take a look at t ...

Posted by tommyy on Thu, 30 Apr 2020 20:08:06 -0700

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