CN109062732A - A kind of database service method and system - Google Patents
A kind of database service method and system Download PDFInfo
- Publication number
- CN109062732A CN109062732A CN201810803853.7A CN201810803853A CN109062732A CN 109062732 A CN109062732 A CN 109062732A CN 201810803853 A CN201810803853 A CN 201810803853A CN 109062732 A CN109062732 A CN 109062732A
- Authority
- CN
- China
- Prior art keywords
- database
- mirroring
- cloud host
- cloud
- host
- 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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
-
- 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)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of database service method and systems.It is related to virtual platform technology, solves the problems, such as that the mechanism of database service can be provided in virtual platform by lacking one.This method comprises: uploading at least one customized database mirroring, the type of database and version of each database mirroring are registered；Cloud host is created, the database mirroring is loaded by the cloud host, database service is provided.Technical solution provided by the invention is suitable for cloud computing data management, realizes the raising of the utilization rate and utilization rate of physical resource equipment.
Description
Technical field
The present invention relates to virtual platform technology, espespecially a kind of database implementation method and system.
Background technique
In cloud computing era, as the application field of cloud service is more and more wider, for publicly-owned cloud computing platform, only
This three big service of calculating, network and storage is often less enough.Under the current Internet application background that a hundred flowers blossom, almost
All applications all use database, and database carrying is often to apply most crucial data.In addition, in big data analysis
Under background more and more prevailing, even more important is also become to the reliable convenient management of database.Therefore, database service (DBase
As a Service, DBaaS) also just become the important clothes that cloud computing platform is user's creation value naturally
Business.
Currently, the mechanism of database service can be provided in virtual platform by still lacking one.
Summary of the invention
In order to solve the above-mentioned technical problems, the present invention provides a kind of database service method and systems.
In order to reach the object of the invention, the present invention provides a kind of database service implementation methods, comprising:
At least one customized database mirroring is uploaded, the type of database and version of each database mirroring are registered
This；
Cloud host is created, the database mirroring is loaded by the cloud host, database service is provided.
Preferably, the creation cloud host loads the database mirroring by the cloud host, provides database service
The step of before, further includes:
External network and internal network are created, the external network and the internal network are connected.
Preferably, the cloud host is created in the internal network.
Preferably, the creation cloud host loads the database mirroring by the cloud host, provides database service
The step of include:
It obtains any or any multinomial in the relevant information of following data library:
Title, cloud hard disk, example specification, internal network, type of database, database version, database-name, user
Name, password, host；
The cloud host is created, is serviced according to the database relevant information log-on data library.
The present invention also provides a kind of database services to realize system, comprising:
Register platforms register each database mirroring for uploading at least one customized database mirroring
Type of database and version；
Virtual machine platform loads the database mirroring by the cloud host, provides database for creating cloud host
Service.
Preferably, the system further include:
Network management module connects the external network and the intranet for creating external network and internal network
Network.
Preferably, the virtual machine platform includes:
Interactive module, any or any multinomial in the relevant information of following data library for obtaining:
Title, cloud hard disk, example specification, internal network, type of database, database version, database-name, user
Name, password, host；
Host creation module is serviced for creating the cloud host according to the database relevant information log-on data library.
The present invention provides a kind of database service method and systems, upload at least one customized database mirror
Picture registers the type of database and version of each database mirroring, then creates cloud host, is loaded by the cloud host
The database mirroring, provides database service.It realizes and provides database service in virtual cloud platform, improve physics money
The utilization rate and utilization rate of source device solve the problems, such as to lack virtual platform database service realization mechanism.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification
It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by specification, right
Specifically noted structure is achieved and obtained in claim and attached drawing.
Detailed description of the invention
Attached drawing is used to provide to further understand technical solution of the present invention, and constitutes part of specification, with this
The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is a kind of flow diagram for database service implementation method that one embodiment of the invention provides；
Fig. 2 is the realization principle schematic diagram for another database service implementation method that one embodiment of the invention provides；
Fig. 3 is a kind of structural schematic diagram for database management systems that one embodiment of the invention provides；
Fig. 4 is the structural schematic diagram of virtual machine platform 302 in Fig. 3.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention
Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application
Feature can mutual any combination.
Step shown in the flowchart of the accompanying drawings can be in a computer system such as a set of computer executable instructions
It executes.Also, although logical order is shown in flow charts, and it in some cases, can be to be different from herein suitable
Sequence executes shown or described step.
In cloud computing era, as the application field of cloud service is more and more wider, for publicly-owned cloud computing platform, only
This three big service of calculating, network and storage is often less enough.Under the current Internet application background that a hundred flowers blossom, almost
All applications all use database, and database carrying is often to apply most crucial data.In addition, in big data analysis
Under background more and more prevailing, even more important is also become to the reliable convenient management of database.Therefore, DBaaS also just along reason at
Becoming to chapter cloud computing platform is the critical services that user creates value.
Currently, the mechanism of database service can be provided in virtual platform by still lacking one.
Based on the above issues, the embodiment provides a kind of database service method and systems.It ties below
Attached drawing is closed, the embodiment of the present invention is described in detail.
One embodiment of the invention provides a kind of database service implementation method, using this method on virtual platform
The process for providing database service is as shown in Figure 1, comprising:
Step 101 uploads at least one customized database mirroring, registers the database of each database mirroring
Type and version；
Step 102, creation external network and internal network, connect the external network and the internal network.
Step 103, creation cloud host, load the database mirroring by the cloud host, provide database service.
This step includes:
1, it obtains any or any multinomial in the relevant information of following data library:
Cloud Hostname, cloud hard disk, example specification, internal network, type of database, database version, database-name,
User name, password, the Host List (including the IP information of host in the list) for allowing to connect the database；
2, the cloud host is created, is serviced according to the database relevant information log-on data library.Specifically, described interior
The virtual machine of cloud host described in portion's network creation.
One embodiment of the invention provides a kind of database service implementation method again, makes customized mysql number of types
According to library mirror image, OpenStack virtual platform is uploaded to, the database of mysql type is created that by mysql database mirroring
Example.
Realization principle configures vxlan as shown in Fig. 2, by configuring flat external network on OpenStack virtual platform
Flat external network and virtual expansible local area network (vxlan) type internal network are got through in type internal network, creation routing, on
The Mysql database mirroring from production is passed, Mysql type of database version is registered；Then pass through maintenance title, cloud hard disk, reality
The information such as convention lattice, network, type of database version, database-name, user name, password, it is final to realize creation Mysql data
The target in library.
First of all, it is necessary to have OpenStack virtual platform, Nova, Cinder of OpenStack environment, Neutron,
Trove module normal operation.
It then, is that Mysql database service is prepared in OpenStack virtual platform, comprising:
First: uploading customized Mysql database mirroring, use mirror image registration database type and version；
Second: one flat type external network of creation；Create the internal network of a vxlan type；Create a road
By interconnecting external network with internal network.
Finally, executing the Mysql database service of creation OpenStack virtual platform, comprising:
First: input title, cloud hard disk size, example specification, network (internal network of creation), type of database, number
According to library version；
Second: input data library name, user name, password, host；
Third: SkyLine module collection data sending request；API receives request and carries out verification requesting data information, verifies
By sending task manager (TaskManager)；TaskManager receive request by call Nova, Cinder,
The asset creations such as Neutron go out cloud host, act on behalf of the service of (guestagent) log-on data library by visitor inside cloud host；
Conductor receives cloud host message, updates database service example state, and creation is completed.
One embodiment of the invention additionally provides a kind of database service and realizes system, the construction of the system as shown in figure 3,
Include:
Register platforms 301 register each database mirroring for uploading at least one customized database mirroring
Type of database and version；
Virtual machine platform 302 loads the database mirroring by the cloud host, provides number for creating cloud host
It is serviced according to library.
Preferably, the system further include:
Network management module 303 connects the external network and the inside for creating external network and internal network
Network.
Preferably, the structure of the virtual machine platform 302 is as shown in Figure 4, comprising:
Interactive module 3021, any or any multinomial in the relevant information of following data library for obtaining:
Title, cloud hard disk, example specification, internal network, type of database, database version, database-name, user
Name, password, host；
Host creation module 3022, for creating the cloud host, according to the database relevant information log-on data library
Service.
The embodiment provides a kind of database service method and system, upload it is customized at least one
Database mirroring registers the type of database and version of each database mirroring, then creates cloud host, passes through the cloud
Host loads the database mirroring, provides database service.It realizes and provides database service in virtual cloud platform, solve
The problem of shortage virtual platform database service realization mechanism.
The mode of scheduling of resource is changed into virtual machine granularity from traditional physical machine granularity., can be in separate unit physical machine
Mass data library virtual machine instance is run, effective use and the Skill aims of physical resource may be implemented, it can be by simple defeated
Enter some essential informations and complete database creation and configuration, control then can be managed to numerous databases and completes to need
It wants, improves physical resource utilization rate of equipment and installations and utilization rate.
It in a particular application, can be reasonable by designing reasonable network configuration and customized Mysql database mirroring
And it is easy complete the creation of Mysql database and configuration under OpenStack virtual platform, and then reduce by computer hardware and soft
Loss brought by part fallibility.
It will appreciated by the skilled person that whole or certain steps, system, dress in method disclosed hereinabove
Functional module/unit in setting may be implemented as software, firmware, hardware and its combination appropriate.In hardware embodiment,
Division between the functional module/unit referred in the above description not necessarily corresponds to the division of physical assemblies；For example, one
Physical assemblies can have multiple functions or a function or step and can be executed by several physical assemblies cooperations.Certain groups
Part or all components may be implemented as by processor, such as the software that digital signal processor or microprocessor execute, or by
It is embodied as hardware, or is implemented as integrated circuit, such as specific integrated circuit.Such software can be distributed in computer-readable
On medium, computer-readable medium may include computer storage medium (or non-transitory medium) and communication media (or temporarily
Property medium).As known to a person of ordinary skill in the art, term computer storage medium is included in for storing information (such as
Computer readable instructions, data structure, program module or other data) any method or technique in the volatibility implemented and non-
Volatibility, removable and nonremovable medium.Computer storage medium include but is not limited to RAM, ROM, EEPROM, flash memory or its
His memory technology, CD-ROM, digital versatile disc (DVD) or other optical disc storages, magnetic holder, tape, disk storage or other
Magnetic memory apparatus or any other medium that can be used for storing desired information and can be accessed by a computer.This
Outside, known to a person of ordinary skill in the art to be, communication media generally comprises computer readable instructions, data structure, program mould
Other data in the modulated data signal of block or such as carrier wave or other transmission mechanisms etc, and may include any information
Delivery media.
Claims (7)
1. a kind of database service implementation method characterized by comprising
At least one customized database mirroring is uploaded, the type of database and version of each database mirroring are registered；
Cloud host is created, the database mirroring is loaded by the cloud host, database service is provided.
2. database service implementation method according to claim 1, which is characterized in that the creation cloud host passes through institute
Before the step of stating the cloud host load database mirroring, database service be provided, further includes:
External network and internal network are created, the external network and the internal network are connected.
3. database service implementation method according to claim 2, which is characterized in that described in internal network creation
Cloud host.
4. database service implementation method according to claim 2, which is characterized in that the creation cloud host passes through institute
Stating the step of cloud host loads the database mirroring, provides database service includes:
It obtains any or any multinomial in the relevant information of following data library:
Cloud Hostname, cloud hard disk, example specification, internal network, type of database, database version, database-name, user
Name, password, the Host List for allowing to connect the database；
The cloud host is created, is serviced according to the database relevant information log-on data library.
5. system is realized in a kind of database service characterized by comprising
Register platforms register the data of each database mirroring for uploading at least one customized database mirroring
Library type and version；
Virtual machine platform loads the database mirroring by the cloud host for creating cloud host, provides database clothes
Business.
6. system is realized in database service according to claim 5, which is characterized in that the system further include:
Network management module connects the external network and the internal network for creating external network and internal network.
7. system is realized in database service according to claim 6, which is characterized in that the virtual machine platform includes:
Interactive module, any or any multinomial in the relevant information of following data library for obtaining:
It is title, cloud hard disk, example specification, internal network, type of database, database version, database-name, user name, close
Code, host；
Host creation module is serviced for creating the cloud host according to the database relevant information log-on data library.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810803853.7A CN109062732A (en) | 2018-07-20 | 2018-07-20 | A kind of database service method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810803853.7A CN109062732A (en) | 2018-07-20 | 2018-07-20 | A kind of database service method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109062732A true CN109062732A (en) | 2018-12-21 |
Family
ID=64816036
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810803853.7A Pending CN109062732A (en) | 2018-07-20 | 2018-07-20 | A kind of database service method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109062732A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117667241A (en) * | 2024-02-01 | 2024-03-08 | 龙芯中科技术股份有限公司 | Device loading method and device, electronic device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714089A (en) * | 2012-09-29 | 2014-04-09 | 上海盛大网络发展有限公司 | Method and system of rolling back cloud database |
| US20150242104A1 (en) * | 2014-02-24 | 2015-08-27 | Icos Llc | Easy-to-use desktop screen recording application |
| CN107391665A (en) * | 2017-07-20 | 2017-11-24 | 郑州云海信息技术有限公司 | The creation method and device of a kind of database instance |
| CN107547250A (en) * | 2017-06-26 | 2018-01-05 | 新华三云计算技术有限公司 | The method and apparatus that database is disposed in cloud computing management platform |
-
2018
- 2018-07-20 CN CN201810803853.7A patent/CN109062732A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714089A (en) * | 2012-09-29 | 2014-04-09 | 上海盛大网络发展有限公司 | Method and system of rolling back cloud database |
| US20150242104A1 (en) * | 2014-02-24 | 2015-08-27 | Icos Llc | Easy-to-use desktop screen recording application |
| CN107547250A (en) * | 2017-06-26 | 2018-01-05 | 新华三云计算技术有限公司 | The method and apparatus that database is disposed in cloud computing management platform |
| CN107391665A (en) * | 2017-07-20 | 2017-11-24 | 郑州云海信息技术有限公司 | The creation method and device of a kind of database instance |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117667241A (en) * | 2024-02-01 | 2024-03-08 | 龙芯中科技术股份有限公司 | Device loading method and device, electronic device and storage medium |
| CN117667241B (en) * | 2024-02-01 | 2024-04-26 | 龙芯中科技术股份有限公司 | Device loading method and device, electronic device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11237812B2 (en) | Deploying an application in a cloud computing environment | |
| US10958739B2 (en) | Capturing a virtual configuration from cloud-provisioning data | |
| US10382291B2 (en) | Provisioning framework for binding related cloud services | |
| US9912609B2 (en) | Placement policy-based allocation of computing resources | |
| US9177132B2 (en) | Capturing data parameters in templates in a networked computing environment | |
| US20180316551A1 (en) | Portable instance provisioning framework for cloud services | |
| US20180081643A1 (en) | Controlled availability of objects in a visual design tool for integration development | |
| US10783128B2 (en) | Rule based data processing | |
| GB2536351A (en) | Creating sustainable innovation platforms based on service first and service now approach | |
| US20160359984A1 (en) | Web services documentation | |
| US10089293B2 (en) | QR code loading of form elements | |
| US11334601B2 (en) | Unified data model | |
| WO2023279869A1 (en) | Continuous liveness and integrity of applications during migration | |
| US20200089656A1 (en) | Dynamic file name generation for a plurality of devices | |
| CN109062732A (en) | A kind of database service method and system | |
| CN108762890A (en) | The management method and device of database in cloud management platform | |
| US10397171B2 (en) | Managing content disclosure on social networking sites | |
| US20180341463A1 (en) | Software object definition and integration | |
| US20180098102A1 (en) | Limited use media access tokens | |
| US20220138220A1 (en) | Dedicated replication channels for replicating records between regions | |
| US11558387B2 (en) | Validation of approver identifiers in a cloud computing environment | |
| CN114070889A (en) | Configuration method, traffic forwarding method, device, storage medium, and program product | |
| CN112632016A (en) | File editing method and device | |
| WO2018120222A1 (en) | Vnffg management method, device and system | |
| US11914733B2 (en) | Timing for user data erasure requests |
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 |
Application publication date: 20181221 |
|
| RJ01 | Rejection of invention patent application after publication |