Programmer Help

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

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

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

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

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

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

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

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

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

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