CN106095571B - More RAC group systems, data access method and device - Google Patents

More RAC group systems, data access method and device Download PDF

Info

Publication number
CN106095571B
CN106095571B CN201610395910.3A CN201610395910A CN106095571B CN 106095571 B CN106095571 B CN 106095571B CN 201610395910 A CN201610395910 A CN 201610395910A CN 106095571 B CN106095571 B CN 106095571B
Authority
CN
China
Prior art keywords
data source
database
data
according
result
Prior art date
Application number
CN201610395910.3A
Other languages
Chinese (zh)
Other versions
CN106095571A (en
Inventor
舒展
邢磊
黎育龙
Original Assignee
中国建设银行股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 中国建设银行股份有限公司 filed Critical 中国建设银行股份有限公司
Priority to CN201610395910.3A priority Critical patent/CN106095571B/en
Publication of CN106095571A publication Critical patent/CN106095571A/en
Application granted granted Critical
Publication of CN106095571B publication Critical patent/CN106095571B/en

Links

Abstract

The invention discloses a kind of more RAC group systems, data access method and devices, wherein the data access method includes: to determine available data sources according to the data source configuration information of multiple RAC clusters;The first data source is chosen from the available data sources according to routing policy as target data source;Database manipulation is carried out to corresponding target database according to the target data source;The calling of target database is completed according to database manipulation result or again chooses the second data source as the target data source.Using the present invention, it neatly can dynamically increase new RAC cluster without maintenance shut-downs;It can be realized transparent switching of the failure RAC cluster to non-faulting RAC cluster, and switching time is short, substantially without TPS shake and failure business;Multiple RAC clusters are peer-to-peers, any a set of RAC cluster delay machine, can realize that the Autonomic Migration Framework of business (for example, transaction) externally provides service without influencing.

Description

More RAC group systems, data access method and device

Technical field

The present invention relates to RAC cluster fields, more particularly, it is related to a kind of more RAC group systems, data access method And device.

Background technique

Current Oracle RAC has load balancing and active-standby mode.Load balancing goes up to a certain extent in machine quantity Afterwards, fairly linear extension is not ensured that;And active-standby mode performance is more dependent upon single server processing capacity, becomes application Performance bottleneck.And both modes all occurred the case where entire RAC cluster delay machine, once RAC cluster delay machine, then entirely Using can not externally service.If being switched to standby library, standby library needs to restart database due to nomount (that is, not loading), one As also simultaneously need to restart application.

That is, either load-sharing mode or active-standby mode all can in any a set of RAC cluster delay machine Service is externally provided application to affect greatly.And when needing newly-increased RAC cluster, maintenance shut-downs are needed, it is troublesome in poeration.

Summary of the invention

In view of the drawbacks described above of the prior art, embodiment of the present invention provides a kind of more RAC group systems, data access Method and device neatly can dynamically increase new RAC cluster, and can be substantially without TPS (transaction Per second, transaction stroke count per second) shake and failure business effect carry out RAC cluster switching.

Specifically, embodiment of the present invention provides a kind of data access method based on multiple RAC clusters comprising:

Available data sources are determined according to the data source configuration information of multiple RAC clusters;

The first data source is chosen from the available data sources according to routing policy as target data source;

Database manipulation is carried out to corresponding target database according to the target data source;

The calling of target database is completed according to database manipulation result or again chooses the second data source as the mesh Mark data source.

Correspondingly, embodiment of the present invention additionally provides a kind of data access device based on multiple RAC clusters, packet It includes:

Data source management module is stored with the data source configuration information of multiple RAC clusters;

Data access module, comprising:

Determine submodule, the data source configuration information for storing according to the data source management module determines data available Source,

Submodule is chosen, for choosing the first data source from the available data sources according to routing policy as number of targets According to source,

Submodule is operated, for carrying out database manipulation to corresponding target database according to the target data source;

The second data source is called or chosen again to processing module for completing target database according to database manipulation result As the target data source.

Correspondingly, embodiment of the present invention also provides a kind of more RAC group systems comprising multiple RAC clusters and Ben Fa The data access device that bright embodiment provides.

Using embodiment of the present invention, have the advantage that

By configuring the data source configuration information of multiple RAC clusters, (including increase, delete) one can be neatly changed RAC cluster in a system, so as to neatly for example dynamically increase new RAC cluster, without maintenance shut-downs;

By route selecting target data source, it can be realized failure RAC cluster and cut to the transparent of non-faulting RAC cluster It changes, and switching time is short, substantially without TPS shake and failure business (for example, transaction);

Using data access method provided by the invention, multiple RAC clusters are peer-to-peers rather than main and standby relation, all may be used Externally to provide comprehensive read-write database processing simultaneously;

Any a set of RAC cluster delay machine can realize that the Autonomic Migration Framework of business (for example, transaction) is externally mentioned without influencing For service.

Detailed description of the invention

Fig. 1 is a kind of flow diagram of data access method based on multiple RAC clusters according to an embodiment of the present invention An example;

Fig. 2 is a kind of flow diagram of data access method based on multiple RAC clusters according to an embodiment of the present invention Another example;

Fig. 3 is a kind of an example of the block diagram of data access device based on multiple RAC clusters according to an embodiment of the present invention;

Fig. 4 is an example of the block diagram of the operation submodule of data access device shown in Fig. 3;

Fig. 5 is an example of the block diagram of the processing module of data access device shown in Fig. 3;

Fig. 6 is a kind of the another of the block diagram of data access device based on multiple RAC clusters according to an embodiment of the present invention Example;

Fig. 7 is a kind of schematic diagram of more RAC group systems according to an embodiment of the present invention.

Specific embodiment

The various aspects of technical solution, feature and advantage to facilitate the understanding of the present invention, with reference to the accompanying drawing to this hair It is bright to be specifically described.It should be appreciated that following various embodiments are served only for for example, and is not intended to limit the present invention Protection scope.

Fig. 1 is a kind of flow diagram of data access method based on multiple RAC clusters according to an embodiment of the present invention An example.Referring to Fig.1, which comprises

10: available data sources are determined according to the data source configuration information of multiple RAC clusters.

Optionally, the data source configuration information of multiple RAC clusters in the present embodiment can be pre-configured with, and can be It is updated during executing this method according to specific condition (for example, situations such as Fault Isolation, data source are restored).Wherein, each number Have according to source configuration information about the whether available configuration of data source.

12: choosing the first data source from the available data sources according to routing policy as target data source.

In the present embodiment, routing policy can use the existing method of such as minimal path algorithm etc.The present invention couple Specific routing policy is not particularly limited.

14: database manipulation is carried out to corresponding target database according to the target data source.

In the present embodiment, the purpose of database manipulation is effective in order to determine whether to carry out based on target database Database relevant treatment.Optionally, database manipulation includes data manipulation validity check and what database returned the result has The inspection of effect property.

16: choosing the second data source as the number of targets according to database manipulation call by result target database or again According to source.

It should be noted that in the present embodiment, " the first data source " and " the second data source " is intended merely to distinguish not With data source selected in situation, without other meanings.In a preferred embodiment, the second data source and the first data source It is different data source.

It can be neatly by configuring the data source configuration information of multiple RAC clusters using method provided in this embodiment RAC cluster in (including the increasing, deleting) system of change, so as to neatly for example dynamically increase new RAC collection Group, without maintenance shut-downs.By route selecting target data source, failure RAC cluster can be realized to non-faulting RAC cluster Transparent switching, and switching time is short, shakes substantially without TPS and failure business (for example, transaction).It is mentioned using the present invention The data access method of confession, multiple RAC clusters are peer-to-peers rather than main and standby relation, can externally be provided simultaneously comprehensive Read and write database processing.Any a set of RAC cluster delay machine can realize the Autonomic Migration Framework of business (for example, transaction) without shadow It rings and service is externally provided.

There is such transaction system in practical applications, data dependence relation is few between transaction, and only minute quantity is orthogonal Easy negative dealing or connected transaction will use former transaction data.The database of this kind of transaction system is actually during operation such as Fruit delay machine, can directly initiate a set of database come using, performance when something goes wrong, can directly dynamically increase newly a sets of data Pressure is shared in library.Therefore, method provided in this embodiment is especially suitable for the above-mentioned transaction system based on more RAC cluster buildings System.

Optionally, in a kind of implementation of the present embodiment, before processing 10, the method also includes: receive number It determines the need for according to library access request and according to database access request using multiple RAC clusters, for example, being visited according to database The special parameter carried in request is asked to determine, if it is desired, then execute processing 12.If it is not required, then can use existing Mode carries out database access, for example, calling JDBC (connection of Java Data Base Connectivity, java database) Carry out database access.

Optionally, in a kind of implementation of the present embodiment, database manipulation result includes effective, invalid and abnormal. More specifically, processing 14 may include: to check the validity of the data manipulation for the target database, and grasp in data Make in effective situation, checks the validity that database returns the result.Wherein, if data manipulation and database return the result Effectively, then database manipulation result is effective;If data manipulation is invalid, alternatively, if data manipulation effectively database return Results abnormity, then database manipulation results abnormity;If database manipulation is effective and database returns the result in vain, database Operating result is invalid.

In this implementation, the main purpose for carrying out database manipulation is to determine whether based on target data Library carries out effective database relevant treatment.It will be appreciated by those skilled in the art that it can also be used in order to reach the purpose Its existing way, the present invention does not illustrate in detail to this, but this also falls in protection scope of the present invention.

Optionally, in a kind of implementation of the present embodiment, it is effective that processing 16, which includes: in database manipulation result, When, complete the calling of the target database;When database manipulation result is invalid or abnormal, second number is chosen again According to source as the target data source.

Still optionally further, when database manipulation result is invalid, according to the data source switchover policy of pre-configuration from institute Second data source that non-first data source is chosen in available data sources is stated as the target data source.Alternatively, working as When database manipulation result is abnormal, the data source configuration of the first data source according to the abnormality processing policy update of pre-configuration Information, and second data source of non-first data source is chosen as the target data from the available data sources Source.

Wherein, data source switchover policy can be more with configuration data operation exception type, null result judgement and continuous failure The information such as few pen, and can be configured or be changed at any time as needed and be come into force by related personnel.

Wherein it is possible to carry out the number of the first data source according to the abnormality processing policy update of pre-configuration in the following ways According to source configuration information: judging whether data manipulation result is isolation sexual abnormality, if it is isolation sexual abnormality, then for described first Data source carries out Fault Isolation and carries out data health examination (for example, data health examination team is added in first data source Column), if inspection result is available for the first data source, restores the first data source and data available is added in the first data source Source.It should be noted that in this implementation, it, then can be according to normal database access if it is non-isolated sexual abnormality Abnormality processing is directly thrown to after encapsulation using processing or Fail Transaction;If inspection result is that the first data source is unavailable, It then can directly carry out subsequent data source hand-off process;The present invention is not particularly limited both of these case.

It should be noted that in this implementation, when needing to carry out data source switching, in order to improve efficiency, preferably Ground, in the case where database manipulation result is exception, for the processing and the processing of the second data source of selection of the first data source It is asynchronously, to improve data source switching efficiency.Certainly, if not considering switching efficiency, the first data can also first be updated The data source configuration information in source chooses the second data source again.

Optionally, in a kind of implementation of the present embodiment, the method also includes: monitor the pressure of multiple RAC clusters Power, and when pressure reaches setting condition, the data source configuration information by increasing new RAC cluster increases new RAC cluster. Using this implementation, it can dynamically increase new RAC cluster as needed without restarting whole system.

Optionally, in a kind of implementation of the present embodiment, the method also includes: according to whether can be used in the presence of described in Data source carries out the switching between database and file system;In the case where no available data sources, database is visited It asks and is converted to file access.

Fig. 2 is a kind of flow diagram of data access method based on multiple RAC clusters according to an embodiment of the present invention Another example, referring to Fig. 2, which comprises

20: receiving database access request.

21: judging whether to need using multiple RAC clusters.If it is required, then executing processing 22;If it is not required, then adjusting Database access is carried out with JDBC.

22: determining target data source by modes such as Route Selection, routing path calculations.

23: opening affairs.

24: carrying out database manipulation for target data source.

25: the validity of detection data operation.If it is valid, executing 26, otherwise database of descriptions operating result is different Often, 27 are executed.

26: judging the validity that database returns the result.If it is valid, terminating database access, database tune is completed With.If invalid, 28 are executed;If abnormal, 27 are executed.

27: judging whether abnormal be isolation sexual abnormality, for example, being carried out by fault monitor module as shown in dotted outline in FIG. The judgement.If it is determined that then executing 29 for isolation sexual abnormality;It, can be according to normal data if it is non-isolated sexual abnormality Access exception processing in library is directly thrown to after encapsulation using processing or Fail Transaction.

28: carrying out data source hand-off process.For example, choosing other data sources from the available data sources as new mesh Mark data source.Optionally, when carrying out data source hand-off process, plan can be switched according to pre-configuration or configurable data source Slightly carry out data source hand-off process.

29: Fault Isolation and data health examination.That is, carrying out Fault Isolation and data health for first data source It checks.

30: fault recovery and available data sources update.Specifically, being the case where the first data source can be used in inspection result Under, restore first data source and the available data sources are added in first data source.It is the first number in inspection result When unavailable according to source, subsequent data source hand-off process can be directly carried out.

As indicated by a dashed arrow in the figure, after exception being returned the result determining database, alternatively, after step 30 Trigger step 28.

Using method provided in this embodiment, equally has the advantages that embodiment illustrated in fig. 1.

Fig. 3 is a kind of an example of the block diagram of data access device based on multiple RAC clusters according to an embodiment of the present invention, Referring to Fig. 3, the data access device includes: data source management module 31, Data access module 32 and processing module 33, below Specifically it is illustrated.

In the present embodiment, data source management module 31 is stored with the data source configuration information of multiple RAC clusters.Wherein, Each data source configuration information has about the whether available configuration of data source.

Data access module 32 comprises determining that submodule 321, the data for being stored according to the data source management module Source configuration information determines available data sources;Submodule 322 is chosen, for choosing from the available data sources according to routing policy First data source is as target data source;Submodule 323 is operated, is used for according to the target data source to corresponding target data Library carries out database manipulation.

Processing module 33 is used to complete the calling of target database according to database manipulation result or chooses the second number again According to source as the target data source.

Using data access device provided in this embodiment, can neatly change (including increase, delete) one is RAC cluster in system, so as to neatly for example dynamically increase new RAC cluster, without maintenance shut-downs.Pass through routing Target data source is chosen, can be realized transparent switching of the failure RAC cluster to non-faulting RAC cluster, and switching time is short, Substantially without TPS shake and failure business (for example, transaction).Using data access device provided by the invention, by multiple RAC collection Group is treated with peer-to-peer rather than main and standby relation, can externally provide comprehensive read-write database processing simultaneously.Any one RAC cluster delay machine is covered, can realize that the Autonomic Migration Framework of business (for example, transaction) externally provides service without influencing.

Optionally, in a kind of implementation of the present embodiment, as shown in dotted line frame in Fig. 3, Data access module 32 is also Submodule 320 is handled including request, library access request and need are being determined according to the database access request for receiving data The determining submodule 321 is triggered in the case where using the multiple RAC cluster.

Optionally, in a kind of implementation of the present embodiment, as shown in figure 4, operation submodule 323 includes: the first inspection Verification certificate member, for checking the validity for being directed to the data manipulation of the target database, and in the effective situation of data manipulation Triggering second checks module;Second inspection unit, the validity returned the result for checking database.Wherein, if data are grasped Make and database returns the result effectively, then database manipulation result is effective;If data manipulation is invalid, alternatively, if data Operation is effective and database returns the result exception, then database manipulation results abnormity;If database manipulation effectively database It is invalid to return the result, then database manipulation result is invalid.

Optionally, in a kind of implementation of the present embodiment, processing module 33 is specifically used in database manipulation result When being effective, the calling of the target database is completed;When database manipulation result is invalid or abnormal, again described in selection Second data source is as the target data source.

Still optionally further, as shown in figure 5, processing module 33 includes: the first gravity treatment submodule 331, in database When operating result is invalid, non-first number is chosen from the available data sources according to the data source switchover policy of pre-configuration According to second data source in source as the target data source;Second gravity treatment submodule 332, in database manipulation result When being abnormal, the data source configuration information of the first data source according to the abnormality processing policy update of pre-configuration, and from described Second data source of non-first data source is chosen in available data sources as the target data source.

Still optionally further, as shown in dotted line frame in Fig. 5, the second gravity treatment submodule 332 may include: malfunction monitoring list Member is isolation for judging whether the database manipulation result is isolation sexual abnormality, and in the database manipulation result Fault Isolation and recovery unit are called in the case where exception;Fault Isolation and recovery unit, for first data source to be isolated And data health examination is carried out to first data source, and when inspection result is that first data are available, described in recovery Simultaneously the available data sources are added in first data source by the first data source.

Optionally, in a kind of implementation of the present embodiment, data processing equipment can also include dynamic processing module, For monitoring the pressure of the multiple RAC cluster, and when pressure reaches setting condition, by the number for increasing new RAC cluster Increase new RAC cluster according to source configuration information.

Optionally, in a kind of implementation of the present embodiment, data processing equipment can also include: resource switch mould Block, for according to whether there are the available data sources to carry out the switching between database and file system;File resource access Module, in the case where no available data sources, database access to be converted to file access.

It will be appreciated by those skilled in the art that side provided by the invention may be implemented in Installation practice provided by the invention Method, and method provided by the invention can be understood as the logical process process of Installation practice provided by the invention, therefore, In the device of the invention embodiment, processing is handled or can be performed performed by modules, submodule, unit, subelement It is believed that explanation, refers to the explanation in embodiment of the method, does not repeat herein.

Fig. 6 is a kind of the another of the block diagram of data access device based on multiple RAC clusters according to an embodiment of the present invention Example, referring to Fig. 6, data access device includes: data access routing component, data source management assembly, resource switch management assembly, Data health examination component, fault insulation and resume component, malfunction monitoring component, file resource access component, data source configuration Component and abnormality processing strategy configuration component.It is specifically described below.

In the present embodiment, it is deposited in data source management assembly (effect is similar to the data source management module 31 being mentioned above) Contain the data source configuration information of multiple RAC clusters.

Exception policy configuration information is stored in abnormality processing strategy configuration component.Data access routing component can pass through Abnormality processing strategy configuration component chooses abnormality processing strategy and carries out abnormality processing.

Data access routing component (effect is similar to the Data access module 32 being mentioned above) is for carrying out the following processing: Judge whether to need using more RAC clusters according to the parameter in database access request, if it is desired, then from the data source capsule Manage component and obtain available data sources, and carry out selection routing policy, calculate data access path, setting routing access path etc. Reason is to determine target data source.Affairs are opened, database access operation is carried out to target database according to target data source.

Malfunction monitoring component (effect is similar to the malfunction monitoring unit being mentioned above) is for monitoring whether that mesh can be based on It marks database and completes database access processing.It include: to have been returned the result for carrying out data manipulation validity check and database Effect property inspection, as previously mentioned, the two determines that database manipulation result is effective, invalid or abnormal.If database manipulation knot Fruit be it is effective, then complete to the calling of target database.If database manipulation result is invalid, trigger data access routing Component chooses other data sources as target data source and carries out database access.If database manipulation result is exception, sentence Whether disconnected database manipulation result is isolation sexual abnormality, and calls trigger data health examination for isolation sexual abnormality Component, fault insulation and resume component and data source configuration component (effect of three be similar to the Fault Isolation being mentioned above and Restore subelement).

Fault insulation and resume component is used to that target data source to be isolated and trigger when database is isolation sexual abnormality extremely Data health examination component carries out health examination to target data source, if inspection result is available for target data source, triggers Fault insulation and resume component restores target data source, and target data source is added by data source configuration component and can be used In data source.

In fault insulation and resume component, data health examination component and the data source configuration component course of work, alternatively, After available data sources are added in target data source by data source configuration component, data access routing component can choose target again Data source repeats the subsequent processings such as database manipulation in turn.

Resource switch management assembly (effect is similar to the resource switch module being mentioned above) is for according to whether in the presence of can The switching between database and file system is carried out with data source.

File resource accesses component, and (effect is similar to the file resource access modules being mentioned above) be not for described In the case where available data sources, database access is converted into file access.

Comparison diagram 3- embodiment illustrated in fig. 5 or implementation and embodiment illustrated in fig. 6, those skilled in the art should manage It solves, the concrete function in data processing equipment is not limited to by single Implement of Function Module, but can according to need flexibly Different functional modules is set.That is, the present invention protects the logical process process of data processing equipment, and not to specifically by which A specific module realizes that concrete function is limited, those skilled in the art according to the present invention the enlightenment of Installation practice and set Meter has the functional module different from data processing equipment of the invention but realizes patrolling for data processing equipment of the invention The data access device for collecting treatment process is also fallen in protection scope of the present invention.

Fig. 7 is a kind of schematic diagram of more RAC group systems according to an embodiment of the present invention.Referring to Fig. 7, more RAC clusters system System includes data access device and multiple RAC clusters (for example, two or more RAC clusters).In the present embodiment, data Access mechanism can receive the external access request sent by multiple AP (access points) connected to it.It is visited about data Ask that the explanation of device refers to above, details are not described herein again.Wherein, multiple RAC clusters are peer-to-peer, i.e., they can be same When comprehensive read-write database processing is externally provided.

It, can be by Spring's (a kind of existing Open Framework) in a kind of concrete application of the invention Mutildatasource realizes database routing, borrows ibatis (a kind of existing open source projects) and carries out database access.When So this only illustrates, and those skilled in the art can flexibly use different designs.

Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be by The mode of software combination hardware platform is realized.Based on this understanding, technical solution of the present invention makes tribute to background technique That offers can be embodied in the form of software products in whole or in part, which can store is situated between in storage In matter, such as ROM/RAM, magnetic disk, CD, including some instructions use is so that a computer equipment (can be individual calculus Machine, server or network equipment etc.) execute method described in certain parts of each embodiment of the present invention or embodiment.

Skilled person should be appreciated that disclosed above is only embodiments of the present invention, certainly cannot be with This interest field to limit the present invention still belongs to the claims in the present invention institute according to equivalent variations made by embodiment of the present invention The range covered.

Claims (15)

1. a kind of data access method based on multiple RAC clusters, which is characterized in that the described method includes:
Available data sources are determined according to the data source configuration information of multiple RAC clusters;
The first data source is chosen from the available data sources according to routing policy as target data source;
Database manipulation is carried out to corresponding target database according to the target data source;
The calling of target database is completed according to database manipulation result or again chooses the second data source as the number of targets According to source;
Wherein, carrying out database manipulation to corresponding target database according to the target data source includes:
It checks the validity of the data manipulation for the target database, and in the effective situation of data manipulation, checks number The validity returned the result according to library;Wherein,
If data manipulation and database return the result effectively, database manipulation result is effective,
If data manipulation is invalid, alternatively, database returns the result exception, database manipulation knot if data manipulation is effective Fruit is abnormal,
If database manipulation is effective and database returns the result in vain, database manipulation result is invalid.
2. the method as described in claim 1, which is characterized in that the method also includes:
When needing according to the database access request received is determining using multiple RAC clusters, according to the multiple RAC cluster Data source configuration information determine the available data sources.
3. described in any item methods as in claims 1 and 2, which is characterized in that complete target according to database manipulation result The calling of database chooses the second data source as the target data source again and includes:
When database manipulation result is effective, the calling of the target database is completed;
When database manipulation result is invalid or abnormal, second data source is chosen again as the target data source.
4. method as claimed in claim 3, which is characterized in that choose the second data source again as the target data source packet It includes:
When database manipulation result is invalid, chosen from the available data sources according to the data source switchover policy of pre-configuration Second data source of non-first data source is as the target data source;
When database manipulation result is abnormal, the data of the first data source according to the abnormality processing policy update of pre-configuration Source configuration information, and second data source of non-first data source is chosen as the mesh from the available data sources Mark data source.
5. method as claimed in claim 4, which is characterized in that the first number according to the abnormality processing policy update of pre-configuration Include: according to the data source configuration information in source
If whether the database manipulation result is isolation sexual abnormality, Fault Isolation is carried out simultaneously for first data source Data health examination is carried out, if inspection result is that first data source can be used, restores first data source and by institute It states the first data source and the available data sources is added.
6. the method as described in claim 1, which is characterized in that the method also includes:
The pressure of the multiple RAC cluster is monitored, and when pressure reaches setting condition, by the number for increasing new RAC cluster Increase new RAC cluster according to source configuration information.
7. the method as described in claim 1, which is characterized in that the method also includes:
According to whether there are the available data sources to carry out the switching between database and file system;
In the case where no available data sources, database access is converted into file access.
8. a kind of data access device based on multiple RAC clusters, which is characterized in that the data access device includes:
Data source management module is stored with the data source configuration information of multiple RAC clusters;
Data access module, comprising:
Determining submodule, the data source configuration information for being stored according to the data source management module determines available data sources,
Submodule is chosen, for choosing the first data source from the available data sources according to routing policy as target data Source,
Submodule is operated, for carrying out database manipulation to corresponding target database according to the target data source;
The second data source conduct is called or chosen again to processing module for completing target database according to database manipulation result The target data source;
Wherein, the operation submodule includes:
First inspection unit for checking the validity for being directed to the data manipulation of the target database, and has in data manipulation Triggering second checks module in the case where effect;
Second inspection unit, the validity returned the result for checking database;
Wherein, if data manipulation and database return the result effectively, database manipulation result is effective,
If data manipulation is invalid, alternatively, database returns the result exception, database manipulation knot if data manipulation is effective Fruit is abnormal,
If database manipulation is effective and database returns the result in vain, database manipulation result is invalid.
9. device as claimed in claim 8, which is characterized in that the Data access module further include:
Request processing submodule, for receiving data library access request and according to the database access request determine need make The determining submodule is triggered in the case where the multiple RAC cluster.
10. the device as described in any one of claim 8 and 9, which is characterized in that the processing module is used for:
When the database manipulation result is effective, the calling of the target database is completed;
When the database manipulation result is invalid or abnormal, second data source is chosen again as the target data Source.
11. device as claimed in claim 10, which is characterized in that the processing module includes:
First gravity treatment submodule, for database manipulation result be it is invalid when, according to the data source switchover policy of pre-configuration from Second data source of non-first data source is chosen in the available data sources as the target data source;
Second gravity treatment submodule is used for when database manipulation result is abnormal, according to the abnormality processing policy update of pre-configuration The data source configuration information of first data source, and chosen described in non-first data source from the available data sources Second data source is as the target data source.
12. device as claimed in claim 11, which is characterized in that the second gravity treatment submodule includes:
Malfunction monitoring unit for judging whether the database manipulation result is isolation sexual abnormality, and is grasped in the database Fault Isolation and recovery unit are called in the case where making result as isolation sexual abnormality;
Fault Isolation and recovery unit, for first data source to be isolated and carries out the inspection of data health to first data source It looks into, and when inspection result is that first data are available, restores first data source and first data source is added The available data sources.
13. device as claimed in claim 8, which is characterized in that described device further include:
Dynamic processing module passes through increasing for monitoring the pressure of the multiple RAC cluster, and when pressure reaches setting condition The data source configuration information of new RAC cluster is added to increase new RAC cluster.
14. device as claimed in claim 8, which is characterized in that described device further include:
Resource switch module, for according to whether there are the available data sources to carry out cutting between database and file system It changes;
File resource access modules, in the case where no available data sources, database access to be converted to file Access.
15. a kind of more RAC group systems, which is characterized in that including multiple RAC clusters and such as any one of claim 8-14 institute The data access device stated.
CN201610395910.3A 2016-06-07 2016-06-07 More RAC group systems, data access method and device CN106095571B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610395910.3A CN106095571B (en) 2016-06-07 2016-06-07 More RAC group systems, data access method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610395910.3A CN106095571B (en) 2016-06-07 2016-06-07 More RAC group systems, data access method and device

Publications (2)

Publication Number Publication Date
CN106095571A CN106095571A (en) 2016-11-09
CN106095571B true CN106095571B (en) 2019-06-04

Family

ID=57447834

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610395910.3A CN106095571B (en) 2016-06-07 2016-06-07 More RAC group systems, data access method and device

Country Status (1)

Country Link
CN (1) CN106095571B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103124967A (en) * 2010-09-15 2013-05-29 甲骨文国际公司 System and method for connecting an application server with a clustered database
CN103838770A (en) * 2012-11-26 2014-06-04 中国移动通信集团北京有限公司 Logic data partition method and system
CN104503751A (en) * 2014-12-16 2015-04-08 深圳中兴网信科技有限公司 SOA-based data source switching method and system
CN104794026A (en) * 2015-04-29 2015-07-22 上海新炬网络信息技术有限公司 Cluster instance and multi-data-source binding failover method

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10148610B2 (en) * 2013-02-26 2018-12-04 Dell Products L.P. Method to publish remote management services over link local network for zero-touch discovery, provisioning, and management

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103124967A (en) * 2010-09-15 2013-05-29 甲骨文国际公司 System and method for connecting an application server with a clustered database
CN103838770A (en) * 2012-11-26 2014-06-04 中国移动通信集团北京有限公司 Logic data partition method and system
CN104503751A (en) * 2014-12-16 2015-04-08 深圳中兴网信科技有限公司 SOA-based data source switching method and system
CN104794026A (en) * 2015-04-29 2015-07-22 上海新炬网络信息技术有限公司 Cluster instance and multi-data-source binding failover method

Also Published As

Publication number Publication date
CN106095571A (en) 2016-11-09

Similar Documents

Publication Publication Date Title
AU718006B2 (en) Fail-safe event driven transaction processing system and method
US7934262B1 (en) Methods and apparatus for virus detection using journal data
US20060224775A1 (en) Contents synchronization system in network enviroment and a method therefor
US9122600B2 (en) Systems and methods for remote monitoring in a computer network
CN103281301B (en) Cloud security system and method for determining malicious programs
US9519656B2 (en) System and method for providing a virtualized replication and high availability environment
US7779298B2 (en) Distributed job manager recovery
US6915457B1 (en) Apparatus and method for monitoring messages forwarded between applications
EP2169909A1 (en) System and method to maintain coherence of cache contents in a multi-tier software system aimed at interfacing large databases
US7076801B2 (en) Intrusion tolerant server system
US8826290B2 (en) Method of monitoring performance of virtual computer and apparatus using the method
US7124139B2 (en) Method and apparatus for managing faults in storage system having job management function
Castelli et al. Proactive management of software aging
US20130227340A1 (en) Fault tolerant routing in a non-hot-standby configuration of a network routing system
US20120030346A1 (en) Method for inferring extent of impact of configuration change event on system failure
US7296268B2 (en) Dynamic monitor and controller of availability of a load-balancing cluster
US5664155A (en) Dynamically assigning a dump space in a shared data facility to receive dumping information to be captured
US7478097B2 (en) Application governor providing application-level autonomic control within a distributed computing system
EP2306315A1 (en) Fast determination of compatibility of virtual machines and hosts
US20030112746A1 (en) System and method for providing detection of faults and switching of fabrics in a redundant-architecture communication system
US20150149822A1 (en) Event handling in storage area networks
AU718427B2 (en) Method and apparatus for handling processing errors in telecommunications exchanges
US20080263111A1 (en) Storage operation management program and method and a storage management computer
US7730274B1 (en) Preventing undesired trespass in storage arrays
US20080310431A1 (en) Method for automatic discovery of a transaction gateway daemon of specified type

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
GR01 Patent grant