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

A method, device and system for realizing high availability of database

A database and data technology, applied in the database field, can solve the problems of reducing the availability of write operations, easy performance bottlenecks, etc., to achieve the effect of improving security

Active Publication Date: 2020-06-12
CHINA MOBILE COMM GRP CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] There are the following disadvantages in the scheme of using the master-slave method to achieve high availability of the database: when the write operation requests are frequent, the performance of the host to receive the write operation requests is prone to bottlenecks
[0009] There are the following disadvantages in the solution of using distributed clusters to achieve high availability of databases: when receiving a write access request, the corresponding write operation can only be implemented on two hosts at most, thus reducing the availability of write operations

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
  • A method, device and system for realizing high availability of database
  • A method, device and system for realizing high availability of database
  • A method, device and system for realizing high availability of database

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0066] The first embodiment of the present invention provides a method for achieving high availability of a database. Here, the database is used to use at least two hosts to store data, and a data change request of the database is used to be sent to an idle host.

[0067] image 3 The flow chart of the first embodiment of the method for realizing database high availability in the present invention, such as image 3 As shown, the process includes:

[0068] Step 300: When each host receives a data change request, based on the data change request, each host changes the data stored by itself; and sends its own data change information to other hosts.

[0069] Exemplarily, the state of each host can be divided into an idle state and a busy state, and when the host is in the busy state, it cannot receive a data change request.

[0070] Here, the data change request is a request to change data in the database. Exemplarily, the data change request includes but not limited to insert r...

no. 2 example

[0092] In order to better reflect the purpose of the present invention, further illustrations are made on the basis of the first embodiment of the present invention.

[0093] The second embodiment of the present invention provides a method for achieving high availability of a database. Here, the database uses at least two hosts to store data, and a data change request of the database is used to be sent to an idle host.

[0094] Figure 4 It is a flow chart of the second embodiment of the method for realizing database high availability in the present invention, such as Figure 4 As shown, the process includes:

[0095] Step 400: Set up a cluster component, and the cluster component is respectively connected to each host used by the database.

[0096] Here, the cluster component can be used to receive data access requests, the data access requests include but not limited to: data change requests, data read requests, etc. Exemplarily, data change requests include but not limite...

no. 3 example

[0120] Aiming at the method for realizing high availability of database in the first embodiment of the present invention, the third embodiment of the present invention provides an apparatus for realizing high availability of database.

[0121] In the device for achieving high availability of a database according to the third embodiment of the present invention, the database is used to use at least two hosts to store data, and the data change request of the database is used to be sent to a host in an idle state.

[0122] Figure 5 A schematic diagram of the composition and structure of the device for realizing the high availability of the database in the embodiment of the present invention, such as Figure 5 As shown, the device includes: a first modification module 500 and a second modification module 501; wherein,

[0123] The first change module 500 is configured to, when receiving a data change request, change the data stored in the host where it is located based on the da...

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 embodiment of the invention discloses a method for achieving high availability of a database. The database is used for storing data through at least two hosts, and a data change request of the database is used for being sent to the host in an idle state. The method comprises the steps that when one host receives the data change request, the host changes data stored in the host on the basis of the data change request; data change information of the host is sent to the other hosts; when the host receives data change information of the other hosts, the host changes the data stored in the host on the basis of the received data change information. The embodiment of the invention further discloses a device and system for achieving high availability of the database.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method, device and system for realizing high availability of databases. Background technique [0002] At present, the database market is mainly divided into three camps, including traditional relational database (OldSQL), new type database (NewSQL) and non-relational database (NoSQL). From a technical point of view, the typical features of OldSQL are row storage and relational. At present, NewSQL and NoSQL have achieved great development, but they are mainly used in the Internet field. In the core system of the traditional field, the traditional relational database is still the main one. In order to achieve the high performance, high reliability and multi-data type processing requirements of the database core system, it is necessary to realize the high availability of the database. [0003] At present, there are two main solutions to achieve high availability of databases. The first ...

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): G06F16/27G06F16/21
CPCG06F16/21G06F16/27
Inventor 孙翠锋
Owner CHINA MOBILE COMM GRP CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com