Why are sub databases and sub tables
If you think the theory is wordy, just jump to the second level 1 Title sub library and start looking.
What is sub database and sub table?
In fact, it means literally. It's easy to understand: Sub database: the process of splitting a single database into multiple databases, scattering data in mul ...
Posted by chinto09 on Mon, 24 Jan 2022 11:01:56 +0100
1. Problems encountered in development
With the growth of business, the historical data table already has 400-500 million data. Previously, a table was created every month according to the scheduled task. When inserting, the data was inserted into the current table according to the current time. Cross month query is a problem when performing a ...
Posted by bender on Thu, 13 Jan 2022 23:07:14 +0100
Mycat exposes services in the form of a Server, and its main configuration class is Server XML, this article mainly focuses on some small details, mainly including:
Server. How to load XML
Configuration and role in Server
Flow of Server in connection request
II Server.xml configuration
Posted by htcilt on Thu, 13 Jan 2022 07:18:11 +0100
Mycat is a database middleware.
High availability and Mysql read / write separationHierarchical storage of business dataLarge table, horizontal splitting, cluster parallel computingDatabase connection poolConsolidate multiple data sources
Download address: http://dl.mycat.org.cn
Before installing Mycat, you need to ...
Posted by PHPFreaksMaster on Tue, 04 Jan 2022 08:57:34 +0100
I brief introduction
MyCat is an open source distributed database system and a server that implements MySQL protocol. Front end users can regard it as a database agent and access it with MySQL client tools and command line, while its back end can communicate with multiple MySQL servers using MySQL native protocol or with most mainstream databa ...
Since our Web application is running in tomcat, the request must arrive at Tomcat first. Tomcat actually handles the request as follows.
First, provide Socket service
The start of Tomcat must be Socket service, but it only supports HTTP protocol!
In fact, we can expand our thinking here. Since Tomcat is based on Socket, what about BIO or NIO ...
Posted by Sesquipedalian on Mon, 11 May 2020 16:41:20 +0200
The user instance SERV is divided into different databases according to the org? ID
Beijing (ORG UU id = 101), Shanghai (ORG UU id = 102), Shenzhen (ORG UU id = 103), Chongqing (ORG UU id = 104), Sichuan (ORG UU id = 105)
Beijing bjdb, Shanghai shdb, Shenzhen szdb and Chongqing cqdb are built on dn10 and dn11
Sichuan scd ...
Posted by DragonHighLord on Sat, 04 Apr 2020 02:55:03 +0200
First read the quick start of the official website, then build it yourself. The result is various errors and pits.Record it.
A virtual machine, a cloud server, a local Mac (because mysql is installed on the cloud server and locally, or you can use the virtual machine entirely, just look at yourself), mycat is deployed on the virt ...
Posted by eerikk2 on Tue, 25 Feb 2020 03:48:46 +0100
1. Key xml configuration tables
The user tab specifies the account to access the database.
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - Y ...
Posted by austrainer on Sun, 02 Feb 2020 15:14:14 +0100
mycat mainly provides a specific configuration of database segmentation. In this article, we will not do in-depth analysis, let the program run first!
MYCAT official website: http://www.mycat.io/ ා don't be afraid of Chinese
1 > environment:
CentOS operating system mysql5.6 Master database host: 192.168.0.1 Slave a host: 192.168.0 ...
Posted by biocyberman on Sun, 05 Jan 2020 22:05:19 +0100