MyCat global primary key generation strategy

In the case of sub databases and sub tables, the global uniqueness of the auto increasing primary key cannot be guaranteed for multiple databases. Therefore, the global primary key generation strategy of MyCat was born. Mycat global primary key mode 1. Local file mode: use the server's local disk file mode 2. Local time stamp method: use ti ...

Posted on Sun, 24 May 2020 06:58:14 -0400 by rajivgonsalves

Quick installation and simple application of mycat under linux

Go to mycat website first: http://dl.mycat.io/ Download the corresponding version of MYCAT server. I use MYCAT server-1.6.5-release-20180122220033-linux.tar.gz here Upload to linux server. Unzip: tar-zxvf Mycat-server-1.6.5-release-20180122220033-linux.tar.gz will generate a MYCAT folder. Here is a simple demonstration of mycat's single da ...

Posted on Sun, 03 May 2020 02:41:52 -0400 by phprooky

6 Mycat principle analysis - EXPLAIN statement processing

Previously, we have talked about how to judge the sql type by Mycat, and then perform different processing for different types of sql[ Analysis of Mycat principle processing of SQL statement ]Now, let's take a look at the explain statement and how Mycat handles it. The EXPLAIN statement provided by Mycat is not used to ...

Posted on Sat, 02 May 2020 07:48:35 -0400 by bawla

Docker builds the master-slave mode of MySQL read-write separation

System environment: Ubuntu 18.04.4 Docker 19.03.6 1, MySQL read-write separation master-slave mode 1. Download Imagedocker pull mysql Current latest version: MySQL ver 8.0.19 for Linux on x86_ (MySQL community server - GPL) 2. Start the master node and modify the configuration filedocker run -it --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD= ...

Posted on Sun, 12 Apr 2020 08:22:14 -0400 by dreamer

Read-write separation of MySQL database using Mycat

Prerequisite preparation 1. A CentOS machine 2.Mycat installation package (http://www.mycat.io/) Installation and Use 1. Unzip Mycat's installation package to/user/local/      2. Setting environment variables for mycat         vi /etc/profile          3. Make the profile effective immediately         source /etc/profile   4. Modify ...

Posted on Fri, 10 Apr 2020 12:36:49 -0400 by TransmogriBenno

Python dictionary notes

I. dictionary 1. The function is the same as the list function 2. Use in or not in to determine whether the index exists birthdays = {'Alice': 'Apr 1', 'Bob': 'Dec 12'} 'Alice' in birthdays # True 'Jack' in birthdays # False 3. Use values() to get all values spam = {'color': 'red', 'age': 42} spam # {'red', 42}, you can use for loop travers ...

Posted on Tue, 31 Mar 2020 04:41:28 -0400 by adamjblakey

MyCat topic - Enumeration and segmentation of MyCat segmentation rules

1. introduction In MyCat, there are many sharding rules, such as enumeration sharding, modulus sharding, range sharding, consistency hash sharding and so on. Each sharding rule needs to be determined according to the amount of data in the specific business of the project. Therefore, no sharding rule i ...

Posted on Mon, 09 Mar 2020 01:42:42 -0400 by shikhartandon

Distributed transaction and data consistency

If you don't know mycat and sharding JDBC, you must read them, otherwise you won't understand the article mycat and sharding JDBC details: https://blog.csdn.net/qq_34886352/article/details/104458171 1, Distributed global id 1. id problem caused by sub database and sub table     in a n ...

Posted on Sun, 01 Mar 2020 23:47:28 -0500 by mentor

Mycat - Set global self-increasing id

In the Mycat - Implementing MySQL Horizontal Subtable In the article, we divide the order_master data table in the order database of the store database horizontally according to the customer_id field. When we insert the data into the order_master data table through Mycat, and then query the order_master ...

Posted on Sun, 01 Mar 2020 20:11:49 -0500 by Sphen001

# IT Stars Are Not Dreams#MySQL High Availability Clusters for High Availability Based on MyCat Deployment HaProxy

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

Posted on Tue, 18 Feb 2020 11:13:15 -0500 by Bunyip