A Method of Rapid Horizontal Expansion of Database
A horizontal expansion, database technology, used in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of long downtime, high cost of large servers, and inability to expand front-end controllers, so as to improve production efficiency and avoid The effect of uneven distribution of hot spots and simple and easy-to-use algorithms
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0054] Step 1: Deploy the monitoring module, such as Figure 4 As shown in the initial system architecture diagram of the database, the monitoring module and the routing module are respectively deployed on the hardware machine. The hardware monitoring software used here is the open source OpenHardwareMonitor, which collects database cluster information in real time through the network. When the hardware capacity reaches the set storage capacity threshold, the monitoring software module prompts the administrator to prepare to increase the hardware environment to prepare for the next step of data segmentation.
[0055] Step 2: The hardware environment has been prepared from the previous step, and when the counter of the routing module reaches the preset storage number threshold, it is ready to split. Implementation According to the principle of database horizontal expansion, the segmentation factor α=2 is now taken.
[0056] There are two tables in database instance 0. The rule...
example 0
[0059] At this time, there is only one database instance, so the sub-database rule DRule: "database instance 0"
[0060] Table sub-rule TRule: "tableName"+"ID%2", that is, the data storage of this database instance will take the remainder according to the value of the primary key ID, and the data with a remainder of 0 will be stored in table 0, and the data with a remainder of 1 will be stored in table 1 in. Such as Figure 5 shown.
[0061] Step 3: Assume here that the storage number threshold of database instance 0 is Y pieces of data, then the maximum data volumes of table 0 and table 1 in database instance 0 are respectively Y / 2 pieces of data, when database instance 0 reaches the capacity limit That is, when the data volume of database instance 0 reaches Y, according to the expansion rules, the first expansion is n=1, that is, the total number of database instances is N=2 1 =2, that is, add a database database instance 1, move table 1 into database instance 1, and the ...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com