We can use haproxy + preserved with two Mycat to build a Mycat cluster to achieve high availability. HAProxy
It realizes the cluster high availability and load balancing of MyCat,
The high availability of HAProxy itself can be achieved through Keepalived.
Posted on Sun, 07 Jun 2020 03:12:10 -0700 by Clarkeez
Setting up Mycat environment based on Docker to realize the separation of reading and writing of Mysql database
1. Construction environment
1.1 build Mysql master-slave service
1.1.1 download Mysql image
docker pul ...
Posted on Mon, 02 Mar 2020 23:11:40 -0800 by Nandini
C language string library string.h contains many common string functions:
String length function strlen
String comparison function strcmp
String copy function strcpy
String append function strcat
Find character function strchr from left
Right search character function strrchr
Find string function strstr ...
Posted on Wed, 05 Feb 2020 01:55:01 -0800 by xardas
1.Symbol variable type
In the following code snippet, this [categories] is functionally equivalent to this.categories, but the property type of the latter is string, so it needs to be accessed with point number. The property type of the former is
The function of Symbol type is that each Symbol valu ...
Posted on Sat, 25 Jan 2020 23:48:19 -0800 by Hatchmo
I. preparation before deployment
1.1 software version
1 operating system: centOS-7.0(ubuntu 16.4)
2 jdk :1.8
3 haproxy: 1.2.27
4 keepalived: 1.3.9 (keepalived-1.3.9)
5 mycat: 1.6
6 mysql: 5.7
1.2 server distribution
192.168.1.100 (vip At 192.168.1.1 Created on)
192.168.1.1 server001 (mycat,haproxy,keepalive) master
Posted on Wed, 27 Nov 2019 09:03:47 -0800 by flhtc
I. installation of MyCat
1. Installation Preparation Environment
1.1 installation of JDK
because MyCat is developed by java, it needs java virtual machine environment, and it is necessary to install JDK in Linux node.
1.2 release relevant ports
Posted on Thu, 24 Oct 2019 04:42:30 -0700 by junrey
Nowadays, clustering is widely used to optimize database performance, while oracle cluster is expensive to invest in software and hardware. mysql is more recommended to use mycat to build database cluster. Here is how to use mycat+haproxy+keepalived to build a high available load balancing system belonging to mysql database.
Main id ...
Posted on Wed, 09 Oct 2019 11:31:24 -0700 by smarty_pockets
Mycat's role in applications is described as follows:
Mysql master is responsible for reading and writing for master library and Mysql slave is responsible for reading from slave library. In this way, programmers can only care about business code compilation, without worrying about load balancing of back-end database cluster, separa ...
Posted on Mon, 27 May 2019 10:56:43 -0700 by robert.access
In fact, the installation of Mycat is as simple as unzipping the downloaded directory.After installation, the directory is as follows:
mycat command, start, restart, stop, etc
catlet is an extended function of Mycat
Mycat configuration information, focus on
Mycat refers to the jar package Mycat wa ...
Posted on Fri, 25 Jan 2019 03:42:13 -0800 by poelinca