CN101694632A - Method for executing resource plans on demands and being applied to data base cluster system - Google Patents
Method for executing resource plans on demands and being applied to data base cluster system Download PDFInfo
- Publication number
- CN101694632A CN101694632A CN200910229412A CN200910229412A CN101694632A CN 101694632 A CN101694632 A CN 101694632A CN 200910229412 A CN200910229412 A CN 200910229412A CN 200910229412 A CN200910229412 A CN 200910229412A CN 101694632 A CN101694632 A CN 101694632A
- Authority
- CN
- China
- Prior art keywords
- resource
- data base
- user
- cluster
- group
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 8
- 238000013439 planning Methods 0.000 claims description 17
- 238000007726 management method Methods 0.000 claims description 3
- 238000013507 mapping Methods 0.000 claims description 3
- 230000007257 malfunction Effects 0.000 abstract 2
- 230000007246 mechanism Effects 0.000 abstract 1
- 238000012545 processing Methods 0.000 description 4
- 238000013468 resource allocation Methods 0.000 description 3
- 238000012937 correction Methods 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 230000009931 harmful effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000035484 reaction time Effects 0.000 description 1
Landscapes
- Hardware Redundancy (AREA)
Abstract
The invention provides a method for executing resource plans on demands and being applied to a data base cluster system. The method includes that in the data base cluster system, a data base resource manager is adopted to realize cluster member instances executing resource plans on demands and ensure business operation with a comparatively high priority level to obtain data base resources preferentially, and parallel working mechanisms of a data base cluster are further employed to realize transaction load and invalidation switching function between member instances. Under normal operation mode, the cluster member instances execute a respective resource plan in respective nodes, and when a certain node in the cluster system has malfunctions, application transactions in malfunction member instances are automatically switched to normal nodes and rapidly start a reservation resource plan to continue providing application service, thereby providing technical indexes with high performance and high availability for business application with special resource demands.
Description
Technical field
The present invention relates to the data-base cluster application, be specifically related to a kind of method that data base cluster system is carried out resource planning as required that is used for, resources allocation and realization system height are available as required in order to data base cluster system to be provided.
Background technology
The database environment that data-base cluster (Oracle Real Application Cluster is called for short Oracle RAC) requires for most of key businesses provides high performance and perfect error correction.It not only allows the same physical database of a plurality of nodes sharing in group system or the large-scale parallel system; between multinode, carry out load balance, fault restoration and planning stop time automatically; to support high-availability applications; and, significantly improved the performance of large data warehouse and decision support system (DSS) by combining the concurrency that internodal concurrency and intranodal are provided with the parallel query option.
Talk about publicly knownly, the availability of database comprises its function and performance.If database can be used, but the user does not obtain the performance level that they need, and the target of Database Systems availability and service level then can't obtain satisfied fully so.Traditionally, all users and application can be obtained database resource coequally in the sets of data storehouse system.Though this database processing mode is widely adopted in a lot of cases, it can't satisfy the specific demand of enterprise, and is more important than other business such as some affairs in the basic service.
Can be easily, executive system and resource management are for maintenance applications and performance of database exactly, scalability and availability are vital.The database resource manager can be realized the resource planning Resources allocation between user or application program by data base administrator's formulation.Resource planning has been specified and adopted which type of policy distributed resource among various any active ues or application.User or to use according to separately resource requirement be different resource user group with the enterprise priority settings.Utilize the database resource planning strategy, the keeper can define resource and should how to distribute in various resource user group.For example, resource planning can be at height, in and between the resource user group of low priority the distribution system cpu resource be 80%, 15% and 5% ratio.The operable resource of user or application program depends on the pre-allocation resource restriction that resource user group that it is subordinate to obtains.When resource planning was worked out, the resource user group at database user or application place just has been created to be finished.Yet it also can change in the enterprising action attitude of the standard base that the keeper determines.For example, finish the result when certain db transaction operates in not feed back in 5 minutes, these affairs can work will automatically be moved to the high medium priority resource user group from the high priority resource user group.
So whether a kind of better solution is arranged, do not change the existing business framework and not increase under the prerequisite of system cost guaranteeing, can effectively solution guarantee that system resource distribution according to need can realize the high availability of operation system again? the problem that this present invention just attempted solving.
Summary of the invention
Method of the present invention realizes that in the following manner resource management comprises under the normal operation mode and the failure operation pattern, and wherein, under the normal operation mode, data base set group members example is in the resource planning that moves according to predetermined policy separately; When certain node breaks down in the data base cluster system, system automatically performs the failure operation pattern, applied transaction will automatically switch to normal node and start the predetermined resource plan fast in fault member's example, continue to provide application service, guarantee the affairs load and the switching of losing efficacy between the group system member node by data-base cluster from the height available characteristic, realize the high available of system.
Concrete steps are as follows:
1) load of turn-on data storehouse group service and the switching of losing efficacy;
2) set up resource user group: the group member has identical or similar resource requirement;
3) carry out the user and organize mapping: specify what user when to organize with which user;
4) work out application plan: comprise that cpu resource distributes overtime setting.
In data base cluster system,, guarantee that the higher priority business operator precedence obtains database resource by adopting the database resource manager to realize that the cluster member example carries out resource planning as required.
What the present invention introduced just can effectively address the above problem based on the high as required available solution of database resource manager fulfillment database cluster.By adopting the database resource manager, the data base administrator can carry out resource allocation policy as required, can allow Database Systems according to predefined service priority allocation database operational applications system resource, can be that enterprise uses and the user provides service resources control to guarantee the Service Database service.
Embodiment
The present invention contains in data-base cluster (RAC) environment of 2 physical nodes, the main target of using is to guarantee to provide the quick and predictable reaction time to ATM user, support the database of this application may also be used to carry out other affairs in batches, for example financial monthly closing entry or Nian Jie etc. simultaneously.Can not produce any harmful effect in order to ensure these transaction operations, can create following resource planning ATM user:
Resource user's group node 1: processor resource plan of distribution node 2: processor resource plan of distribution
ATM (Automatic Teller Machine) user 90% (maximum) 60% (minimum)-90%
Batch processing job user 10% (maximum) 10%--40% (maximum)
The resource planning explanation:
Distribution processor (CPU) resource 90% and 10% is used for ATM online user trade transactions and other batch processing affairs respectively on node 1, on node 2 the resource allocation policy relative complex some: ATM user is set is the resource user group of high priority, under the group system normal operation, obtain 60% system resource, under cluster node 1 fail operation situation, carry out the resource adjustment, obtain 90% processor (CPU) resource, but not ATM user is set to low priority resources user group, discharges processor (CPU) resource outside the restriction according to resource planning under the fail operation situation.This has just realized satisfying different application programs or the user uses same database resource as required, has guaranteed that again application program identical in the cluster or user are perfect high available.
Distribution processor (CPU) resource 90% and 10% is used for ATM online user trade transactions and other batch processing affairs respectively on clustered node 1, on node 2 the resource allocation policy relative complex some: ATM user is set is the resource user group of high priority, under the group system normal operation, obtain 60% system resource, under cluster node 1 fail operation situation, carry out the resource adjustment, obtain 90% processor (CPU) resource, but not ATM user is set to low priority resources user group, discharges processor (CPU) resource outside the restriction according to resource planning under the fail operation situation.This has just realized satisfying different application programs or the user uses same database resource as required, has guaranteed that again application program identical in the cluster or user are perfect high available.
The use step is as follows:
1) load of turn-on data storehouse group service and the switching of losing efficacy;
2) set up resource user group: the group member has identical or similar resource requirement;
3) carry out the user and organize mapping: be exactly to specify what user when to organize with that user;
4) work out application plan: cpu resource distributes, and is overtime grade for setting.
Claims (2)
1. one kind is used for the method that data base cluster system is carried out resource planning as required, it is characterized in that resource management comprises under the normal operation mode and the failure operation pattern, wherein, under the normal operation mode, data base set group members example is in the resource planning that moves according to predetermined policy separately; When certain node breaks down in the data base cluster system, system automatically performs the failure operation pattern, applied transaction will automatically switch to normal node and start the predetermined resource plan fast in fault member's example, continue to provide application service, guarantee the affairs load and the switching of losing efficacy between the group system member node by data-base cluster from the height available characteristic, realize the high available of system;
Concrete steps are as follows:
1) load of turn-on data storehouse group service and the switching of losing efficacy;
2) set up resource user group: the group member has identical or similar resource requirement;
3) carry out the user and organize mapping: specify what user when to organize with which user;
4) work out application plan: comprise that cpu resource distributes overtime setting.
2. the method for claim 1 is characterized in that, by adopting the database resource manager to realize that the cluster member example carries out resource planning as required, guarantees that the higher priority business operator precedence obtains database resource in data base cluster system.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910229412A CN101694632A (en) | 2009-10-19 | 2009-10-19 | Method for executing resource plans on demands and being applied to data base cluster system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910229412A CN101694632A (en) | 2009-10-19 | 2009-10-19 | Method for executing resource plans on demands and being applied to data base cluster system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101694632A true CN101694632A (en) | 2010-04-14 |
Family
ID=42093605
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910229412A Pending CN101694632A (en) | 2009-10-19 | 2009-10-19 | Method for executing resource plans on demands and being applied to data base cluster system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101694632A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102004803A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Method and device for scheduling database resources |
CN102033784A (en) * | 2010-11-18 | 2011-04-27 | 山东中创软件工程股份有限公司 | Method and device for optimizing application server |
WO2015052722A1 (en) * | 2013-10-09 | 2015-04-16 | Hewlett-Packard Development Company, L.P. | Information technology resource planning |
CN105550094A (en) * | 2015-12-10 | 2016-05-04 | 国网四川省电力公司信息通信公司 | Automatic state monitoring method of high-availability system |
CN105550038A (en) * | 2015-12-12 | 2016-05-04 | 天津南大通用数据技术股份有限公司 | Equivalently deployed distributed database resource management and load adjustment method |
CN107862042A (en) * | 2017-11-06 | 2018-03-30 | 中国银行股份有限公司 | A kind of control method and device of data base concurrency degree |
CN113806097A (en) * | 2021-09-29 | 2021-12-17 | 杭州网易云音乐科技有限公司 | Data processing method and device, electronic equipment and storage medium |
CN113965582A (en) * | 2020-07-20 | 2022-01-21 | 中移(苏州)软件技术有限公司 | Mode conversion method and system, and storage medium |
-
2009
- 2009-10-19 CN CN200910229412A patent/CN101694632A/en active Pending
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102033784A (en) * | 2010-11-18 | 2011-04-27 | 山东中创软件工程股份有限公司 | Method and device for optimizing application server |
CN102033784B (en) * | 2010-11-18 | 2013-08-07 | 山东中创软件工程股份有限公司 | Method and device for optimizing application server |
CN102004803A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Method and device for scheduling database resources |
WO2015052722A1 (en) * | 2013-10-09 | 2015-04-16 | Hewlett-Packard Development Company, L.P. | Information technology resource planning |
CN105550094A (en) * | 2015-12-10 | 2016-05-04 | 国网四川省电力公司信息通信公司 | Automatic state monitoring method of high-availability system |
CN105550094B (en) * | 2015-12-10 | 2018-02-06 | 国网四川省电力公司信息通信公司 | A kind of high-availability system state automatic monitoring method |
CN105550038A (en) * | 2015-12-12 | 2016-05-04 | 天津南大通用数据技术股份有限公司 | Equivalently deployed distributed database resource management and load adjustment method |
CN107862042A (en) * | 2017-11-06 | 2018-03-30 | 中国银行股份有限公司 | A kind of control method and device of data base concurrency degree |
CN113965582A (en) * | 2020-07-20 | 2022-01-21 | 中移(苏州)软件技术有限公司 | Mode conversion method and system, and storage medium |
CN113965582B (en) * | 2020-07-20 | 2024-04-09 | 中移(苏州)软件技术有限公司 | Mode conversion method and system, and storage medium |
CN113806097A (en) * | 2021-09-29 | 2021-12-17 | 杭州网易云音乐科技有限公司 | Data processing method and device, electronic equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101694632A (en) | Method for executing resource plans on demands and being applied to data base cluster system | |
US20200169600A1 (en) | Method and system for workload management for data management systems | |
US8468548B2 (en) | Multi-tenant, high-density container service for hosting stateful and stateless middleware components | |
US9524296B2 (en) | Managing events in a computing environment | |
US20080306950A1 (en) | Arrival rate throttles for workload management | |
US8042119B2 (en) | States matrix for workload management simplification | |
US20160357985A1 (en) | Methods and systems for regulating user engagement | |
KR20140119090A (en) | Dynamic load balancing in a scalable environment | |
DE112011103522T5 (en) | Creation of a multidimensional model of software offerings | |
EP3158442A1 (en) | System and method for providing a work manager in a multitenant application server environment | |
DE112010003027T5 (en) | System and method for job control in a distributed data processing system with identification of the optimal network topology | |
CN105184144A (en) | Multi-system privilege management method | |
CN104461502A (en) | Task management method and system based on Hadoop | |
DE102014002181B4 (en) | Chip and method of operating a chip | |
CN111259378A (en) | Multi-tenant management system and implementation method thereof | |
US10956371B2 (en) | Team folder conversion and management | |
DE102012203521A1 (en) | Architecture with two trustworthiness levels | |
CN102243653B (en) | Method and device for managing database connections | |
US20090049024A1 (en) | Dynamic query optimization between systems based on system conditions | |
CN102243655B (en) | Method and device for managing database connections | |
CN112651609A (en) | Robot system authorization control method, system and readable storage medium | |
CN106533961A (en) | Flow control method and device | |
CN102243597B (en) | Method and device for controlling and managing database connections | |
CN105718322B (en) | The abnormality eliminating method of more application module clients under same process | |
US20120233220A1 (en) | Controlling Access To A Computer 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 | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20100414 |