CN107861731A - A kind of Database Creation Method and device - Google Patents
A kind of Database Creation Method and device Download PDFInfo
- Publication number
- CN107861731A CN107861731A CN201711081219.9A CN201711081219A CN107861731A CN 107861731 A CN107861731 A CN 107861731A CN 201711081219 A CN201711081219 A CN 201711081219A CN 107861731 A CN107861731 A CN 107861731A
- Authority
- CN
- China
- Prior art keywords
- database
- image file
- installing
- configuration parameters
- creation method
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
-
- 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/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
-
- 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/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45533—Hypervisors; Virtual machine monitors
- G06F9/45558—Hypervisor-specific management and integration aspects
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of Database Creation Method and device, the above method and comprised the following steps：According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and database is created by the Agent.In above-mentioned technical proposal, after installing DB entity agent in image file obtains database configuration parameters, realize automatically creating for database, human users without specialty, simultaneously, database creation process is simplified, greatly reduces the appearance of the various problems caused by manual operation, improves the efficiency of installing DB deployment.
Description
Technical field
The invention belongs to field of cloud computer technology, more particularly to a kind of Database Creation Method and device.
Background technology
Under information age background, the demand that professional carries out data management using various databases is more and more,
Especially, it is necessary to be installed to multiple databases when the huge multiple databases of needs of data volume provide service.
The mode installed at present to database is：Professional upload installing DB file, manually perform installation,
Configuration, manual input commands duplication source data.
But technical problem caused by above-mentioned technical proposal：On the one hand, the installation of database is needed with professional skill water
Flat professional；On the other hand, the installation process of database is extremely cumbersome, and due to various problems caused by mistake not
Disconnected to occur, this causes installing DB efficiency to substantially reduce.
Therefore, there is an urgent need to provide a kind of database to create scheme to solve above-mentioned technical problem.
The content of the invention
The present invention provides a kind of Database Creation Method and device, to solve the above problems.
The embodiment of the present invention provides a kind of Database Creation Method, comprises the following steps：According to the type of database of establishment
It is determined that corresponding image file and setting database configuration parameters；
The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and passed through
The Agent creates database.
The embodiment of the present invention also provides a kind of database creating device, including processor, is adapted for carrying out each instruction；Storage is set
Standby, suitable for storing a plurality of instruction, the instruction is suitable to be loaded and performed by the processor；
According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；
The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and passed through
The Agent creates database.
The embodiment of the present invention provides following technical scheme：According to image file corresponding to the determination of the type of database of establishment simultaneously
Database configuration parameters are set；The database configuration parameters of setting are transmitted to the installing DB entity in the image file
Agent simultaneously creates database by the Agent.
It is real after the installing DB entity agent in image file obtains database configuration parameters in above-mentioned technical proposal
Existing database automatically creates, without the human users of specialty, meanwhile, database creation process is simplified, greatly reduces people
For the appearance of the various problems caused by operating, the efficiency that installing DB is disposed is improved.
Brief description of the drawings
Accompanying drawing described herein is used for providing a further understanding of the present invention, forms the part of the application, this hair
Bright schematic description and description is used to explain the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 show the Database Creation Method flow chart of the embodiment of the present invention 1；
The Agent that Fig. 2 show the embodiment of the present invention 2 performs method flow diagram；
Fig. 3 show the Database Creation Method flow chart of the embodiment of the present invention 3；
Fig. 4 show the database creating device structure chart of the embodiment of the present invention 4.
Embodiment
Describe the present invention in detail below with reference to accompanying drawing and in conjunction with the embodiments.It should be noted that do not conflicting
In the case of, the feature in embodiment and embodiment in the application can be mutually combined.
The embodiments of the invention provide a kind of Database Creation Method：The mirror according to corresponding to determining the type of database of establishment
As file and database configuration parameters are set；The database configuration parameters of setting are transmitted to the database in the image file
Entity agent is installed and database is created by the Agent.
Concrete scheme is described below：
1) in cloud computing system, there is provided the image file with installing DB file；
Wherein, mirror file system is Linux system, and type of database is including Mysql, MangoDB, Oracle etc., often
The corresponding image file of kind of database, the database in each image file have the installing DB text of multiple optional versions
Part；Installing DB entity agent is carried in image file, Agent is responsible for the installation of database, configuration etc.；
2) image file with installing DB file is stored in the image file storehouse of cloud computing system in advance, when
When user needs to create database, type of database as needed first, an image file is selected, selects number to be mounted
According to storehouse version, selection provides the network of database service, inputs the title for wanting initialization data storehouse, administrator username, password
Deng；
3) embodiment of the present invention provides the replicate data from data with existing storehouse simultaneously, or recovers data from backup, uses
Family can dispose a brand-new database service as needed, can also select after deployment, from other database services
Replicate data；
4) when user completes above-mentioned steps 2), input 3) after, these configuration parameters are passed in image file
Agent, Agent, first using corresponding image file as template, create a virtual machine, Ran Hou according to these configuration parameters
The database of version selected by installation on the virtual machine, and system operational parameters are configured, create the user's group of database, use
Family, set, by selected network, configure and the information such as address, the port of database service are externally provided.If
User's selection services replicate data from data with existing storehouse, and Agent will replicate existing data to new from selected database service
In the database of establishment, the quick establishment of a database service is otherwise completed.
By the embodiment of the present invention, it can realize that quick, simple automation creates database clothes in cloud computing system
Business, contrasts traditional upload installing DB file, manually performs installation, configuration, manual input commands duplication source data, this hair
Bright embodiment helps user to avoid the appearance of various problems caused by mistake departing from cumbersome script command, make wound
The work for building database service is no longer required for the professional skill level of user, improves operating efficiency, improves high-volume data
The deployment efficiency of storehouse service.
Fig. 1 show the Database Creation Method flow chart of the embodiment of the present invention 1, comprises the following steps：
Step 101：Start；
Step 102：The image file according to corresponding to determining the type of database of establishment；
Wherein, system provides the image file for being provided with database file, Agent in advance, and is stored in cloud computing system
Assigned catalogue in；
Step 103：Select the database version of installation；
Step 104：Selection provides the network of database service；
Step 105：The information input of initialization data storehouse, including：Input initialization database-name, administrator username,
Administrator's password；
Step 106：Select database data acquisition modes；
Step 107：Carry out database establishment；
Step 108：Terminate.
The Agent that Fig. 2 show the embodiment of the present invention 2 performs method flow diagram, comprises the following steps：
Step 201：Start；
Step 202：Using image file as template, a virtual machine is created；
Step 203：The database of corresponding version is installed on the virtual machine；
Step 204：According to the database configuration parameters of setting, the database is configured；
Step 205：Judge whether copy source data, if so, then performing step 206；If it is not, then perform step 207；
Step 206：In the database for copying data to establishment from specified data source；
Step 207：Log-on data storehouse services；
Step 208：Terminate.
The embodiment of the present invention realizes that quick, simple automation creates database in cloud computing system, helps user to take off
From cumbersome script command, the appearance of various problems caused by mistake is avoided, makes the work of establishment database service
It is horizontal to be no longer required for the professional skill of user, improves operating efficiency, improves the deployment efficiency of high-volume database service.
Fig. 3 show the Database Creation Method flow chart of the embodiment of the present invention 3, comprises the following steps：
Step 301：According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；
Further, the image file and before database configuration parameters are set according to corresponding to determining type of database, also
Including：
Type of database and image file contrast relationship are pre-established, wherein, the type of database includes：Mysql、
MangoDB、0racle。
Further, the image file includes installing DB file, the database of one or more database versions
Entity agent is installed.
Further, the setting database configuration parameters include：The database version of installation, selection is selected to provide data
The network of storehouse service, input initialization database-name, administrator username, administrator's password, database data acquisition modes.
Step 302：The database configuration parameters of setting are transmitted to the installing DB entity in the image file
Agent simultaneously creates database by the Agent.
Further, using the image file as template, a virtual machine is created；
The database of corresponding version is installed on the virtual machine and the database is configured.
Further, the mode configured to the database includes：Configuration database operational factor；Create database
User's group, user；Configuration database environmental variance；By selecting the network of offer database service, configure and number is externally provided
According to the address of storehouse service, port.
Further, the mode configured to the database also includes：If the database data acquisition modes are
Data are obtained from target database, then obtain data to the database of establishment from the target database.
Fig. 4 show the database creating device structure chart of the embodiment of the present invention 4, including processor, is adapted for carrying out each finger
Order；Storage device, suitable for storing a plurality of instruction, the instruction is suitable to be loaded and performed by the processor；
According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；
The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and passed through
The Agent creates database.
Further, type of database and image file contrast relationship are pre-established, wherein, the type of database bag
Include：Mysql、MangoDB、Oracle.
Further, the image file includes installing DB file, the database of one or more database versions
Entity agent is installed.
Further, the setting database configuration parameters include：The database version of installation, selection is selected to provide data
The network of storehouse service, input initialization database-name, administrator username, administrator's password, database data acquisition modes.
Further, using the image file as template, a virtual machine is created；
The database of corresponding version is installed on the virtual machine and the database is configured.
Further, the mode configured to the database includes：Configuration database operational factor；Create database
User's group, user；Configuration database environmental variance；By selecting the network of offer database service, configure and number is externally provided
According to the address of storehouse service, port.
Further, the mode configured to the database also includes：If the database data acquisition modes are
Data are obtained from target database, then obtain data to the database of establishment from the target database.
The embodiment of the present invention provides following technical scheme：According to image file corresponding to the determination of the type of database of establishment simultaneously
Database configuration parameters are set；The database configuration parameters of setting are transmitted to the installing DB entity in the image file
Agent simultaneously creates database by the Agent.
It is real after the installing DB entity agent in image file obtains database configuration parameters in above-mentioned technical proposal
Existing database automatically creates, without the human users of specialty, meanwhile, database creation process is simplified, greatly reduces people
For the appearance of the various problems caused by operating, the efficiency that installing DB is disposed is improved.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.
Claims (14)
1. a kind of Database Creation Method, it is characterised in that comprise the following steps：
According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；
The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and by described
Agent creates database.
2. Database Creation Method according to claim 1, it is characterised in that pre-establish type of database and mirror image text
Part contrast relationship, wherein, the type of database includes：Mysql、MangoDB、Oracle.
3. Database Creation Method according to claim 1 or 2, it is characterised in that the image file include one or
Installing DB file, the installing DB entity agent of multiple database versions.
4. Database Creation Method according to claim 3, it is characterised in that the setting database configuration parameters bag
Include：The database version of installation, selection is selected to provide the network, input initialization database-name, keeper of database service
User name, administrator's password, database data acquisition modes.
5. Database Creation Method according to claim 4, it is characterised in that
Using the image file as template, a virtual machine is created；
The database of corresponding version is installed on the virtual machine and the database is configured.
6. Database Creation Method according to claim 5, it is characterised in that the mode configured to the database
Including：Configuration database operational factor；Create user's group, the user of database；Configuration database environmental variance；Carried by selection
For the network of database service, address, the port that database service is externally provided are configured.
7. Database Creation Method according to claim 5, it is characterised in that the mode configured to the database
Also include：If the database data acquisition modes are to obtain data from target database, obtained from the target database
The database that data extremely create.
8. a kind of database creating device, it is characterised in that including processor, be adapted for carrying out each instruction；Storage device, suitable for depositing
A plurality of instruction is stored up, the instruction is suitable to be loaded and performed by the processor；
According to image file corresponding to the determination of the type of database of establishment and database configuration parameters are set；
The database configuration parameters of setting are transmitted to the installing DB entity agent in the image file and by described
Agent creates database.
9. database creating device according to claim 8, it is characterised in that pre-establish type of database and mirror image text
Part contrast relationship, wherein, the type of database includes：Mysql、MangoDB、Oracle.
10. database creating device according to claim 8 or claim 9, it is characterised in that the image file include one or
Installing DB file, the installing DB entity agent of multiple database versions.
11. database creating device according to claim 10, it is characterised in that the setting database configuration parameters bag
Include：The database version of installation, selection is selected to provide the network, input initialization database-name, keeper of database service
User name, administrator's password, database data acquisition modes.
12. database creating device according to claim 11, it is characterised in that
Using the image file as template, a virtual machine is created；
The database of corresponding version is installed on the virtual machine and the database is configured.
13. database creating device according to claim 12, it is characterised in that the side configured to the database
Formula includes：Configuration database operational factor；Create user's group, the user of database；Configuration database environmental variance；Pass through selection
The network of database service is provided, configures address, the port that database service is externally provided.
14. database creating device according to claim 12, it is characterised in that the side configured to the database
Formula also includes：If the database data acquisition modes are to obtain data from target database, obtained from the target database
Access is according to the database to establishment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711081219.9A CN107861731A (en) | 2017-11-06 | 2017-11-06 | A kind of Database Creation Method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711081219.9A CN107861731A (en) | 2017-11-06 | 2017-11-06 | A kind of Database Creation Method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107861731A true CN107861731A (en) | 2018-03-30 |
Family
ID=61701015
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711081219.9A Pending CN107861731A (en) | 2017-11-06 | 2017-11-06 | A kind of Database Creation Method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107861731A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108920685A (en) * | 2018-07-12 | 2018-11-30 | 郑州云海信息技术有限公司 | The management method and device of database in cloud data system |
| CN110968565A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Database creation method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8286253B1 (en) * | 2009-11-23 | 2012-10-09 | Trend Micro Incorporated | Data leakage prevention for resource limited device |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
| CN104579761A (en) * | 2014-12-24 | 2015-04-29 | 西安工程大学 | Automatic nosql cluster configuration system and method based on cloud computing |
| CN106603725A (en) * | 2017-02-03 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | Implementation method for enterprise cloud service virtual mirror image management service |
-
2017
- 2017-11-06 CN CN201711081219.9A patent/CN107861731A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8286253B1 (en) * | 2009-11-23 | 2012-10-09 | Trend Micro Incorporated | Data leakage prevention for resource limited device |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
| CN104579761A (en) * | 2014-12-24 | 2015-04-29 | 西安工程大学 | Automatic nosql cluster configuration system and method based on cloud computing |
| CN106603725A (en) * | 2017-02-03 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | Implementation method for enterprise cloud service virtual mirror image management service |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN110968565A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Database creation method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20240045585A1 (en) | User interface for database management services | |
| US10033831B2 (en) | Dynamic workflow generation | |
| US20240045834A1 (en) | System and method for protecting databases in a hyperconverged infrastructure system | |
| US10528333B2 (en) | Deploying an application in a cloud computing environment | |
| US11860818B2 (en) | System and method for provisioning databases in a hyperconverged infrastructure system | |
| CN103443783B (en) | For having the device and method of the supply based on state of the local client computer of embedded image based on Windows | |
| US10116508B2 (en) | Server profile templates | |
| US9883394B2 (en) | Virtual mobile phone interface system and method thereof | |
| JP4475079B2 (en) | Computer system configuration management method | |
| US20110314466A1 (en) | Creating instances of cloud computing environments | |
| US20230130973A1 (en) | System and method for creating template for database services | |
| US20130311631A1 (en) | Integrated cloud data center management | |
| WO2019148830A1 (en) | Method and apparatus for baseboard management controller to mount folder by means of kvm | |
| CN110913016A (en) | Resource management system for cloud resource platform and storage medium | |
| CN105184145A (en) | Permission management method and management apparatus | |
| CN107861731A (en) | A kind of Database Creation Method and device | |
| CN109725958A (en) | The method and device that the file of resource manager management is handled | |
| TW202037131A (en) | ICT resource management device, ICT resource management method and ICT resource management program | |
| CN109218378B (en) | Design method of small logistics management platform based on cloud platform | |
| CN107203333B (en) | The method that block storage automatically accesses in OpenStack cloud computing platform | |
| CN101373464B (en) | Method, apparatus and system for automatically adopting form setting | |
| CN109144657A (en) | A kind of method and apparatus of the file-sharing of spanning operation system platform | |
| CN106557354A (en) | The method and computer equipment of the property parameters of privately owned mirror image are set | |
| CN109214207A (en) | The management method and device of permission in the network of multi-user access | |
| CN107357634A (en) | A kind of parameter configuration management method and device |
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: 20180330 |