CN104717233A - Database deployment method and device - Google Patents
Database deployment method and device Download PDFInfo
- Publication number
- CN104717233A CN104717233A CN201310671059.9A CN201310671059A CN104717233A CN 104717233 A CN104717233 A CN 104717233A CN 201310671059 A CN201310671059 A CN 201310671059A CN 104717233 A CN104717233 A CN 104717233A
- Authority
- CN
- China
- Prior art keywords
- database
- module
- storehouse
- cloud platform
- newdata
- 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.)
- Granted
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/02—Standardisation; Integration
- H04L41/024—Standardisation; Integration using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
Abstract
The invention discloses a database deployment method and a device. In the database deployment method, when a new database building request sent by a database application user is received, a resource bundle related to a specified organization is selected; in a pre-built database template base related to the specified organization, a corresponding database template is selected; the storage space and the capacity for database files are set in the resource bundle, such that the selected database template is used for newly building a database; a parameter collection of the newly-built database is set, a user name and a password of the newly-built database are set, a unique identification code generally for newly-built database access files and the newly-built database is generated, and the generated unique identification code generally for newly-built database access files and the newly-built database is sent to the database application user. Therefore, databases of different organizations and different types in a cloud platform can be managed in an integrated mode, no attention needs to be paid to the specific position and the deployment process of the database, and the cloud platform database service providing efficiency is enhanced.
Description
Technical field
The present invention relates to the communications field, particularly a kind of database part arranging method and device.
Background technology
Along with the development of cloud computing and Intel Virtualization Technology, many business platforms are all deployed in the virtual machine of cloud computing platform (hereinafter referred to as cloud platform) unified management, simultaneously, major part business platform is all containing database section, initial stage due to the requirement of database to hardware performance higher, be arranged on independently on physical server, along with the maturation of Intel Virtualization Technology and stable, most of database also progressively starts directly to carry out on a virtual machine installing and configuring more.
Current database is mainly at the deployment way of cloud platform: first cloud platform management person disposes database dedicated virtual machine and installing operating system, by DBA by figure or command line mode access of virtual machine operating system, manual installation database software also configures custom parameter, other software module of business platform passes through network IP(Internet Protocol, Internet protocol) service of addresses access data storehouse.In existing cloud platform, the way to manage of database has some problem following:
First: in cloud platform, quantity database constantly increases, the database from different department and business is mixed in together.Cloud platform management person lacks global monitoring view to database and corresponding virtual resource in cloud platform and managerial ability.Cloud platform database is installed voluntarily by service management person, configures and is monitored, and affects the service efficiency of database to virtual resource.
Second: cloud platform database dispose and configuration required time longer, manually can only be completed voluntarily by service management person, to the database configuration of database application user and technical requirement higher.
3rd: in cloud platform, the work such as mass data qurush level, clone, Backup and Restore and security hardening manually can only be completed voluntarily by service management person, cannot accomplish by cloud platform management person United Dispatching and enforcement.Reduce the operational efficiency of database in cloud platform, increase the security risk of database and cloud platform self in cloud platform.
Summary of the invention
The embodiment of the present invention provides a kind of database part arranging method and device.By to database unified management, installation, distribution and configuration optimization in cloud platform, thus provide faster easy-to-use database service to user, reduce integral deployment time and the difficulty in user's request for data storehouse.Realize the unified monitoring of cloud platform bearer database resource, scheduling and life cycle management by organizational structure management, improve the management regulation of database in cloud platform.By unified upgrading, clone, Backup and Restore and security hardening, reduce the complexity of database maintenance in cloud platform.
According to an aspect of the present invention, a kind of database part arranging method is provided, comprises:
When receiving the newdata storehouse request that database application user sends, from the request of newdata storehouse, extract the specified tissue information in organizational structure and database template information;
Select the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse;
In the database template storehouse be associated with specified tissue set up in advance, select the database template corresponding with database template information;
The memory space of setting data library file and capacity in resource bag, to utilize the database template newdata storehouse selected;
The parameter set in newdata storehouse is set;
The username and password in newdata storehouse is set;
Generate newdata storehouse access file and the general unique identifier in newdata storehouse;
The general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user.
Preferably, when setting up the database template storehouse be associated with specified tissue, comprising:
In cloud platform, select server cluster using as deployed position;
Organizational structure is set up by demand;
Set up the resource bag be associated with each tissue in organizational structure;
Set up the database template storehouse be associated with each tissue;
The database template storehouse of foundation is imported in the resource bag be associated with respective organization.
Preferably, the step setting up the database template storehouse be associated with each tissue comprises:
For each tissue, in cloud platform, set up at least one virtual machine;
The database of needs is installed in the virtual machine set up;
The virtual machine of installation database is encapsulated as database template;
Set up default database configuration parameter set.
Preferably, in cloud platform, server cluster is selected to comprise using the step as deployed position:
To judge in cloud platform whether presence server cluster;
If presence server cluster in cloud platform, then in cloud platform, select the server cluster that existed using as deployed position;
If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
According to a further aspect in the invention, provide a kind of database deployment devices, comprise interface unit, extraction unit, resource bag selected cell, template selection unit, the first setting unit, the second setting unit, the 3rd setting unit and information generating unit, wherein:
Interface unit, for receiving the newdata storehouse request that database application user sends; According to the instruction of information generating unit, the general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user;
Extraction unit, for receive when interface unit database application user send the request of newdata storehouse time, from the request of newdata storehouse, extract the specified tissue information in organizational structure and database template information;
Resource bag selected cell, for selecting the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse;
Template selection unit, in the database template storehouse be associated with specified tissue set up in advance, selects the database template corresponding with database template information;
First setting unit, for memory space and the capacity of setting data library file in resource bag, to utilize the database template newdata storehouse selected;
Second setting unit, for arranging the parameter set in newdata storehouse;
3rd setting unit, for arranging the username and password in newdata storehouse;
Information generating unit, for generating the general unique identifier of newdata storehouse access file and newdata storehouse; The general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user by instruction interface unit.
Preferably, said apparatus also comprises ATL and sets up unit, wherein ATL set up unit comprise cluster select module, organizational structure sets up module, module set up by resource bag, ATL sets up module and ATL import module, wherein:
Cluster selects module, for when setting up the database template storehouse be associated with specified tissue, selects server cluster using as deployed position in cloud platform;
Organizational structure sets up module, for setting up organizational structure by demand;
Module set up by resource bag, for setting up the resource bag be associated with each tissue in organizational structure;
ATL sets up module, for setting up the database template storehouse be associated with each tissue;
ATL imports module, for being imported in the database template storehouse of foundation in the resource bag that is associated with respective organization.
Preferably, ATL is set up module and is comprised virtual machine and set up module, installation module, package module and parameter set and set up module, wherein:
Virtual machine sets up module, for for each tissue, sets up at least one virtual machine in cloud platform;
Installation module, for installing the database of needs in the virtual machine set up;
Package module, for being encapsulated as database template by the virtual machine of installation database;
Parameter set sets up module, for setting up default database configuration parameter set.
Preferably, cluster selects module comprise identification module and select module, wherein:
Identification module, for judging in cloud platform whether presence server cluster;
Select module, for the judged result according to identification module, if in cloud platform presence server cluster, then in cloud platform, select the server cluster that existed using as deployed position; If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
The present invention, by selecting relevant database module to the database template storehouse that specified tissue is associated, according to the memory space arranged and capacity, utilizes the database module newdata storehouse selected.Thus be convenient to different tissues, dissimilar database in centralized management cloud platform, and without the need to the particular location of being concerned about database and deployment, what promote the service of cloud platform database provides efficiency.
Description of the invention provides in order to example with for the purpose of describing, and is not exhaustively or limit the invention to disclosed form.Many modifications and variations are obvious for the ordinary skill in the art.Selecting and describing embodiment is in order to principle of the present invention and practical application are better described, and enables those of ordinary skill in the art understand the present invention thus design the various embodiments with various amendment being suitable for special-purpose.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the schematic diagram of a database part arranging method of the present invention embodiment.
Fig. 2 is the schematic diagram of a building database ATL of the present invention embodiment.
Fig. 3 is the schematic diagram of a building database template of the present invention embodiment.
Fig. 4 is the schematic diagram of a database deployment devices of the present invention embodiment.
Fig. 5 is the schematic diagram of another embodiment of database deployment devices of the present invention.
Fig. 6 is the schematic diagram that ATL of the present invention sets up a unit embodiment.
Fig. 7 is the schematic diagram that ATL of the present invention sets up a module embodiment.
Fig. 8 is the schematic diagram that cluster of the present invention selects a module embodiment.
Fig. 9 is the schematic diagram of a cloud platform data base management system framework of the present invention embodiment.
Figure 10 is the schematic diagram of a cloud database management platform framework of the present invention embodiment.
Figure 11 is the schematic diagram of a database interface module of the present invention embodiment.
Figure 12 is the schematic diagram of a database management services module of the present invention embodiment.
Figure 13 is the schematic diagram of a policy service administration module of the present invention embodiment.
Figure 14 is the schematic diagram of a cloud computing architecture integrate module of the present invention embodiment.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Illustrative to the description only actually of at least one exemplary embodiment below, never as any restriction to the present invention and application or use.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Unless specifically stated otherwise, otherwise positioned opposite, the numerical expression of the parts of setting forth in these embodiments and step and numerical value do not limit the scope of the invention.
Meanwhile, it should be understood that for convenience of description, the size of the various piece shown in accompanying drawing is not draw according to the proportionate relationship of reality.
May not discuss in detail for the known technology of person of ordinary skill in the relevant, method and apparatus, but in the appropriate case, described technology, method and apparatus should be regarded as a part of authorizing specification.
In all examples with discussing shown here, any occurrence should be construed as merely exemplary, instead of as restriction.Therefore, other example of exemplary embodiment can have different values.
It should be noted that: represent similar terms in similar label and letter accompanying drawing below, therefore, once be defined in an a certain Xiang Yi accompanying drawing, then do not need to be further discussed it in accompanying drawing subsequently.
Fig. 1 is the schematic diagram of a database part arranging method of the present invention embodiment.As shown in Figure 1, the method step of the present embodiment is as follows:
Step 101, when receiving the newdata storehouse request that database application user sends, extracts the specified tissue information in organizational structure and database template information from the request of newdata storehouse.
Step 102, selects the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse.
Such as, related resource comprises the CPU(Central Processing Unit needed for database, CPU) and memory source.
Step 103, in the database template storehouse be associated with specified tissue set up in advance, selects the database template corresponding with database template information.
Step 104, the memory space of setting data library file and capacity in resource bag, to utilize the database template newdata storehouse selected.
Step 105, arranges the parameter set in newdata storehouse.
Step 106, arranges the username and password in newdata storehouse.
Step 107, generates newdata storehouse access file and the general unique identifier in newdata storehouse (Universally Unique Identifier, abbreviation: UUID).
Step 108, sends to database application user by the general unique identifier of the newdata storehouse access file of generation and newdata storehouse.
Based on the database part arranging method that the above embodiment of the present invention provides, by selecting relevant database module to the database template storehouse that specified tissue is associated, according to the memory space arranged and capacity, utilize the database module newdata storehouse selected.Thus be convenient to different tissues, dissimilar database in centralized management cloud platform, and without the need to the particular location of being concerned about database and deployment, what promote the service of cloud platform database provides efficiency.
Fig. 2 is the schematic diagram of a building database ATL of the present invention embodiment.As shown in Figure 2, the method step of the present embodiment comprises:
Step 201, when setting up the database template storehouse be associated with specified tissue, selects server cluster using as deployed position in cloud platform.
Such as, some service servers can form a virtual cluster, realize sharing and United Dispatching of resource.
Preferably, when selecting server cluster, to judge in cloud platform whether presence server cluster.If presence server cluster in cloud platform, then in cloud platform, select the server cluster that existed using as deployed position; If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
Step 202, sets up organizational structure by demand.
Such as, set up a company organization X, set up two subordinaties and organize A, B, and set up two DBAs, authorize the administration authority organizing A, B respectively.
Step 203, sets up the resource bag be associated with each tissue in organizational structure.
Such as, set up a resource bag, select some physical servers in cloud platform cluster, for follow-up carrying database, following parameter can be set:
1) share (total amount can not exceed physical resource) of CPU and memory source, reserved (the resource lower limit of minimum guarantee), restriction (current upper bound, can not exceed total amount, can adjust in the later stage);
2) memory space (sharing the logical memory blocks imported in storage based on cloud platform);
3) network configuration (network parameter that this resource bag is shared comprises VLAN(Virtual LocalArea Network, VLAN), netmask, gateway, DNS(Domain NameSystem, domain name system) and can allocation address section).
Step 204, sets up the database template storehouse be associated with each tissue.
Step 205, imports the database template storehouse of foundation in the resource bag be associated with respective organization.
Preferably, in the present embodiment, after step 201, a virtual machine can be set up, be performed other step of the present embodiment by this virtual machine.Wherein virtual machine can arrange following parameter:
1) system management network settings, comprise IP address, gateway and DNS;
2) cloud platform management VLAN and IP address, for calling virtualization layer interface;
3) internal network communication VLAN, communicates with native system for database;
4) Administrator account.
Fig. 3 is the schematic diagram of a building database template of the present invention embodiment.As shown in Figure 3, above-mentioned steps 204 specifically comprises following methods step:
Step 301, for each tissue, sets up at least one virtual machine in cloud platform.
Step 302, installs the database of needs in the virtual machine set up.
Step 303, is encapsulated as database template by the virtual machine of installation database.
Step 304, sets up default database configuration parameter set.
Fig. 4 is the schematic diagram of a database deployment devices of the present invention embodiment.As shown in Figure 4, this device comprises interface unit 401, extraction unit 402, resource bag selected cell 403, template selection unit 404, first setting unit 405, second setting unit 406, the 3rd setting unit 407 and information generating unit 408, wherein:
Interface unit 401, for receiving the newdata storehouse request that database application user sends; According to the instruction of information generating unit 408, the general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user.
Extraction unit 402, for receive when interface unit 401 database application user send the request of newdata storehouse time, from the request of newdata storehouse, extract the specified tissue information in organizational structure and database template information.
Resource bag selected cell 403, for selecting the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse.
Template selection unit 404, in the database template storehouse be associated with specified tissue set up in advance, selects the database template corresponding with database template information.
First setting unit 405, for memory space and the capacity of setting data library file in resource bag, to utilize the database template newdata storehouse selected.
Second setting unit 406, for arranging the parameter set in newdata storehouse.
3rd setting unit 407, for arranging the username and password in newdata storehouse.
Information generating unit 408, for generating the general unique identifier of newdata storehouse access file and newdata storehouse; The general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user by instruction interface unit 401.
Based on the database deployment devices that the above embodiment of the present invention provides, by selecting relevant database module to the database template storehouse that specified tissue is associated, according to the memory space arranged and capacity, utilize the database module newdata storehouse selected.Thus be convenient to different tissues, dissimilar database in centralized management cloud platform, and without the need to the particular location of being concerned about database and deployment, what promote the service of cloud platform database provides efficiency.
Fig. 5 is the schematic diagram of another embodiment of database deployment devices of the present invention.Compared with embodiment illustrated in fig. 4, in the embodiment shown in fig. 5, also comprise ATL and set up unit 501, for building database ATL.
Fig. 6 is the schematic diagram that ATL of the present invention sets up a unit embodiment.As shown in Figure 6, ATL set up unit comprise cluster select module 601, organizational structure sets up module 602, module 603 set up by resource bag, ATL sets up module 604 and ATL import module 605.Wherein:
Cluster selects module 601, for when setting up the database template storehouse be associated with specified tissue, selects server cluster using as deployed position in cloud platform.
Organizational structure sets up module 602, for setting up organizational structure by demand.
Module 603 set up by resource bag, for setting up the resource bag be associated with each tissue in organizational structure.
ATL sets up module 604, for setting up the database template storehouse be associated with each tissue.
ATL imports module 605, for being imported in the database template storehouse of foundation in the resource bag that is associated with respective organization.
Fig. 7 is the schematic diagram that ATL of the present invention sets up a module embodiment.As shown in Figure 7, ATL is set up module and is comprised virtual machine and set up module 701, installation module 702, package module 703 and parameter set and set up module 704.Wherein:
Virtual machine sets up module 701, for for each tissue, sets up at least one virtual machine in cloud platform.
Installation module 702, for installing the database of needs in the virtual machine set up.
Package module 703, for being encapsulated as database template by the virtual machine of installation database.
Parameter set sets up module 704, for setting up default database configuration parameter set.
Fig. 8 is the schematic diagram that cluster of the present invention selects a module embodiment.As shown in Figure 8, cluster selects module comprise identification module 801 and select module 802.Wherein:
Identification module 801, for judging in cloud platform whether presence server cluster.
Select module 802, for the judged result according to identification module 801, if in cloud platform presence server cluster, then in cloud platform, select the server cluster that existed using as deployed position; If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
Below cloud platform data base management system framework is described.As shown in Figure 9, this system comprises cloud database management platform 901, cloud computing virtual platform 902, set of physical resources 903 and cloud computing management platform 904.Wherein:
Cloud database management platform 901: service management person can browse and manage the database of my application by native system, cloud platform management person can dispose and manage all cloud platform databases by native system.The interface scheduling virtual resource that native system utilizes cloud computing virtual platform 902 to provide, accepts the management of cloud computing management platform 904 simultaneously.In cloud database management platform, be wherein provided with the database deployment devices that the present invention relates to.
Cloud computing virtual platform 902: unified management set of physical resources 903, for cloud database management platform 901 provides virtual resource interface.
Set of physical resources 903: comprise CPU, internal memory, storage and network interface resources.
Cloud computing management platform 904: all cloud computing related resources of unified management, realizes the Virtual Machine Manager scheduling comprising database, is operated by cloud platform management person, simultaneously can calling interface management cloud database management platform 901.
Figure 10 is the schematic diagram of a cloud database management platform framework of the present invention embodiment.As shown in Figure 10, cloud database management platform comprises database interface module 1001, database management services module 1002, tactical management service module 1003 and cloud computing architecture integrate module 1004.Wherein:
Database interface module 1001, as shown in figure 11, comprise Oracle interface (Oracle CallInterface, be called for short: OCI), MySQL interface (C language API) and Postgres interface (Libpq interface) plants database interface module, certainly can also add the interface module of other database of support by demand.Call API that these databases provide and amendment configuration file can complete Auto-mounting database, custom parameter Update Table storehouse configuration in a pre-installation, the unique instance in automatic Update Table storehouse identifies SID after installation or after coping database.
Database management services module 1002, as shown in figure 12, can comprise as lower module:
Database disposes functional module: the parameter configuration and the database masterplate that receive user's input are selected, and call corresponding database interface module, dispose database as required, and complete parameter configuration at the tissue of specifying and memory location.
Database update module: select according to user or specify masterplate, upgrades the database that single or multiple same masterplate generates automatically, realizes batch data storehouse patch and upgrades.
Data base backup recovery module: call the virtualization interface module in virtualization interface, utilizes clone or the snapshot functions of virtual machine, generates the backup file of Database Virtual Machine, the backup of fulfillment database and recovery.
Database cloning module: call the virtualization interface module in virtualization interface, utilizes the cloning function of virtual machine directly to generate the copy of Database Virtual Machine, needs the unique identifier of Update Table storehouse example.
Database resource monitoring module: the schedule virtual resources module called in virtualization interface obtains operating index and the performance parameter of Database Virtual Machine, utilize script built-in in database masterplate, obtain the conventional performance index of database, and be presented in platform interface by patterned mode.
Outside function interface module: the interface API providing above functional module, calls for outside cloud management platform.
Tactical management service module 1003, as shown in figure 13, can comprise as lower module:
Organizational structure administration module: logic hierarchy management is carried out to user, tissue and database in cloud platform, a kind of method for organizing is top layer tissue for setting certain company, inner different department is secondary tissue, all departments database application people is user, deposits frequently-used data storehouse masterplate and database instance in all departments' tissue.
Safety management module: the various functions in platform is assigned as some authorities.For user sets required administration authority, according to tissue and each database partition administration authority, each user can be realized and only can browse or manage the database of specifying simultaneously.
Masterplate administration module: be responsible for generating and managing all database masterplates, function Database Virtual Machine being encapsulated as masterplate is provided, and corresponding database interface module can be called, self-defining data storehouse masterplate preset parameter.
Cloud computing architecture integrate module 1004, as shown in figure 14, can comprise as lower module:
Schedule virtual resources module: by calling virtualization interface module, utilizes the resource reservation function of resource bag, arranges the virtual resource upper limit of specified database, lower limit and amplitude of variation, realizes the service quality guarantee (QoS) of operation system database.
Virtualization interface module: by calling the management function of virtual machine of outside cloud computing virtual platform, provide the functional interfaces such as virtual machine open and close, clone, snapshot.Comprise VMware, Xen and Hyper-V tri-kinds of virtualize interfaces.
Such as, user logs in native system, first by organizational structure administration module newly-built or select in a organized way, be recorded in organizational chart.Following user is by schedule virtual resources module, and for this tissue distributes virtual resource bag, system is communicated with cloud computing platform by virtualization interface module, realizes virtual resource allocation.Then user is by masterplate administration module newdata storehouse masterplate, and system needs to call the newly-built masterplate virtual machine of virtualization interface module, then the database interface module calling correspondence is installed in virtual machine, configuration database.
Then user's usage data storehouse deployment module, selects tissue, the database masterplate set up, in designated storage location newdata storehouse, and optional self-defining data storehouse configuration parameter.In system, database deployment module calls virtualization interface clone data storehouse masterplate, generates virtual machine and the database of specified configuration, and inputs Update Table storehouse parameter according to user.Final system collects database UUID, username and password, exports as database access file, downloads so that connection data storehouse for user.
By implementing the present invention, following beneficial effect can be obtained:
1, fulfillment database is virtual, concerning user, need not be concerned about particular location and the deployment of database.Cloud platform management person can manage different tissues in cloud platform, dissimilar database concentratedly.
2, life cycle and the resource of database is managed concentratedly.According to pre-configured database masterplate, parameter masterplate and organizational structure, keeper conveniently can manage the whole life cycle of cloud platform database and self-defined details.
3, the database update of automation and database service supplying method, what promote the service of cloud platform database provides efficiency, makes service-user and cloud platform management person not need to understand in depth to database ins and outs.
One of ordinary skill in the art will appreciate that all or part of step realizing above-described embodiment can have been come by hardware, the hardware that also can carry out instruction relevant by program completes, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium mentioned can be read-only memory, disk or CD etc.
Claims (8)
1. a database part arranging method, is characterized in that, comprising:
When receiving the newdata storehouse request that database application user sends, from the request of newdata storehouse, extract the specified tissue information in organizational structure and database template information;
Select the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse;
In the database template storehouse be associated with specified tissue set up in advance, select the database template corresponding with database template information;
The memory space of setting data library file and capacity in resource bag, to utilize the database template newdata storehouse selected;
The parameter set in newdata storehouse is set;
The username and password in newdata storehouse is set;
Generate newdata storehouse access file and the general unique identifier in newdata storehouse;
The general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user.
2. method according to claim 1, is characterized in that,
When setting up the database template storehouse be associated with specified tissue, comprising:
In cloud platform, select server cluster using as deployed position;
Organizational structure is set up by demand;
Set up the resource bag be associated with each tissue in organizational structure;
Set up the database template storehouse be associated with each tissue;
The database template storehouse of foundation is imported in the resource bag be associated with respective organization.
3. method according to claim 2, is characterized in that,
The step setting up the database template storehouse be associated with each tissue comprises:
For each tissue, in cloud platform, set up at least one virtual machine;
The database of needs is installed in the virtual machine set up;
The virtual machine of installation database is encapsulated as database template;
Set up default database configuration parameter set.
4. method according to claim 2, is characterized in that,
In cloud platform, select server cluster to comprise using the step as deployed position:
To judge in cloud platform whether presence server cluster;
If presence server cluster in cloud platform, then in cloud platform, select the server cluster that existed using as deployed position;
If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
5. a database deployment devices, is characterized in that, comprises interface unit, extraction unit, resource bag selected cell, template selection unit, the first setting unit, the second setting unit, the 3rd setting unit and information generating unit, wherein:
Interface unit, for receiving the newdata storehouse request that database application user sends; According to the instruction of information generating unit, the general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user;
Extraction unit, for receive when interface unit database application user send the request of newdata storehouse time, from the request of newdata storehouse, extract the specified tissue information in organizational structure and database template information;
Resource bag selected cell, for selecting the resource bag be associated with the specified tissue in organizational structure, so that for distributing related resource in newdata storehouse;
Template selection unit, in the database template storehouse be associated with specified tissue set up in advance, selects the database template corresponding with database template information;
First setting unit, for memory space and the capacity of setting data library file in resource bag, to utilize the database template newdata storehouse selected;
Second setting unit, for arranging the parameter set in newdata storehouse;
3rd setting unit, for arranging the username and password in newdata storehouse;
Information generating unit, for generating the general unique identifier of newdata storehouse access file and newdata storehouse; The general unique identifier of the newdata storehouse access file of generation and newdata storehouse is sent to database application user by instruction interface unit.
6. device according to claim 5, it is characterized in that, also comprise ATL and set up unit, wherein ATL set up unit comprise cluster select module, organizational structure sets up module, module set up by resource bag, ATL sets up module and ATL import module, wherein:
Cluster selects module, for when setting up the database template storehouse be associated with specified tissue, selects server cluster using as deployed position in cloud platform;
Organizational structure sets up module, for setting up organizational structure by demand;
Module set up by resource bag, for setting up the resource bag be associated with each tissue in organizational structure;
ATL sets up module, for setting up the database template storehouse be associated with each tissue;
ATL imports module, for being imported in the database template storehouse of foundation in the resource bag that is associated with respective organization.
7. device according to claim 6, is characterized in that, ATL is set up module and comprised virtual machine and set up module, installation module, package module and parameter set and set up module, wherein:
Virtual machine sets up module, for for each tissue, sets up at least one virtual machine in cloud platform;
Installation module, for installing the database of needs in the virtual machine set up;
Package module, for being encapsulated as database template by the virtual machine of installation database;
Parameter set sets up module, for setting up default database configuration parameter set.
8. device according to claim 6, is characterized in that, cluster selects module comprise identification module and select module, wherein:
Identification module, for judging in cloud platform whether presence server cluster;
Select module, for the judged result according to identification module, if in cloud platform presence server cluster, then in cloud platform, select the server cluster that existed using as deployed position; If not presence server cluster in cloud platform, then in cloud platform New Server cluster using as deployed position.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310671059.9A CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310671059.9A CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104717233A true CN104717233A (en) | 2015-06-17 |
| CN104717233B CN104717233B (en) | 2019-03-19 |
Family
ID=53416194
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310671059.9A Active CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104717233B (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106020857A (en) * | 2016-04-06 | 2016-10-12 | 杭州沃趣科技股份有限公司 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
| CN106844643A (en) * | 2017-01-13 | 2017-06-13 | 王洋 | A kind of Database Dynamic generation method based on template engine |
| CN107247812A (en) * | 2017-07-25 | 2017-10-13 | 郑州云海信息技术有限公司 | The generation method and generating means of a kind of database |
| CN107330682A (en) * | 2017-06-30 | 2017-11-07 | 杭州创匠信息科技有限公司 | A kind of mobile payment deployment system and its method |
| CN107665141A (en) * | 2016-07-27 | 2018-02-06 | 腾讯科技（深圳）有限公司 | A kind of configuration method for database and its equipment |
| CN107818104A (en) * | 2016-09-13 | 2018-03-20 | 腾讯科技（深圳）有限公司 | A kind of database portion arranging method, database deployment device, control device and system |
| CN108920685A (en) * | 2018-07-12 | 2018-11-30 | 郑州云海信息技术有限公司 | The management method and device of database in cloud data system |
| CN108959385A (en) * | 2018-05-31 | 2018-12-07 | 康键信息技术（深圳）有限公司 | Database portion arranging method, device, computer equipment and storage medium |
| CN109522295A (en) * | 2018-11-16 | 2019-03-26 | 中国银行股份有限公司 | A kind of database object constructs automatically, dispositions method and device |
| CN110781189A (en) * | 2019-10-25 | 2020-02-11 | 北京达佳互联信息技术有限公司 | Document platform construction method and device, electronic equipment and storage medium |
| CN111581179A (en) * | 2019-02-19 | 2020-08-25 | 上海云桓信息科技有限公司 | Data migration method and tool from Oracle to MySQL |
| CN112579143A (en) * | 2020-12-24 | 2021-03-30 | 江苏杰瑞信息科技有限公司 | Management platform system for designing software information security |
| CN113076112A (en) * | 2021-04-07 | 2021-07-06 | 网易（杭州）网络有限公司 | Database deployment method and device and electronic equipment |
| CN113778462A (en) * | 2021-09-14 | 2021-12-10 | 中国电信集团系统集成有限责任公司 | Method for personalized configuration of operating system and intelligent integration platform |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| CN102880715A (en) * | 2012-10-09 | 2013-01-16 | 南京市测绘勘察研究院有限公司 | Data pool management method and data pool management system on basis of cloud storage |
| US20130325890A1 (en) * | 2012-05-31 | 2013-12-05 | Ca, Inc. | Leveraging persisted data queries in stream-based complex event processing |
-
2013
- 2013-12-11 CN CN201310671059.9A patent/CN104717233B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| US20130325890A1 (en) * | 2012-05-31 | 2013-12-05 | Ca, Inc. | Leveraging persisted data queries in stream-based complex event processing |
| CN102880715A (en) * | 2012-10-09 | 2013-01-16 | 南京市测绘勘察研究院有限公司 | Data pool management method and data pool management system on basis of cloud storage |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106020857A (en) * | 2016-04-06 | 2016-10-12 | 杭州沃趣科技股份有限公司 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
| CN107665141B (en) * | 2016-07-27 | 2020-12-29 | 腾讯科技（深圳）有限公司 | Database configuration method and equipment thereof |
| CN107665141A (en) * | 2016-07-27 | 2018-02-06 | 腾讯科技（深圳）有限公司 | A kind of configuration method for database and its equipment |
| CN107818104B (en) * | 2016-09-13 | 2021-12-14 | 腾讯科技（深圳）有限公司 | Database deployment method, database deployment device, control equipment and system |
| CN107818104A (en) * | 2016-09-13 | 2018-03-20 | 腾讯科技（深圳）有限公司 | A kind of database portion arranging method, database deployment device, control device and system |
| CN106844643A (en) * | 2017-01-13 | 2017-06-13 | 王洋 | A kind of Database Dynamic generation method based on template engine |
| CN107330682A (en) * | 2017-06-30 | 2017-11-07 | 杭州创匠信息科技有限公司 | A kind of mobile payment deployment system and its method |
| CN107247812A (en) * | 2017-07-25 | 2017-10-13 | 郑州云海信息技术有限公司 | The generation method and generating means of a kind of database |
| CN107247812B (en) * | 2017-07-25 | 2021-01-15 | 苏州浪潮智能科技有限公司 | Database generation method and generation device |
| CN108959385A (en) * | 2018-05-31 | 2018-12-07 | 康键信息技术（深圳）有限公司 | Database portion arranging method, device, computer equipment and storage medium |
| CN108959385B (en) * | 2018-05-31 | 2024-02-06 | 康键信息技术（深圳）有限公司 | Database deployment method, device, computer equipment and storage medium |
| CN108920685A (en) * | 2018-07-12 | 2018-11-30 | 郑州云海信息技术有限公司 | The management method and device of database in cloud data system |
| CN108920685B (en) * | 2018-07-12 | 2021-11-26 | 郑州云海信息技术有限公司 | Management method and device for database in cloud data system |
| CN109522295B (en) * | 2018-11-16 | 2021-07-20 | 中国银行股份有限公司 | Automatic database object constructing and deploying method and device |
| CN109522295A (en) * | 2018-11-16 | 2019-03-26 | 中国银行股份有限公司 | A kind of database object constructs automatically, dispositions method and device |
| CN111581179A (en) * | 2019-02-19 | 2020-08-25 | 上海云桓信息科技有限公司 | Data migration method and tool from Oracle to MySQL |
| CN110781189A (en) * | 2019-10-25 | 2020-02-11 | 北京达佳互联信息技术有限公司 | Document platform construction method and device, electronic equipment and storage medium |
| CN110781189B (en) * | 2019-10-25 | 2022-08-26 | 北京达佳互联信息技术有限公司 | Document platform construction method and device, electronic equipment and storage medium |
| CN112579143A (en) * | 2020-12-24 | 2021-03-30 | 江苏杰瑞信息科技有限公司 | Management platform system for designing software information security |
| CN113076112A (en) * | 2021-04-07 | 2021-07-06 | 网易（杭州）网络有限公司 | Database deployment method and device and electronic equipment |
| CN113778462A (en) * | 2021-09-14 | 2021-12-10 | 中国电信集团系统集成有限责任公司 | Method for personalized configuration of operating system and intelligent integration platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104717233B (en) | 2019-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104717233A (en) | Database deployment method and device | |
| US11301287B2 (en) | Pattern-based orchestration of cloud provisioning tasks at runtime | |
| US9767312B2 (en) | System and method for integrating a cloud platform environment with an application server or other environment | |
| US10452374B2 (en) | System and method for providing a clone service for use with a cloud platform environment | |
| US8789041B2 (en) | Method and system for bulk automated virtual machine deployment | |
| US10212050B2 (en) | Providing recursively-generated instantiated computing resource in a multi-tenant environment | |
| CN107580083A (en) | A kind of method and system of container IP address distribution | |
| EP3455728A1 (en) | Orchestrator for a virtual network platform as a service (vnpaas) | |
| CN104781783B (en) | The integrated calculating platform disposed in existing computing environment | |
| US9201702B2 (en) | Integrated cloud data center management | |
| US9742688B2 (en) | System and method for supporting service resources and feature sets in a cloud platform environment | |
| CN111027921A (en) | Business processing method and device, electronic equipment and storage medium | |
| CN103167041A (en) | System and method for supporting cloud environment application cluster automation deployment | |
| CN108076156A (en) | A kind of mixing cloud system based on Chinese cloud product | |
| CN108111332A (en) | Using the mixing cloud management system and method for SDN | |
| CN109391688A (en) | The acquisition methods and device of image file in cloud computing system | |
| CN104700025A (en) | Software installation control method and system based on cloud computing | |
| CN112256439A (en) | Service directory dynamic updating system and method based on cloud computing resource pool | |
| JP2017528855A (en) | Hierarchical subscription management | |
| CN109144526B (en) | Rapid deployment system and method for substation automation software | |
| CN108810107B (en) | Cloud management platform and service method of two-state IT (information technology) business | |
| CN109660575B (en) | Method and device for realizing NFV service deployment | |
| CN107783822A (en) | A kind of method for managing resource and device | |
| US20230185629A1 (en) | Systems and methods for rapid assignment of pre-provisioned resources | |
| KR102035094B1 (en) | Method for automatically provisioning virtual desktop under virtual desktop infra, and virtualization system using the same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |