High-availability and high-consistency database cluster system and command processing method thereof

A command processing, high-availability technology, applied in electrical digital data processing, special data processing applications, database design/maintenance, etc., which can solve problems such as single-point failure, unrecoverable, and data loss of the database

Inactive Publication Date: 2017-02-15
CHENGDU SOBEY DIGITAL TECH CO LTD
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] RAC (Real Application Cluster, real application cluster) is a parallel cluster of Oracle. Oracle instances located on different nodes access the same Oracle database at the same time. Nodes communicate through a private network. All control files, online logs and data files are stored in On a shared storage device, it can be read and written by all nodes in the cluster; this cluster method has certain limitations:
When the amount of data is small, the time required is acceptable; but when the amount of data is large, the time it takes to maintain consistency may not be acceptable
[0005] On the other hand, when an instance fails, if the cached data in the instance has not been synchronized to the shared storage, this part of the data will be lost and cannot be recovered
[0006] 2) Database single point of failure
[0007] There is only one data file in RAC, when the shared storage fails, the service will not be provided

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
  • High-availability and high-consistency database cluster system and command processing method thereof
  • High-availability and high-consistency database cluster system and command processing method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The technical solution of the present invention will be further described in detail below in conjunction with the accompanying drawings, but the protection scope of the present invention is not limited to the following description.

[0038] like figure 1 As shown, a database cluster system with high availability and strong consistency includes a command processing rule setting unit, an initial configuration unit and a plurality of nodes, and the plurality of nodes are connected through a private network;

[0039] Each of said nodes can provide complete data storage, access and command execution management services;

[0040] The initial configuration unit is used to provide a configuration interface, and then determine the primary node and the secondary node from the plurality of nodes through manual configuration;

[0041] The command processing rule setting unit is used to set command processing rules to ensure data synchronization and consistency between nodes of the...

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 high-availability and high-consistency database cluster system and a command processing method thereof. The system comprises a command processing rule setting unit, an initial configuration unit and a plurality of nodes, wherein the nodes are connected through a private network; each node can provide complete data storage, access and command execution management services; the initial configuration unit is used for providing a configuration interface and determining a primary node and secondary nodes in the nodes in a manual configuration manner; and the command processing rule setting unit is used for setting a command processing rule and ensuring data among the nodes of the database cluster system in the command processing process to be synchronous and consistent. According to the system and the method, each node in the database cluster system can provide complete storage and access services; in the command processing process, the data of the nodes in the database cluster system is synchronous and consistent; and a single node fault does not influence normal work of the database cluster system and also does not cause data loss.

Description

technical field [0001] The invention relates to a database cluster system with high availability and strong consistency and a command processing method thereof. Background technique [0002] RAC (Real Application Cluster, real application cluster) is a parallel cluster of Oracle. Oracle instances located on different nodes access the same Oracle database at the same time. Nodes communicate through a private network. All control files, online logs and data files are stored in On a shared storage device, it can be read and written by all nodes in the cluster; this cluster method has certain limitations: [0003] 1) Data synchronization between instances [0004] RAC provides multiple instances. RAC will first cache the written data in the memory of the instance, and then synchronize it to the shared storage. Sometimes it takes a long time to synchronize the data. For example: when multiple instances write data at the same time and immediately query the newly written data, th...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/21G06F16/273
Inventor 吴春中饶青张浩阳谢超平
Owner CHENGDU SOBEY DIGITAL TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products