CN107332873A - A kind of method of automatic discovery cluster resource - Google Patents
A kind of method of automatic discovery cluster resource Download PDFInfo
- Publication number
- CN107332873A CN107332873A CN201710373310.1A CN201710373310A CN107332873A CN 107332873 A CN107332873 A CN 107332873A CN 201710373310 A CN201710373310 A CN 201710373310A CN 107332873 A CN107332873 A CN 107332873A
- Authority
- CN
- China
- Prior art keywords
- cluster
- cluster resource
- oracle database
- database
- resource
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
-
- 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/21—Design, administration or maintenance of databases
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L61/00—Network arrangements, protocols or services for addressing or naming
- H04L61/45—Network directories; Name-to-address mapping
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to database field, a kind of method of automatic discovery cluster resource is disclosed, is comprised the following steps：(1) interpolation data storehouse information：Add computing resource Pool name, oracle database clustered software catalogue, oracle database software catalog, oracle database cluster user name, oracle database user name, server ip address；(2) log in：Using SSH agreements by way of secret key pair is verified game server；(3) perform：It is switched under oracle database cluster user and performs database command discovery cluster resource；(4) collect：Persistent collection cluster resource, after the completion of collecting cluster resource, web page is illustrated in by information.The present invention, which need to only fill in the information such as server ip address, just fast automatic can find data-base cluster resource, save O＆M human resources, improve business agility, improve operating efficiency, save management cost.
Description
Technical field
The present invention relates to database field, more particularly to a kind of method of automatic discovery cluster resource.
Background technology
The strategy of Oracle management databases has manual management (Manual) and based on tactical management (Policymanaged)
Two ways.This technology based on based on tactical management (Policymanaged), tactful way to manage using server pools as
Basis, first defining has a certain amount of server in some server pools, pond, then re-define some strategies, according to these strategies
Which database instance Oracle meeting automatic decisions operate on which platform server in server pools.Database instance name suffix
Label, database instance quantity, data instance are operated on which or which main frame, these be all by strategy decision,
Rather than DBA has managed in advance.
Use the effect that can be reached based on tactical management (Policymanaged) mode：Assuming that there is 10 server groups
Into server pools, the criticality of server pools is defined according to the importance of different applications, if some in server pools
In the case that machine chance failure is shut down, still it can automatically ensure enough machines to important application based on strategy
Systems with data storehouse is serviced, and the number of the database server needed for the low application system of importance is reduced into minimum
Degree.
The automatic technology for finding cluster resource is exactly based on tactical management (Policymanaged) oracle database base
Innovative technology on plinth, most of existing monitoring software is to be directed to database on the market, rather than for cluster.Work as pipe
Substantial amounts of server cluster is managed, and runs in these clusters a variety of different importances, the OracleRAC numbers of Different Strategies
During according to storehouse, and the automatic discovery of cluster is just particularly important with management.
The content of the invention
There is provided a kind of method of automatic discovery cluster resource for shortcoming of the invention for inefficiency in the prior art.
In order to solve the above-mentioned technical problem, the present invention is addressed by following technical proposals.
A kind of method of automatic discovery cluster resource, comprises the following steps：
(1) interpolation data storehouse information：Add computing resource Pool name, oracle database clustered software catalogue, oracle
Database software catalogue, oracle database cluster user name, oracle database user name, server ip address；
(2) log in：Using SSH agreements by way of secret key pair is verified game server；
(3) perform：It is switched under oracle database cluster user and performs database command discovery cluster resource；
(4) collect：Persistent collection cluster resource, after the completion of collecting cluster resource, web page is illustrated in by information.
The present invention is as a result of above technical scheme, with significant technique effect：The present invention only need to fill in server
The information such as IP address just fast automatic can find data-base cluster resource, save O＆M human resources, improve business agility, carry
High workload efficiency, saves management cost.
Brief description of the drawings
Fig. 1 is a kind of schematic flow sheet of the method for automatic discovery cluster resource of the present invention.
Embodiment
The present invention is described in further detail with embodiment below in conjunction with the accompanying drawings.
As shown in figure 1, a kind of method of automatic discovery cluster resource, comprises the following steps：
(1) interpolation data storehouse information：Add computing resource Pool name, oracle database clustered software catalogue, oracle
Database software catalogue, oracle database cluster user name, oracle database user name, server ip address；
(2) log in：Using SSH agreements by way of secret key pair is verified game server；
(3) perform：It is switched under oracle database cluster user and performs database command discovery cluster resource；
(4) collect：Persistent collection cluster resource, after the completion of collecting cluster resource, web page is illustrated in by information.
The present invention need to only fill in the information such as server ip address just can fast automatic discovery data-base cluster resource, saving fortune
Human resources are tieed up, business agility is improved, operating efficiency is improved, management cost is saved.
Embodiment 1
(1) database information is added：Add computing resource Pool name, such as oracle；Add oracle database cluster soft
Part catalogue, such as/opt/grid/products/11.2.0, oracle database software catalog, such as/opt/oracle/
Products/11.2.0, oracle database cluster user name, such as gird, oracle database user name, such as oracle, clothes
Business device IP address, such as 10.10.10.10, server root user ciphers, such as root.
(2) SSH agreements game server by way of password authentication is utilized, is proved to be successful, then carries out next step；Instead
It, then Modify password is verified again.
(3) it is switched under oracle database cluster user and performs srvctl orders discovery cluster resource.
(4) persistent collection cluster resource, after the completion of collecting cluster resource, web page is illustrated in by information.
In a word, presently preferred embodiments of the present invention, all equalizations made according to scope of the present invention patent be the foregoing is only
Change and modification, should all belong to the covering scope of patent of the present invention.
Claims (1)
1. a kind of method of automatic discovery cluster resource, it is characterised in that comprise the following steps：
(1) interpolation data storehouse information：Add computing resource Pool name, oracle database clustered software catalogue, oracle data
Library software catalogue, oracle database cluster user name, oracle database user name, server ip address；
(2) log in：Using SSH agreements by way of secret key pair is verified game server；
(3) perform：It is switched under oracle database cluster user and performs database command discovery cluster resource；
(4) collect：Persistent collection cluster resource, after the completion of collecting cluster resource, web page is illustrated in by information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710373310.1A CN107332873A (en) | 2017-05-24 | 2017-05-24 | A kind of method of automatic discovery cluster resource |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710373310.1A CN107332873A (en) | 2017-05-24 | 2017-05-24 | A kind of method of automatic discovery cluster resource |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107332873A true CN107332873A (en) | 2017-11-07 |
Family
ID=60193665
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710373310.1A Pending CN107332873A (en) | 2017-05-24 | 2017-05-24 | A kind of method of automatic discovery cluster resource |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107332873A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE10302933A1 (en) * | 2003-01-24 | 2003-10-23 | Teamware Gmbh Softwaredesign & | Database maintenance method for mobile phone access to a central database, whereby each time a database record is requested by a user it is transmitted with a TAN, which is checked when the updated record is transmitted back |
| US20050102284A1 (en) * | 2003-11-10 | 2005-05-12 | Chandramouli Srinivasan | Dynamic graphical user interface and query logic SQL generator used for developing Web-based database applications |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
| CN103902542A (en) * | 2012-12-25 | 2014-07-02 | 百度在线网络技术（北京）有限公司 | Operating and maintaining method and system of database in testing environment |
| CN104679717A (en) * | 2015-02-15 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Method and management system of elastic cluster deployment |
| CN104951524A (en) * | 2015-06-11 | 2015-09-30 | 上海新炬网络信息技术有限公司 | Mobile platform for database operation and maintenance and using method of mobile platform |
-
2017
- 2017-05-24 CN CN201710373310.1A patent/CN107332873A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE10302933A1 (en) * | 2003-01-24 | 2003-10-23 | Teamware Gmbh Softwaredesign & | Database maintenance method for mobile phone access to a central database, whereby each time a database record is requested by a user it is transmitted with a TAN, which is checked when the updated record is transmitted back |
| US20050102284A1 (en) * | 2003-11-10 | 2005-05-12 | Chandramouli Srinivasan | Dynamic graphical user interface and query logic SQL generator used for developing Web-based database applications |
| CN103902542A (en) * | 2012-12-25 | 2014-07-02 | 百度在线网络技术（北京）有限公司 | Operating and maintaining method and system of database in testing environment |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
| CN104679717A (en) * | 2015-02-15 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Method and management system of elastic cluster deployment |
| CN104951524A (en) * | 2015-06-11 | 2015-09-30 | 上海新炬网络信息技术有限公司 | Mobile platform for database operation and maintenance and using method of mobile platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541990B (en) | Database redistribution method and system utilizing virtual partitions | |
| CN107315776A (en) | A kind of data management system based on cloud computing | |
| CN103516529A (en) | Management method, device and system of configuration files | |
| CN102571916A (en) | Framework of leasing software of cloud storage space and operating method of framework | |
| CN103281359A (en) | Cloud desktop system and operating method | |
| CN108196935B (en) | Cloud computing-oriented virtual machine energy-saving migration method | |
| CN103457979B (en) | Distribution type file storage system and method | |
| CN103795804A (en) | Storage resource scheduling method and storage calculation system | |
| US10860256B2 (en) | Storing data utilizing a maximum accessibility approach in a dispersed storage network | |
| CN104283959A (en) | Performance-grading-based storage mechanism suitable for cloud platform | |
| CN103327116A (en) | Dynamic copy storage method for network file | |
| CN105007311A (en) | System and method for resource management based on cloud platform and cloud computing | |
| CN105159750A (en) | Virtual machine creation method and apparatus | |
| CN203301532U (en) | Cloud desktop system | |
| CN105117280A (en) | Virtual machine migration device and method | |
| CN103297514A (en) | Virtual machine management platform and virtual machine management method based on cloud infrastructure | |
| CN104915376B (en) | A kind of archival compression method of file in cloud storage | |
| CN107332873A (en) | A kind of method of automatic discovery cluster resource | |
| CN104378239A (en) | Rapid reliability index statistical system and method based on cluster frame | |
| CN105843820A (en) | Data migration method and device | |
| CN204906437U (en) | Big data storage application network framework | |
| CN104539658B (en) | One kind is based on enterprise's private clound big data processing method | |
| CN106302473A (en) | The duplication maintaining method of a kind of SQL Server data base and system | |
| CN114466030B (en) | Management method and device of data distributed storage strategy and distributed storage system | |
| CN112115123B (en) | Method and apparatus for performance optimization of distributed databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171107 |