mycat Read-Write Separation+Base Subtable+Global Table
1. mycat Read-Write SeparationMycat's read-write separation is based on the master-slave replication of Mysq
#Modify ProfileSchema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" data ...
Posted on Sun, 21 Jun 2020 18:01:58 -0400 by fellixombc
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