Multi-rac cluster system, data access method and device

A technology for data access and clustering, applied in the field of RAC clusters, which can solve problems such as downtime maintenance, troublesome operation, and impact on external services provided by applications, and achieve the effect of short switching time

Active Publication Date: 2019-06-04
CHINA CONSTRUCTION BANK
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] That is to say, whether in load balancing mode or active / standby mode, when any set of RAC clusters goes down, it will have a great impact on the external services provided by the application.
And when a new RAC cluster needs to be added, it needs to be shut down for maintenance, and the operation is troublesome

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
  • Multi-rac cluster system, data access method and device
  • Multi-rac cluster system, data access method and device
  • Multi-rac cluster system, data access method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to facilitate the understanding of various aspects, features and advantages of the technical solutions of the present invention, the present invention will be specifically described below in conjunction with the accompanying drawings. It should be understood that the various implementations described below are only for illustration, rather than limiting the protection scope of the present invention.

[0031] figure 1 It is an example of a schematic flowchart of a data access method based on multiple RAC clusters according to an embodiment of the present invention. refer to figure 1 , the method includes:

[0032] 10: Determine available data sources according to data source configuration information of multiple RAC clusters.

[0033] Optionally, the data source configuration information of multiple RAC clusters in this embodiment may be preconfigured, and may be updated according to specific conditions (for example, fault isolation, data source recovery, etc...

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 multi-RAC cluster system and a data access method and device. The data access method comprises the following steps: determining available data sources according to the data source configuration information of a plurality of RAC clusters; choosing the first data source as a target data source from the available data sources according to a routing policy; according to the target data source, operating a corresponding target database; and calling the target database according to the database operating result or re-choosing the second data source as the target data source. By the multi-RAC cluster system and the data access method and device, new RAC clusters can be flexibly and dynamically added, and halt and maintenance are not required; transparency switching between failed RAC clusters and normal RAC clusters can be realized, the switching time is short, and TPS shaking or failed businesses hardly exists; and the RAC clusters are in equivalent relationship, when in downtime of any one RAC cluster, automatic migration of businesses (such as transaction) can be realized and service to the outside is not affected.

Description

technical field [0001] The present invention relates to the field of RAC clusters, and more specifically, to a multi-RAC cluster system, data access method and device. Background technique [0002] The current Oracle RAC has load balancing and active / standby modes. Load balancing cannot guarantee complete linear expansion after the number of machines increases to a certain level; and the performance of the active / standby mode depends more on the processing power of a single server, which becomes the performance bottleneck of the application. Moreover, in both modes, the entire RAC cluster has been down. Once the RAC cluster is down, the entire application cannot be served externally. If you switch to the standby database, the standby database needs to restart the database due to nomount (that is, not loaded), and generally also needs to restart the application at the same time. [0003] That is to say, whether in load balancing mode or active / standby mode, when any set of ...

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): G06F9/50G06F16/25
CPCG06F9/5088G06F16/25
Inventor 舒展邢磊黎育龙
Owner CHINA CONSTRUCTION BANK
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