Unlock instant, AI-driven research and patent intelligence for your innovation.

Deployment method and device for multi-data fragmentation backup of database cluster

A data sharding and database technology, applied in the field of database clusters, to achieve the effect of ensuring reliability

Active Publication Date: 2019-04-30
TIANJIN NANKAI UNIV GENERAL DATA TECH
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present invention provides a deployment method and device for database cluster multi-data fragmentation backup to solve the technical problem of backup data fragmentation in deployment

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
  • Deployment method and device for multi-data fragmentation backup of database cluster
  • Deployment method and device for multi-data fragmentation backup of database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] figure 1 It is a schematic flow diagram of the deployment method for database cluster multi-data fragmentation backup provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation where backup fragmentation is deployed in the database cluster. This method can be implemented by database cluster multi-data fragmentation The backup deployment device is implemented, and the device can be realized by software / hardware, and can be integrated in the database cluster system.

[0037] see figure 1 , the deployment method of multi-data fragmentation backup of the database cluster, comprising:

[0038] S110. Obtain the number of nodes in the database cluster.

[0039] The database cluster refers to a cluster composed of multiple database nodes. The nodes in the database cluster are called cluster nodes. The cluster nodes are the carriers of data fragmentation and backup fragmentation. The database cluster can be determined according to the man...

Embodiment 2

[0066] figure 2 It is a schematic structural diagram of a deployment device for database cluster multi-data fragmentation backup provided in Embodiment 2 of the present invention, as shown in figure 2 As shown, the device includes:

[0067] A node obtaining unit 210, configured to obtain the number of nodes in the database cluster;

[0068] The number of data fragments acquiring unit 220, configured to acquire the number of data fragments corresponding to each node in the database cluster;

[0069] Configuration unit 230, configured to configure backup fragments according to preset rules;

[0070] The calculation unit 240 is configured to calculate the reliability of the configuration backup slice, and select the optimal reliability as the deployment method.

[0071] Further, the preset rules include:

[0072] Put the backup fragments of the p data fragments of the first node in the p nodes starting from the next node in turn; or

[0073] Put all the backup fragments of...

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 provides a deployment method and device for database cluster multiple data fragment backup. The method includes the steps: acquiring the number of nodes in a database cluster; acquiring the number of data fragments corresponding to the nodes in the database cluster; configuring backup fragments according to preset rules; calculating reliability of the configured backup fragments, and selecting optimal reliability as the deployment method. Deployment modes of various backup fragments are configured by the aid of the preset rules, a configuring mode with the highest reliability is selected and serves as the deployment mode, optimal reliability can be deployed, and cluster reliability is furthest guaranteed.

Description

technical field [0001] The invention belongs to the field of database clusters, and in particular relates to a deployment method and device for multi-data slice backup of database clusters. Background technique [0002] A database cluster uses at least two or more database servers to form a virtual single database logical image, providing transparent data services to clients like a single database system. In database analysis applications, database clusters play a major role. In order to ensure the reliability of clusters, backup shards are often used to back up data. Each primary shard corresponds to a backup shard, and the primary shard and backup shard are not in the same a data node. A database cluster that deploys multiple data shards on one data node has obvious advantages in terms of scalability, but how the backup data shards are distributed will affect the reliability of the entire cluster. Contents of the invention [0003] Embodiments of the present invention ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/14
CPCG06F11/1415
Inventor 崔维力武新李春华
Owner TIANJIN NANKAI UNIV GENERAL DATA TECH