Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for achieving system dynamic expansion in shared-nothing database cluster

A technology for realizing system and dynamic expansion, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that shared-nothing database clusters cannot provide services for applications, reduce the availability of shared-nothing database cluster systems, etc., and achieve reduction Effects of impact and loss, high availability, high scalability

Active Publication Date: 2012-06-27
北京人大金仓信息技术股份有限公司
View PDF6 Cites 46 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During this time, the shared nothing database cluster will not be able to serve the application
If it is in the business processing time period, this will seriously reduce the availability of the entire shared nothing database cluster system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for achieving system dynamic expansion in shared-nothing database cluster
  • Method for achieving system dynamic expansion in shared-nothing database cluster
  • Method for achieving system dynamic expansion in shared-nothing database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] figure 1 Shows the basic architecture of a typical shared nothing database cluster system. The shared nothing database cluster system includes a coordinator, a cluster manager and multiple data nodes. Among them, the coordinator is responsible for introducing the SQL statement sent by the database application, generating a query plan, finding the data node related to the SQL statement according to the distribution strategy of the data table, rewriting the SQL statement into multiple related statements and sending it to each data node Above, the data nodes execute these rewritten statements, then execute and return the results to the coordinator, and the coordinator finally returns the results to the database application.

[0035] In a shared-nothing database cluster, the key to realizing dynamic expansion of the system is how to redistribute the data tables according to the new data distribution algorithm without affecting the business. For this reason, the present in...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for achieving system dynamic expansion in a shared-nothing database cluster, which includes the following steps: adding and detecting newly added data nodes and verifying connectivity of the newly added data nodes; initializing the newly added data nodes and synchronizing metadata information into the newly added data nodes; redistributing related tuples of a data table and distributed on the newly added data nodes in data nodes and the newly added data nodes, and leading operation on the data table in the redistributing process to be synchronous in the data nodes and the newly added data nodes; and modifying cluster configuration files in a cluster manager. The method solves the problem of difficulty in dynamic expansion of the shared-nothing database cluster, and greatly reduces influence on and loss of user service logic during expansion of the cluster. By means of the method, on-line expansion can be achieved, so that high expandability of a system can be ensured, and high availability of the system can further be ensured.

Description

technical field [0001] The invention relates to a database cluster expansion method, in particular to a system dynamic expansion method implemented based on data table operations in a Share Nothing (Share Nothing) database cluster, and belongs to the technical field of database cluster systems. Background technique [0002] Scalability is one of the main characteristics of examining the pros and cons of any database cluster, which determines whether the database cluster can meet the needs of rapidly growing database applications. Currently, there are two ways to scale a database cluster: vertical scaling and horizontal scaling. [0003] 1. Vertical expansion [0004] Add resources within the same logical unit to increase capacity. Such as upgrading the CPU of the server, such as adding hard disks to RAID / SAN storage devices. [0005] 2. Horizontal expansion [0006] Add multiple LU resources and make them work as a whole. The horizontal expansion method does not require...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 王殿成王雄冯玉李祥凯冷建全
Owner 北京人大金仓信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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