CN106095571B - More RAC group systems, data access method and device - Google Patents
More RAC group systems, data access method and device Download PDFInfo
- 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
- target
- rac
- Prior art date
- Legal status (The legal status 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 status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000012545 processing Methods 0.000 claims description 43
- 238000002955 isolation Methods 0.000 claims description 27
- 230000002159 abnormal effect Effects 0.000 claims description 26
- 230000036541 health Effects 0.000 claims description 12
- 238000011084 recovery Methods 0.000 claims description 12
- 238000012544 monitoring process Methods 0.000 claims description 9
- 238000012423 maintenance Methods 0.000 abstract description 5
- 238000013508 migration Methods 0.000 abstract description 4
- 230000005012 migration Effects 0.000 abstract description 4
- 230000002567 autonomic effect Effects 0.000 abstract 1
- 230000008569 process Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 8
- 238000013461 design Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 108010001267 Protein Subunits Proteins 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5083—Techniques for rebalancing the load in a distributed system
- G06F9/5088—Techniques for rebalancing the load in a distributed system involving task migration
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
Technical Field
The present invention relates to the field of RAC clusters, and more particularly, to a multi-RAC cluster system, a data access method, and an apparatus.
Background
The current Oracle RAC has load balancing and active/standby modes. Load balancing cannot guarantee complete linear expansion after the number of machines rises to a certain degree; the performance of the active/standby mode depends on the processing capacity of a single server, and becomes the performance bottleneck of the application. In both modes, the crash of the whole RAC cluster occurs, and once the RAC cluster crashes, the whole application cannot be served to the outside. If the backup library is switched to, the backup library needs to restart the database due to the nomount (i.e., unloaded), and generally also needs to restart the application at the same time.
That is, no matter in the load balancing mode or the active/standby mode, when any set of RAC clusters goes down, the application will be greatly affected to provide the service. And when an RAC cluster needs to be newly added, shutdown maintenance is needed, and operation is troublesome.
Disclosure of Invention
In view of the foregoing defects in the prior art, embodiments of the present invention provide a multi-RAC cluster system, a data access method, and a data access device, which are capable of flexibly and dynamically adding a new RAC cluster and performing RAC cluster switching with the effect of substantially no TPS (transaction per second) jitter and no failed traffic.
Specifically, an embodiment of the present invention provides a data access method based on multiple RAC clusters, which includes:
determining available data sources according to the data source configuration information of the RAC clusters;
selecting a first data source from the available data sources as a target data source according to a routing strategy;
performing database operation on the corresponding target database according to the target data source;
and completing the calling of the target database or reselecting a second data source as the target data source according to the database operation result.
Correspondingly, the embodiment of the present invention further provides a data access device based on multiple RAC clusters, which includes:
the data source management module stores data source configuration information of a plurality of RAC clusters;
a data access module comprising:
a determining submodule for determining an available data source according to the data source configuration information stored in the data source management module,
a selection submodule for selecting a first data source from the available data sources as a target data source according to a routing policy,
the operation submodule is used for carrying out database operation on the corresponding target database according to the target data source;
and the processing module is used for completing the calling of the target database or reselecting a second data source as the target data source according to the operation result of the database.
Correspondingly, the embodiment of the invention also provides a multi-RAC cluster system which comprises a plurality of RACs and the data access device provided by the embodiment of the invention.
The implementation mode of the invention has the following advantages:
the RAC cluster in one system can be flexibly changed (including adding, deleting and the like) by configuring the data source configuration information of a plurality of RAC clusters, so that a new RAC cluster can be flexibly and dynamically added without shutdown maintenance;
the target data source is selected through the route, transparent switching from a fault RAC cluster to a non-fault RAC cluster can be realized, the switching time is short, and TPS jitter and failure services (such as transaction) are basically avoided;
by adopting the data access method provided by the invention, a plurality of RAC clusters are in peer-to-peer relation instead of primary-standby relation, and can simultaneously provide comprehensive read-write database processing to the outside;
any set of RAC cluster is down, and automatic migration of services (such as transactions) can be achieved without influencing external service provision.
Drawings
Fig. 1 is an example of a flow chart of a data access method based on multiple RAC clusters according to an embodiment of the present invention;
fig. 2 is another example of a flow chart of a data access method based on multiple RAC clusters according to an embodiment of the present invention;
fig. 3 is an example of a block diagram of a data access apparatus based on a plurality of RAC clusters according to an embodiment of the present invention;
FIG. 4 is an example of a block diagram of an operational submodule of the data access device of FIG. 3;
FIG. 5 is an example of a block diagram of a processing module of the data access device shown in FIG. 3;
fig. 6 is another example of a block diagram of a data access apparatus based on a plurality of RAC clusters according to an embodiment of the present invention;
fig. 7 is a schematic diagram of a multi-RAC cluster system according to an embodiment of the present invention.
Detailed Description
To facilitate an understanding of the various aspects, features and advantages of the present inventive subject matter, reference is made to the following detailed description taken in conjunction with the accompanying drawings. It should be understood that the various embodiments described below are illustrative only and are not intended to limit the scope of the invention.
Fig. 1 is an example of a flow chart of a data access method based on multiple RAC clusters according to an embodiment of the present invention. Referring to fig. 1, the method includes:
10: and determining available data sources according to the data source configuration information of the RAC clusters.
Optionally, the data source configuration information of the plurality of RAC clusters in this embodiment may be configured in advance, and may be updated according to a specific situation (for example, a situation of fault isolation, data source recovery, etc.) in the process of executing the method. Wherein each data source configuration information has a configuration as to whether a data source is available.
12: and selecting a first data source from the available data sources as a target data source according to the routing strategy.
In this embodiment, the routing policy may employ existing methods such as minimum path algorithm. The present invention is not particularly limited to a particular routing policy.
14: and performing database operation on the corresponding target database according to the target data source.
In the present embodiment, the purpose of the database operation is to determine whether effective database-related processing can be performed based on the target database. Optionally, the database operation includes a data operation validity check and a database return result validity check.
16: and calling a target database or reselecting a second data source as the target data source according to the database operation result.
It should be noted that, in the present embodiment, the "first data source" and the "second data source" are only used to distinguish data sources selected in different situations, and do not have other meanings. In a preferred embodiment, the second data source is a different data source than the first data source.
By adopting the method provided by the embodiment, the RAC clusters in one system can be flexibly changed (including addition, deletion and the like) by configuring the data source configuration information of a plurality of RAC clusters, so that a new RAC cluster can be flexibly and dynamically added without shutdown maintenance, for example. By routing and selecting the target data source, transparent switching from a fault RAC cluster to a non-fault RAC cluster can be realized, the switching time is short, and TPS jitter and failure services (such as transactions) are basically avoided. By adopting the data access method provided by the invention, a plurality of RAC clusters are in peer-to-peer relation instead of primary-standby relation, and can simultaneously provide comprehensive read-write database processing for the outside. Any set of RAC cluster is down, and automatic migration of services (such as transactions) can be achieved without influencing external service provision.
In practical application, the transaction system has few data dependency relations among transactions, and only a few inverse transactions or related transactions of positive transactions use original transaction data. The database of the transaction system can be directly started for use if the database is down during the operation period, and when the performance is in problem, a set of database can be directly and dynamically added to share the stress. Therefore, the method provided by the embodiment is particularly suitable for the transaction system built based on multiple RAC clusters.
Optionally, in an implementation manner of this embodiment, before the processing 10, the method further includes: receiving a database access request and determining whether a plurality of RAC clusters need to be used according to the database access request, for example, according to a specific parameter carried in the database access request, and if so, executing process 12. If not, the database access can be performed in the existing manner, for example, by calling JDBC (Java Data Base Connectivity, Java database connection) to perform the database access.
Optionally, in an implementation manner of this embodiment, the database operation result includes valid, invalid and abnormal. More specifically, process 14 may include: and checking the validity of the data operation aiming at the target database, and checking the validity of the database return result under the condition that the data operation is valid. If the data operation result and the database return result are both effective, the database operation result is effective; if the data operation is invalid, or if the data operation is valid and the database return result is abnormal, the database operation result is abnormal; if the database operation is valid and the database return result is invalid, the database operation result is invalid.
In this implementation, the primary purpose of performing database operations is to determine whether effective database-related processing can be performed based on the target database. It will be appreciated by those skilled in the art that other known ways of achieving this object may be used and that the present invention is not illustrated in detail but falls within the scope of the invention.
Optionally, in an implementation manner of this embodiment, the processing 16 includes: when the operation result of the database is valid, completing the calling of the target database; and when the operation result of the database is invalid or abnormal, reselecting the second data source as the target data source.
Further optionally, when the database operation result is invalid, selecting the second data source, which is not the first data source, from the available data sources as the target data source according to a preconfigured data source switching policy. Or when the operation result of the database is abnormal, updating the data source configuration information of the first data source according to a pre-configured abnormal processing strategy, and selecting the second data source which is not the first data source from the available data sources as the target data source.
The data source switching strategy can configure information such as data operation abnormal types, invalid result judgment, continuous failure times and the like, and can be configured or changed at any time by related personnel as required and take effect.
Wherein the data source configuration information of the first data source may be updated according to a preconfigured exception handling policy in the following manner: and judging whether the data operation result is isolation abnormity, if so, performing fault isolation and data health check on the first data source (for example, adding the first data source into a data health check queue), and if so, recovering the first data source and adding the first data source into an available data source. It should be noted that, in this implementation, if the exception is a non-isolated exception, the exception handling may be accessed according to a normal database, that is, directly encapsulated and then discarded to the application for processing or transaction failure; if the checking result is that the first data source is unavailable, the subsequent data source switching processing can be directly carried out; the present invention is not particularly limited to these two cases.
It should be noted that, in this implementation, when data source switching is required, in order to improve efficiency, it is preferable that, when a result of the database operation is abnormal, processing for the first data source and processing for selecting the second data source are asynchronous, so as to improve data source switching efficiency. Of course, if the switching efficiency is not considered, the data source configuration information of the first data source may be updated first, and then the second data source may be selected.
Optionally, in an implementation manner of this embodiment, the method further includes: and monitoring the pressure of the plurality of RAC clusters, and adding a new RAC cluster by adding the data source configuration information of the new RAC cluster when the pressure reaches a set condition. By adopting the implementation mode, the new RAC cluster can be dynamically added according to the requirement without restarting the whole system.
Optionally, in an implementation manner of this embodiment, the method further includes: switching between the database and the file system according to whether the available data source exists; in the absence of the available data source, converting the database access to a file access.
Fig. 2 is another example of a flow chart of a data access method based on multiple RAC clusters according to an embodiment of the present invention, and referring to fig. 2, the method includes:
20: a database access request is received.
21: it is determined whether multiple RAC clusters need to be used. If so, perform process 22; if not, the JDBC is called for database access.
22: and determining a target data source through a routing selection mode, a routing path calculation mode and the like.
23: the transaction is opened.
24: and carrying out database operation aiming at the target data source.
25: the validity of the data operation is detected. If valid, 26 is executed, otherwise 27 is executed, which indicates that the database operation result is abnormal.
26: and judging the effectiveness of the returned result of the database. If the database is valid, the database access is finished, and the database call is completed. If not, execution 28; if so, 27 is executed.
27: it is determined whether the anomaly is an isolation anomaly, for example, by a fault monitoring module as indicated by the dashed box in the figure. If it is determined to be an isolation exception, execution 29; if the exception is a non-isolation exception, exception processing can be accessed according to a normal database, namely the exception is directly packaged and then thrown to an application for processing or a transaction fails.
28: and carrying out data source switching processing. For example, other data sources are selected from the available data sources as new target data sources. Optionally, when the data source switching process is performed, the data source switching process may be performed according to a preconfigured or configurable data source switching policy.
29: fault isolation and data health check. Namely, fault isolation and data health checks are performed for the first data source.
30: failure recovery and available data source updates. Specifically, in the case that the first data source is available as a result of the check, the first data source is recovered and added to the available data source. When the checking result is that the first data source is unavailable, the subsequent data source switching processing can be directly carried out.
Step 28 may be triggered after determining that the database returns a result exception, or after step 30, as indicated by the dashed arrow.
The method provided by the embodiment also has the advantages of the embodiment shown in the figure 1.
Fig. 3 is an example of a block diagram of a data access apparatus based on a plurality of RAC clusters according to an embodiment of the present invention, and referring to fig. 3, the data access apparatus includes: the data source management module 31, the data access module 32, and the processing module 33 are described in detail below.
In this embodiment, the data source management module 31 stores data source configuration information of a plurality of RAC clusters. Wherein each data source configuration information has a configuration as to whether a data source is available.
The data access module 32 includes: the determining submodule 321 is configured to determine an available data source according to the data source configuration information stored in the data source management module; a selecting submodule 322, configured to select a first data source from the available data sources as a target data source according to a routing policy; the operation sub-module 323 is configured to perform a database operation on the corresponding target database according to the target data source.
The processing module 33 is configured to complete the call of the target database or reselect the second data source as the target data source according to the database operation result.
By adopting the data access device provided by the embodiment, the RAC cluster in one system can be flexibly changed (including adding, deleting and the like), so that a new RAC cluster can be flexibly and dynamically added without shutdown maintenance. By routing and selecting the target data source, transparent switching from a fault RAC cluster to a non-fault RAC cluster can be realized, the switching time is short, and TPS jitter and failure services (such as transactions) are basically avoided. By adopting the data access device provided by the invention, a plurality of RAC clusters are treated in a peer-to-peer relationship instead of a main-standby relationship, and can simultaneously and externally provide comprehensive read-write database processing. Any set of RAC cluster is down, and automatic migration of services (such as transactions) can be achieved without influencing external service provision.
Optionally, in an implementation manner of this embodiment, as shown in a dashed box in fig. 3, the data access module 32 further includes a request processing sub-module 320, configured to receive a database access request and trigger the determining sub-module 321 when it is determined that the plurality of RAC clusters need to be used according to the database access request.
Optionally, in an implementation manner of this embodiment, as shown in fig. 4, the operation sub-module 323 includes: the first checking unit is used for checking the validity of the data operation aiming at the target database and triggering the second checking module under the condition that the data operation is valid; and the second checking unit is used for checking the validity of the returned result of the database. If the data operation result and the database return result are both effective, the database operation result is effective; if the data operation is invalid, or if the data operation is valid and the database return result is abnormal, the database operation result is abnormal; if the database operation is valid and the database return result is invalid, the database operation result is invalid.
Optionally, in an implementation manner of this embodiment, the processing module 33 is specifically configured to complete the call of the target database when the database operation result is valid; and when the operation result of the database is invalid or abnormal, reselecting the second data source as the target data source.
Further optionally, as shown in fig. 5, the processing module 33 includes: the first reselection submodule 331 is configured to, when the database operation result is invalid, select, according to a preconfigured data source switching policy, the second data source, which is not the first data source, from the available data sources as the target data source; and the second reselection submodule 332 is configured to, when the database operation result is abnormal, update the data source configuration information of the first data source according to a preconfigured exception handling policy, and select the second data source, which is not the first data source, from the available data sources as the target data source.
Further optionally, as shown by the dashed box in fig. 5, the second reselection sub-module 332 may include: the fault monitoring unit is used for judging whether the operation result of the database is isolation abnormity or not and calling the fault isolation and recovery unit under the condition that the operation result of the database is isolation abnormity; and the fault isolation and recovery unit is used for isolating the first data source, performing data health check on the first data source, and recovering the first data source and adding the first data source into the available data source when the check result shows that the first data is available.
Optionally, in an implementation manner of this embodiment, the data processing apparatus may further include a dynamic processing module, configured to monitor pressure of the plurality of RAC clusters, and add a new RAC cluster by adding data source configuration information of the new RAC cluster when the pressure reaches a set condition.
Optionally, in an implementation manner of this embodiment, the data processing apparatus may further include: the resource switching module is used for switching between the database and the file system according to whether the available data source exists or not; and the file resource access module is used for converting the database access into the file access under the condition that the available data source does not exist.
It should be understood by those skilled in the art that the method provided by the present invention may be implemented by the apparatus embodiment provided by the present invention, and the method provided by the present invention may also be understood as a logic processing procedure of the apparatus embodiment provided by the present invention, so that, in the apparatus embodiment of the present invention, please refer to the description in the method embodiment for the belief description of the processing executed or executable by each module, sub-module, unit, and sub-unit, which is not described herein again.
Fig. 6 is another example of a block diagram of a data access apparatus based on a plurality of RAC clusters according to an embodiment of the present invention, and referring to fig. 6, the data access apparatus includes: the system comprises a data access routing component, a data source management component, a resource switching management component, a data health check component, a fault isolation and recovery component, a fault monitoring component, a file resource access component, a data source configuration component and an exception handling strategy configuration component. The following is a detailed description.
In the present embodiment, the data source management component (functioning similarly to the aforementioned data source management module 31) stores therein data source configuration information of a plurality of RAC clusters.
The exception processing strategy configuration component stores exception strategy configuration information. The data access routing component can select an exception handling strategy for exception handling through the exception handling strategy configuration component.
The data access routing component (functioning similarly to the aforementioned data access module 32) is configured to: and judging whether a multi-RAC cluster is needed to be used or not according to parameters in the database access request, if so, acquiring an available data source from the data source management component, and performing processing such as selecting a routing strategy, calculating a data access path, setting a routing access path and the like to determine a target data source. And starting the transaction, and performing database access operation on the target database according to the target data source.
A fault monitoring component (functioning similarly to the aforementioned fault monitoring unit) is used to monitor whether the database access process can be completed based on the target database. The method comprises the following steps: for performing a data operation validity check and a database return result validity check, which, as previously described, determine whether the database operation result is valid, invalid, or abnormal. And if the operation result of the database is valid, completing the calling of the target database. And if the database operation result is invalid, triggering the data access routing component to select other data sources as target data sources for database access. And if the database operation result is abnormal, judging whether the database operation result is abnormal in isolation, and calling a data health check triggering component, a fault isolation and recovery component and a data source configuration component under the condition of abnormal in isolation (the functions of the three components are similar to the fault isolation and recovery subunit mentioned above).
And the fault isolation and recovery component is used for isolating the target data source and triggering the data health check component to perform health check on the target data source when the database exception is isolation exception, triggering the fault isolation and recovery component to recover the target data source if the check result is that the target data source is available, and adding the target data source into the available data source by the data source configuration component.
During the working process of the fault isolation and recovery component, the data health check component and the data source configuration component, or after the data source configuration component adds the target data source into the available data source, the data access routing component can reselect the target data source to repeat the subsequent processing such as database operation and the like.
A resource switch management component (functioning similarly to the aforementioned resource switch module) is used to switch between the database and the file system depending on whether there are available data sources.
A file resource access component (functioning similarly to the file resource access module mentioned earlier) is used to convert database access into file access without the available data source.
In contrast to the embodiments or implementations shown in fig. 3-5 and the embodiment shown in fig. 6, it should be understood by those skilled in the art that the specific functions in the data processing apparatus are not limited to being implemented by a single functional module, but different functional modules can be flexibly arranged according to the needs. That is, the present invention protects the logical processes of the data processing apparatus, and does not limit the specific modules to realize the specific functions, and those skilled in the art can design a data access apparatus having different functional modules from the data processing apparatus of the present invention according to the teaching of the embodiment of the present invention, but realizing the logical processes of the data processing apparatus of the present invention, also falls within the protection scope of the present invention.
Fig. 7 is a schematic diagram of a multi-RAC cluster system according to an embodiment of the present invention. Referring to fig. 7, the multi-RAC cluster system includes a data access device and a plurality of RAC clusters (e.g., two or more RAC clusters). In the present embodiment, the data access device can receive an access request transmitted from the outside through a plurality of APs (access points) connected thereto. For a description of the data access device, please refer to the foregoing description, which is not repeated herein. Wherein, a plurality of RAC clusters are in peer-to-peer relationship, that is, they can all provide comprehensive read-write database processing to the outside simultaneously.
In a specific application of the present invention, database routing can be implemented by means of mutildasource of Spring (an existing open source framework), and database access can be performed by means of ibatis (an existing open source project). This is of course merely an example and a person skilled in the art may flexibly adopt different designs.
Through the above description of the embodiments, those skilled in the art will clearly understand that the present invention can be implemented by combining software and a hardware platform. With this understanding in mind, all or part of the technical solutions of the present invention that contribute to the background can be embodied in the form of a software product, which can be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods according to the embodiments or some parts of the embodiments of the present invention.
It should be understood by those skilled in the art that the foregoing is only illustrative of the present invention, and is not intended to limit the scope of the invention.
Claims (15)
1. A method for data access based on a plurality of RAC clusters, the method comprising:
determining available data sources according to the data source configuration information of the RAC clusters;
selecting a first data source from the available data sources as a target data source according to a routing strategy;
performing database operation on the corresponding target database according to the target data source;
completing the calling of a target database or reselecting a second data source as the target data source according to the operation result of the database;
wherein, the database operation of the corresponding target database according to the target data source comprises the following steps:
checking the validity of the data operation aiming at the target database, and checking the validity of a database return result under the condition that the data operation is valid; wherein,
if the data operation and the database return result are both valid, the database operation result is valid,
if the data operation is invalid, or if the data operation is valid and the database return result is abnormal, the database operation result is abnormal,
if the database operation is valid and the database return result is invalid, the database operation result is invalid.
2. The method of claim 1, wherein the method further comprises:
and when determining that a plurality of RAC clusters need to be used according to the received database access request, determining the available data source according to the data source configuration information of the RAC clusters.
3. The method of any one of claims 1 and 2, wherein completing the invocation of the target database or reselecting a second data source as the target data source based on the result of the database operation comprises:
when the operation result of the database is valid, completing the calling of the target database;
and when the operation result of the database is invalid or abnormal, reselecting the second data source as the target data source.
4. The method of claim 3, wherein reselecting a second data source as the target data source comprises:
when the operation result of the database is invalid, selecting the second data source which is not the first data source from the available data sources as the target data source according to a pre-configured data source switching strategy;
and when the operation result of the database is abnormal, updating the data source configuration information of the first data source according to a pre-configured abnormal processing strategy, and selecting the second data source which is not the first data source from the available data sources as the target data source.
5. The method of claim 4, wherein updating the data source configuration information of the first data source according to a preconfigured exception handling policy comprises:
and if the operation result of the database is isolation abnormity, fault isolation is carried out on the first data source and data health check is carried out, and if the check result is that the first data source is available, the first data source is recovered and added into the available data source.
6. The method of claim 1, wherein the method further comprises:
and monitoring the pressure of the RAC clusters, and adding a new RAC cluster by adding the data source configuration information of the new RAC cluster when the pressure reaches a set condition.
7. The method of claim 1, wherein the method further comprises:
switching between the database and the file system according to whether the available data source exists;
in the absence of the available data source, converting the database access to a file access.
8. A data access apparatus based on a plurality of RAC clusters, the data access apparatus comprising:
the data source management module stores data source configuration information of a plurality of RAC clusters;
a data access module comprising:
a determining submodule for determining an available data source according to the data source configuration information stored in the data source management module,
a selection submodule for selecting a first data source from the available data sources as a target data source according to a routing policy,
the operation submodule is used for carrying out database operation on the corresponding target database according to the target data source;
the processing module is used for completing target database calling or reselecting a second data source as the target data source according to the database operation result;
wherein the operation submodule comprises:
the first checking unit is used for checking the validity of the data operation aiming at the target database and triggering the second checking module under the condition that the data operation is valid;
the second checking unit is used for checking the validity of the returned result of the database;
wherein, if the data operation result and the database return result are both effective, the database operation result is effective,
if the data operation is invalid, or if the data operation is valid and the database return result is abnormal, the database operation result is abnormal,
if the database operation is valid and the database return result is invalid, the database operation result is invalid.
9. The apparatus of claim 8, wherein the data access module further comprises:
and the request processing submodule is used for receiving a database access request and triggering the determining submodule under the condition that the plurality of RAC clusters are determined to be needed to be used according to the database access request.
10. The apparatus of any one of claims 8 and 9, wherein the processing module is to:
when the operation result of the database is valid, completing the calling of the target database;
and when the operation result of the database is invalid or abnormal, reselecting the second data source as the target data source.
11. The apparatus of claim 10, wherein the processing module comprises:
the first reselection submodule is used for selecting the second data source which is not the first data source from the available data sources as the target data source according to a preconfigured data source switching strategy when the operation result of the database is invalid;
and the second reselection submodule is used for updating the data source configuration information of the first data source according to a pre-configured exception handling strategy when the operation result of the database is abnormal, and selecting the second data source which is not the first data source from the available data sources as the target data source.
12. The apparatus of claim 11, wherein the second reselection sub-module comprises:
the fault monitoring unit is used for judging whether the operation result of the database is isolation abnormity or not and calling the fault isolation and recovery unit under the condition that the operation result of the database is isolation abnormity;
and the fault isolation and recovery unit is used for isolating the first data source, performing data health check on the first data source, and recovering the first data source and adding the first data source into the available data source when the check result shows that the first data is available.
13. The apparatus of claim 8, wherein the apparatus further comprises:
and the dynamic processing module is used for monitoring the pressure of the RAC clusters and adding a new RAC cluster by adding the data source configuration information of the new RAC cluster when the pressure reaches a set condition.
14. The apparatus of claim 8, wherein the apparatus further comprises:
the resource switching module is used for switching between the database and the file system according to whether the available data source exists or not;
and the file resource access module is used for converting the database access into the file access under the condition that the available data source does not exist.
15. A multi-RAC cluster system comprising a plurality of RAC clusters and the data access apparatus of any one of claims 8-14.
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 Active 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) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107800780B (en) * | 2017-10-10 | 2020-09-08 | 深圳乐信软件技术有限公司 | Data service method, device, storage medium and computer equipment |
| CN107862006B (en) * | 2017-10-25 | 2022-03-22 | 创新先进技术有限公司 | Method and device for realizing data source switching |
| CN108932309B (en) * | 2018-06-15 | 2020-12-01 | 未鲲(上海)科技服务有限公司 | Cross-platform database management method, device, computer equipment and storage medium |
| CN110032569B (en) * | 2019-01-17 | 2023-06-27 | 创新先进技术有限公司 | Method, device, equipment and system for checking changed data |
| CN111447113B (en) * | 2020-03-25 | 2021-08-27 | 中国建设银行股份有限公司 | System monitoring method and device |
| CN114756593A (en) * | 2022-04-25 | 2022-07-15 | 中国建设银行股份有限公司 | Product recommendation method, device, equipment and medium |
Citations (4)
| 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)
| 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 |
-
2016
- 2016-06-07 CN CN201610395910.3A patent/CN106095571B/en active Active
Patent Citations (4)
| 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 |
|---|---|---|
| CN106095571B (en) | More RAC group systems, data access method and device | |
| JP4620455B2 (en) | Business continuity policy for server-linked environments | |
| US20200007620A1 (en) | Intelligent Backup and Recovery of Cloud Computing Environment | |
| Chinnathambi et al. | Scheduling and checkpointing optimization algorithm for byzantine fault tolerance in cloud clusters | |
| US8898520B1 (en) | Method of assessing restart approach to minimize recovery time | |
| CN111209110B (en) | Task scheduling management method, system and storage medium for realizing load balancing | |
| CN103136363A (en) | Inquiry processing method and cluster data base system | |
| CN106130763A (en) | Server cluster and be applicable to the database resource group method for handover control of this cluster | |
| CN109286529A (en) | A kind of method and system for restoring RabbitMQ network partition | |
| CN111459639B (en) | Distributed task management platform and method supporting global multi-machine room deployment | |
| CN109697078B (en) | Repairing method of non-high-availability component, big data cluster and container service platform | |
| JP4461262B2 (en) | A method for manipulating multiple computer arrays in the event of a computer failure | |
| EP3591530A1 (en) | Intelligent backup and recovery of cloud computing environment | |
| CN107508700B (en) | Disaster recovery method, device, equipment and storage medium | |
| US11695856B2 (en) | Scheduling solution configuration method and apparatus, computer readable storage medium thereof, and computer device | |
| CN111342986B (en) | Distributed node management method and device, distributed system and storage medium | |
| CN109587218B (en) | Cluster election method and device | |
| CN103902401A (en) | Virtual machine fault tolerance method and device based on monitoring | |
| EP3425508B1 (en) | Method and apparatus for checking integrity of distributed service processing | |
| CN114390059B (en) | Service processing system and service processing method | |
| CN112269693B (en) | Node self-coordination method, device and computer readable storage medium | |
| JP2017521802A (en) | Architecture for correlation events for supercomputer monitoring | |
| Heegaard et al. | Survivability as a generalization of recovery | |
| CN112131201B (en) | Method, system, equipment and medium for high availability of network additional storage | |
| CN112612652A (en) | Distributed storage system abnormal node restarting method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |