CN109840094B - Database deployment method and device and storage equipment - Google Patents
Database deployment method and device and storage equipment Download PDFInfo
- Publication number
- CN109840094B CN109840094B CN201711191088.XA CN201711191088A CN109840094B CN 109840094 B CN109840094 B CN 109840094B CN 201711191088 A CN201711191088 A CN 201711191088A CN 109840094 B CN109840094 B CN 109840094B
- Authority
- CN
- China
- Prior art keywords
- database
- information
- virtual machine
- cloud storage
- physical machine
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method and a device for deploying a database and storage equipment, which are applied to the technical field of information processing. In the embodiment of the invention, the application request of the database can be initiated through the terminal equipment, then the deployment device of the database is used for firstly configuring the first information of the virtual machine, the second information of the cloud storage module and the third information of the database, then the virtual machine is created in the physical machine according to the first information, the cloud storage module mounted by the virtual machine is created according to the second information, and finally the database is created in the virtual machine according to the third information and the application request, so that the database is automatically deployed by the deployment device of the database without manual participation, and the deployment efficiency of the database is improved. And the process of applying for the database is automatically completed through the communication between the terminal equipment and the deployment device of the database, so that the efficiency of applying for the database is improved. And because the physical machine can support more business operations, the utilization rate of the physical machine is improved.
Description
Technical Field
The present invention relates to the field of information processing technologies, and in particular, to a method and an apparatus for deploying a database, and a storage device.
Background
As information expands, information is typically stored in a large number of databases, such as Oracle (Oracle) databases, within various enterprise Information Technologies (IT). If a new database is needed, an enterprise user can apply for a physical machine to a specific organization through mails, telephones or various modes, so that staff of the specific organization can check the application of the enterprise user, and if the application passes the check, the staff can directly set the processing and the storage of the database on one physical machine and inform the enterprise user of the set information of the database.
In the application process of the existing database, more than 5 days are generally required from the application of a physical machine to the passing of audit, and at least more than 2 days are required for a worker to set the database on one physical machine, so that the time consumption of the whole process from the time when an enterprise user starts to apply the database to the time when the worker informs the set database information to the enterprise user is long.
Disclosure of Invention
The embodiment of the invention provides a method and a device for deploying a database and storage equipment, which realize automatic deployment of the corresponding database according to an application request of the database sent by terminal equipment.
A first aspect of an embodiment of the present invention provides a method for deploying a database, including:
receiving an application request of a database sent by a terminal device, wherein the application request comprises the type of the database;
selecting a physical machine according to the application request, and configuring first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module and third information of a corresponding database; the virtual machine processes data based on the database, and the cloud storage module is used for accessing cloud storage resources which are used for storing the data processed by the virtual machine;
sending the configured first information to the physical machine through a virtual machine creation request so that the physical machine creates a virtual machine in the physical machine according to the first information;
sending the configured second information to the created virtual machine through a cloud storage module creation request so that the virtual machine can create a corresponding cloud storage module according to the second information; and sending the configured third information and the type of the database to the virtual machine through a database creation request so that the virtual machine can create a database according to the third information and the type of the database.
A second aspect of the embodiments of the present invention provides a database deployment apparatus, including:
the device comprises a request receiving unit, a database processing unit and a database processing unit, wherein the request receiving unit is used for receiving an application request of a database sent by a terminal device, and the application request comprises the type of the database;
the information configuration unit is used for selecting a physical machine according to the application request, and configuring first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module and third information of a corresponding database; the virtual machine processes data based on the database, and the cloud storage module is used for accessing cloud storage resources which are used for storing the data processed by the virtual machine;
a first creating unit, configured to send the configured first information to the physical machine through a virtual machine creating request, so that the physical machine creates a virtual machine in the physical machine according to the first information;
a second creating unit, configured to send the configured second information to the created virtual machine through a cloud storage module creating request, so that the virtual machine creates a corresponding cloud storage module according to the second information; and sending the configured third information and the type of the database to the virtual machine through a database creation request so that the virtual machine can create a database according to the third information and the type of the database.
A third aspect of the present embodiment provides a storage device, where the storage device stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the database deployment method according to the first aspect of the present embodiment.
A fourth aspect of the embodiments of the present invention provides a terminal device, including a processor and a storage device, where the processor is configured to implement each instruction;
the storage device is configured to store a plurality of instructions, where the instructions are configured to be loaded by a processor and to perform the database deployment method according to the first aspect of the embodiment of the present invention.
Therefore, in the embodiment of the present invention, an application request of a database may be initiated by a terminal device, then a deployment device of the database configures first information of a virtual machine, second information of a cloud storage module and third information of the database, then the virtual machine is created in a physical machine according to the first information, the cloud storage module mounted by the virtual machine is created according to the second information, and finally a database is created in the virtual machine according to the third information and the application request. And the process of applying for the database is automatically completed through the communication between the terminal equipment and the deployment device of the database, so that the efficiency of applying for the database is improved. In addition, in the embodiment, the processing of the database is set on the physical machine, and the storage of the database is set on the cloud storage resource, so that the calculation and the storage of the data are separately performed, and the storage efficiency of the data can be improved; in addition, a plurality of virtual machines can be created in the physical machine, and each virtual machine can support one service, so that the physical machine can support more service operations, and the utilization rate of the physical machine is further improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic view of a scenario in which a method for deploying a database according to an embodiment of the present invention is applied;
FIG. 2 is a flowchart of a method for deploying a database according to an embodiment of the present invention;
FIG. 3 is a flowchart of a method for deploying a database according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an application form displayed on a user interface by a terminal device in an embodiment of the present invention;
FIG. 5 is a schematic diagram of a cloud platform creating a virtual machine in an embodiment of the present invention;
FIG. 6 is a diagram illustrating an enterprise terminal expansion database in an exemplary embodiment of the present invention;
fig. 7 is a schematic structural diagram of a database deployment apparatus according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of another database deployment apparatus provided in the embodiment of the present invention;
fig. 9 is a schematic structural diagram of a server according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The embodiment of the invention provides a deployment method of a database, which is mainly applied to but not limited to a scene shown in fig. 1, wherein in the scene:
the user can operate the terminal equipment to log in the cloud platform, the cloud platform can send the application form of the database to the terminal equipment, and the terminal equipment displays the application form on a user interface, so that the user can input the related information of the database to be applied to the user interface displayed by the terminal equipment; and then the terminal equipment sends the information input by the user to the cloud platform through an application request of the database. The cloud platform deploys the database in the following method:
receiving an application request of a database sent by a terminal device, wherein the application request comprises the type of the database; the method comprises the steps of selecting a physical machine according to an application request, configuring first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module and third information of a corresponding database, processing data by the virtual machine based on the database, accessing cloud storage resources by the cloud storage module, and storing data processed by the virtual machine by the cloud storage resources. Here, the cloud storage resource is a distributed storage resource in a network, and specifically is a storage resource of a plurality of storage nodes (illustrated in fig. 1 by taking n storage nodes as an example) in the cloud storage system shown in fig. 1.
Sending the configured first information to the physical machine through a virtual machine creation request so that the physical machine creates a virtual machine in the physical machine according to the first information; sending the configured second information to the created virtual machine through a cloud storage module creation request so that the virtual machine can create a corresponding cloud storage module according to the second information; and sending the configured third information and the type of the database to the virtual machine through a database creation request so that the virtual machine can create the database according to the third information and the type of the database.
The cloud storage resource refers to a storage resource of each storage node in the cloud storage system.
Therefore, in the embodiment, the database is automatically deployed by the deployment device of the database without manual participation, and the efficiency of database deployment is improved. And the process of applying for the database is automatically completed through the communication between the terminal equipment and the deployment device of the database, so that the efficiency of applying for the database is improved. In addition, in the embodiment, the processing of the database is set on the physical machine, and the storage of the database is set on the cloud storage resource, so that the calculation and the storage of the data are separately performed, and the storage efficiency of the data can be improved; in addition, a plurality of virtual machines can be created in the physical machine, and each virtual machine can support one service, so that the physical machine can support more service operations, and the utilization rate of the physical machine is further improved.
An embodiment of the present invention provides a method for deploying a database, which is mainly applicable to a scenario shown in fig. 1, where a method executed by a database deployment apparatus, such as the cloud platform, is provided, and a flowchart is shown in fig. 2, where the method includes:
It can be understood that the user may operate the terminal device, so that the terminal device logs in the deployment device of the database using the user identifier, and opens the service of deploying the database, so that the information that the user identifier corresponds to the user enjoys the service of deploying the database is stored in the deployment device of the database. After a user triggers a database deployment process through terminal equipment, a database deployment device sends an application form of the database to the terminal equipment, and the terminal equipment displays the application form on a user interface; after the user inputs the relevant information of the database to be applied to the user interface displayed by the terminal equipment, the terminal equipment sends the information input by the user to the deployment device of the database through the application request of the database.
The application form may include information that needs to be input by a user, and specifically may include the following information: user identification, type and size of the database, architecture type of the database, and user contact (e.g., mailbox, or telephone, or WeChat, etc.); other information such as the number of databases to be applied, the service module corresponding to each set of database, information of the machine room and the website where the database is located, and the like can also be included; further, the application form may further include user-customized information such as a communication address of the virtual machine bearing the database, a name of the physical machine where the virtual machine is located, and the like. Thus, after the terminal device displays the display application form on the user interface, the input interface of the information can be included in the user interface, and the user can input the corresponding information through the input interface.
The type of the database refers to the kind of the database that needs to be deployed, such as Oracle (Oracle) database, bellsai (Sybase) database, or the like. The architecture type of the database refers to a type of an overall architecture (including a physical architecture, a system architecture, and the like) for bearing the database, such as a standalone cloud database or a database of a oracle real-time application cluster (RAC), and the like.
A set of database corresponding to a business module may represent a business module to which data stored in the set of database belongs, such as an enterprise financial module, an enterprise employee module, and the like, and a set of database refers to a database carried by a virtual machine on a physical machine. Information of the machine room and the website where the database is located refers to information of a network where the entire framework of the database is located, for example, information of the machine room where the database is located, which is included in an application request sent by a Shenzhen A enterprise user through a terminal device, may be: SZA.
It should be noted that, after the deployment apparatus of the database performs step 101, the application request may be checked first, for example, whether a user corresponding to the terminal device that sends the application request is a valid user is checked, that is, whether information that the user corresponding to the user identifier included in the application request enjoys the service of deploying the database is stored in the deployment apparatus of the database is determined; whether current resources (including physical machines, cloud storage resources and the like) are enough to deploy a database and the like corresponding to the application request can be checked. If the audit is passed, the following steps 102 to 104 are performed, and if the audit is not passed, the flow ends.
And 102, selecting a physical machine according to the application request, and configuring first information of the virtual machine to be created in the physical machine, second information of the corresponding cloud storage module and third information of the corresponding database. Here, the virtual machine processes data based on the database, and the cloud storage module is used to access cloud storage resources for storing data processed by the virtual machine.
When the physical machine is selected by the deployment device of the database, the deployment device of the database may be selected according to the application request, if the number of sets of databases included in the application request received in step 101 is one set, one network device for computing may be randomly selected from network devices in communication connection with the deployment device of the database as the physical machine, or a network device whose remaining resources are greater than a preset value may be selected according to a certain policy as the physical machine. Alternatively, a physical machine communicatively coupled to the database deployment device may be redeployed.
If the application request received in step 101 includes a plurality of sets of databases, the database deployment device may select a plurality of physical machines and perform steps 102 to 105 for each physical machine.
Then, when configuring the first information, the second information, and the third information, the deployment apparatus of the database specifically:
(1) the first information of the deployment device configuration of the database may include the following information:
identification information, namely a name, of the virtual machine; creating a mirror image file of the virtual machine; initial values of first parameters related to the operation of the virtual machine, such as a memory allocator in the virtual machine, initial state values of some state machines, and the like; and second parameter information of the virtual disk operated by the virtual machine, such as a system storage area of the virtual disk of the virtual machine, a virtual disk recording format (such as a magnetic track and a sector), and the like, wherein the second parameter information is mainly used for facilitating the virtual machine to access and manage the virtual disk.
The deployment device of the database may configure the name of the virtual machine according to the application request and a certain rule, where the name may uniquely identify the virtual machine. For example, the name of the virtual machine may be "machine room" + "type of database" + "serial number-1", where the type of machine room and database is included in the application request, and the serial number may be a randomly generated serial number, for example, the name of the virtual machine created in the physical machine belonging to the machine room SZA may be: SZA Oracle sequence number-1.
(2) The second information of the deployment device configuration of the database may include the following information:
information of cloud storage resources; a cloud-stored library file; and an initial value of a third parameter related to the operation of the cloud storage module, for example, an initial value of a parameter related to an interface of the cloud storage module accessing the cloud storage resource.
For the information of the cloud storage resources and the cloud storage library file, the deployment device of the database may send an allocation request to the cloud storage management device in the cloud storage system, where the allocation request is used to request the cloud storage management device to allocate the cloud storage resources of the corresponding size, and the allocation request may include the size of the database in the application request; therefore, the cloud storage management equipment can allocate the cloud storage resources with corresponding sizes according to the size of the database in the allocation request, and return the information of the allocated cloud storage resources and the cloud storage library file to the deployment device of the database. The cloud storage management device is a device for managing each storage node in the cloud storage system.
The information of the cloud storage resource can be identification information, access position and other information of the cloud storage resource; the library file stored in the cloud may mainly include information such as interface information of the cloud storage module accessing the cloud storage resource. Here, the cloud storage resource may be a distributed storage resource in a network, specifically, a storage resource in a plurality of storage nodes (illustrated in fig. 1 by taking n storage nodes as an example).
(3) The third information of the deployment device configuration of the database may include the following information:
an initial value of a fourth parameter related to database operation, such as an initial value of a path for storing data, etc.; the fifth parameter information of the virtual disk mount database of the virtual machine, for example, information of which partition virtual disk uses the database, may specifically be information such as a mount directory.
For the initial value of the fourth parameter, the deployment apparatus of the database may call an initdb script, and configure the initial value of the fourth parameter through the initdb script. For the fifth parameter information, the deployment apparatus of the database may call an Automatic Storage Management (ASM) script, and configure the fifth parameter information through the ASM script.
And 103, sending the first information configured in the step 102 to the physical machine through a virtual machine creation request, so that the physical machine creates a virtual machine in the physical machine according to the first information.
Specifically, the deployment device of the database sends a virtual machine creation request to the physical machine, where the virtual machine creation request includes the configured first information; the physical machine creates a virtual machine in the physical machine according to the image file of the virtual machine created in the first information, names the created virtual machine as the name of the virtual machine in the first information, initializes the created virtual machine according to the initial value of the first parameter in the first information, and formats the virtual disk of the virtual machine according to the second parameter information in the first information; if the virtual machine is successfully created, the physical opportunity returns the information of successful creation to the deployment device of the database.
Specifically, when the physical machine creates a virtual machine, a virtual storage medium (such as a virtual disk) needs to be created in the physical machine, that is, a file is created in a permanent storage medium (such as a disk) of the physical machine, and the file may be named as the name of the virtual machine, and files required for running the virtual machine, such as the initial value of the first parameter, the second parameter information, and the like, are stored in the file.
It should be noted that multiple virtual machines may be created in one physical machine, specifically, if the application request received in step 101 includes a service module corresponding to a set of databases to be applied, if the service module includes multiple service modules, multiple virtual machines may be created in the physical machine, where each virtual machine corresponds to one service module; or only one virtual machine is created in the physical machine, and one virtual machine corresponds to a plurality of service modules.
When a plurality of virtual machines are created in a physical machine, all first information required for creating the plurality of virtual machines can be sent to the physical machine through a virtual machine creation request; or, first information required for creating the plurality of virtual machines is sent to the physical machine through a plurality of virtual machine creation requests respectively.
And step 104, sending the second information configured in the step 102 to the created virtual machine through a cloud storage module creation request, so that the virtual machine creates a corresponding cloud storage module according to the second information.
Specifically, the deployment device of the database sends a cloud storage module creation request to a virtual machine in the physical machine, where the cloud storage module creation request includes the configured second information; the virtual machine creates a corresponding cloud storage module according to the cloud storage library file and the cloud storage resource information in the second information, so as to access the corresponding cloud storage resource through the cloud storage library file; then the virtual machine initializes the created cloud storage module according to the initial value of the third parameter in the second information; if the cloud storage module is successfully created, the virtual machine returns the information of successful creation to the deployment device of the database.
And 105, sending the third information configured in the step 102 to a virtual machine in the physical machine through a database creation request, so that the virtual machine creates a corresponding database according to the third information.
Specifically, the deployment device of the database may send a database creation request to the virtual machine, where the database creation request includes the third information and the type of the database in the application request; the virtual machine creates a corresponding database according to the type of the database, mounts the database to a corresponding virtual disk according to fifth parameter information in the third information, and then initializes the created database according to the initial value of a fourth parameter in the third information; if the database is successfully created, the virtual machine returns the information of successful creation to the deployment device of the database.
Further, after the database is created in step 105, the database deployment apparatus may further store the status information of the created database, such as the name of the database, the usage condition of the database, the correspondence between the database and the virtual machine, and so on, so that the database deployment apparatus may manage the database corresponding to the virtual machine in the physical machine.
Further, if the application request received in step 101 includes a user identifier (such as a mailbox, a phone number, or a micro signal) of the user equipment, the database deployment apparatus may further send the communication address and the identification information (such as a name) of the virtual machine created in the physical machine to the user equipment corresponding to the user identifier of the user equipment, so as to deliver the created database to the user.
And when the user equipment receives the communication address and the identification information of the virtual machine, using the created database if necessary. And the terminal equipment to be expanded establishes communication connection with the virtual machine according to the communication address and the identification information of the virtual machine. Therefore, if the terminal device to be expanded needs to store data, the stored data can be sent to the virtual machine, then the virtual machine can generate the stored data into a file in a corresponding database format, and the cloud storage module sends the generated file to the cloud storage node for storage.
As can be seen, in this embodiment, an application request of a database may be initiated by a terminal device, then a deployment device of the database configures first information of a virtual machine, second information of a cloud storage module, and third information of the database, then the virtual machine is created in a physical machine according to the first information, the cloud storage module mounted by the virtual machine is created according to the second information, and finally a database is created in the virtual machine according to the third information and the application request. And the process of applying for the database is automatically completed through the communication between the terminal equipment and the deployment device of the database, so that the efficiency of applying for the database is improved. In addition, in the embodiment, the processing of the database is set on the physical machine, and the storage of the database is set on the cloud storage resource, so that the calculation and the storage of the data are separately performed, and the storage efficiency of the data can be improved; in addition, a plurality of virtual machines can be created in the physical machine, and each virtual machine can support one service, so that the physical machine can support more service operations, and the utilization rate of the physical machine is further improved.
It should be noted that, in a specific embodiment, if the application request received in step 101 further includes a communication address of the virtual machine bearing the database, such as an Internet Protocol (IP) address of the virtual machine, and a name of a physical machine where the virtual machine is located, which are personalized information for the user.
When the deployment device of the database creates the virtual machine in step 103, the physical machine will generate a default value of the communication address of the virtual machine, and the name of the selected physical machine also has a default value; after step 103 is executed, the deployment device of the database further needs to perform personalized configuration on the virtual machine and the corresponding physical machine according to the personalized information of the users included in the application request.
Specifically, the deployment device of the database calls a modified user data (userdata) interface, sends the communication address of the virtual machine in the application request to the virtual machine by modifying the userdata interface, and replaces the default value of the communication address of the virtual machine with the received communication address by the virtual machine; and sending the name of the physical machine in the application request to the physical machine, and replacing the default value of the name of the physical machine by the received name by the physical machine.
In another specific embodiment, after the step 101 is executed by the database deployment apparatus, it is required to check whether the image file stored locally (i.e. in the database deployment apparatus) includes the type of the database in the application request, and if so, execute the steps 102 to 105; if not, it indicates that the deployment apparatus of the database does not have the function of deploying the database of the type, and the flow ends.
In another specific embodiment, after the step 101 is executed by the database deployment device, if the application request further includes the architecture type of the database, it needs to first determine whether the architecture type of the database included in the application request is a stand-alone cloud database, and if so, the steps 102 to 105 are executed; if not, other database deployment processes, such as the database deployment process of RAC, need to be executed, which is not described herein again.
The method for deploying a database according to the embodiment of the present invention is described below with a specific embodiment, and the method according to the embodiment may be applied to a scenario shown in fig. 1, where a cloud platform is specifically a database deployment device. Referring to fig. 3, the method for deploying a database specifically includes:
Referring to fig. 4, the terminal device may include, in the application form displayed on the user interface: user name (namely user identification), type of database, architecture type of database, input interface of information such as mailbox or telephone (namely user identification of user equipment), namely input box of each information; the user interface may also include a send interface for such information, i.e., a "submit" button. Therefore, the user can input corresponding information from the input interfaces and click the submit button, the terminal equipment receives the information input by the user from the input interfaces and sends the information input by the user to the cloud platform through the application request of the database.
After the user interface, the input boxes of the type of the database and the architecture type of the database may further include a pull-down button of the two pieces of information, that is, a "reverse arrow" shown in fig. 4, when a user clicks a certain pull-down button, the terminal device may display a pull-down menu, and after the user may select one of the pieces of information in the pull-down menu, the terminal device may use the information selected by the user as the information input by the user.
For example, the user clicks a drop-down button behind the input box of "type of database" and selects "Oracle", the terminal device will use "Oracle" selected by the user as the type of database.
It should be noted that the application form on the user interface shown in fig. 4 is only a specific application example, and in other specific applications, the application form may also have other structures, which are not described herein again.
Further, the application form can also comprise the following input interfaces of information: the size of the database, the number of databases to be applied, the service module corresponding to each set of database, information such as a machine room and a website where the database is located, and user-customized information such as a communication address of a virtual machine bearing the database, a name of a physical machine where the virtual machine is located.
Specifically, the cloud platform may audit the user identifier (i.e., the user name shown in fig. 4) in the application request, audit whether the user identifier corresponds to the user is legal, and if the user identifier is legal, the audit is passed.
Specifically, if the number of sets of databases included in the request for application is one set, one physical machine is selected, and the following steps are performed. The first information may include a name of the virtual machine, specifically, the cloud platform may determine the name of the virtual machine according to the type of the database in the application request, for example, the name of the virtual machine created in the physical machine belonging to the machine room SZA may be: SZA Oracle sequence number-1.
In step 206, the cloud platform may perform personalized configuration on the created virtual machine according to the user personalized information in the application request.
Specifically, the cloud platform can call and modify a userdata interface, and send the communication address of the virtual machine to the created virtual machine through the userdata interface, so that the virtual machine replaces the default value of the communication address of the virtual machine with the received communication address; and may also send the name of the physical machine to the physical machine so that the physical machine replaces the default value of the name of the physical machine with the received name.
Specifically, the cloud platform may send an allocation request to the cloud storage management device, where the allocation request may include a size of the database, and the size of the database may be included in the application request.
Referring to fig. 5, after receiving the allocation request, the cloud storage management device allocates a cloud storage resource according to the allocation request by a Distributed Object storage (RADOS) module. The RADOS module may include a cloud storage resource management submodule; a Block storage (RBD) interface implemented based on a library file (i.e., librados file) of the RADOS, an object storage interface, and a file system interface; and a resource pool of cloud storage resources.
The cloud storage resource management submodule is configured to manage a correspondence between storage resources in a resource pool of the cloud storage resources and storage nodes, for example, information about which cloud storage resources belong to which storage node.
An object storage interface, namely a rados gateway (RADOSGW), for connecting each application client, where the application client can read data of each storage node through the object storage interface; the file system interface is a CephFS interface.
The resource pool of cloud storage resources is used to allocate and manage storage resources in the various storage nodes (e.g., storage nodes 1 through n).
Specifically, in this embodiment, the cloud storage resource pool included in the RADOS module in the cloud storage management device allocates cloud storage resources having a size corresponding to the size of the database; then, the cloud storage management device sends the information of the cloud storage resources and the library file (i.e., the block repository file, librbd file) of the cloud storage to the cloud platform, and the cloud platform also configures an initial value of a third parameter related to the operation of the cloud storage module.
In this way, the cloud platform sends the information of the cloud storage resources, the library file stored in the cloud and the initial value of the third parameter to the virtual machine through the cloud storage module creation request, and the virtual machine creates the corresponding cloud storage module. The created cloud storage module comprises the librbd file, information of cloud storage resources and the like.
And step 208, configuring third information corresponding to the database by the cloud platform, sending the third information and the type (such as Oracle) of the database to the created virtual machine through a database creation request, and creating the database by the virtual machine according to the third information and the type of the database.
Specifically, the cloud platform may call the initdb script to configure an initial value of a fourth parameter related to database operation, and the ASM script configures fifth parameter information of the virtual disk mount database of the virtual machine. The cloud platform may then send the initial value of the fourth parameter, the fifth parameter information, and the type of the database to the virtual machine through a database creation request. And creating a database of a corresponding type by the virtual machine, mounting the database to a corresponding virtual disk, and initializing the created database.
Further, after the database is created, the cloud platform may further store state information of the created database, such as a name of the database, a use condition of the database, and the like, so that the database corresponding to the virtual machine in the physical machine may be managed.
After the user equipment receives the communication address and the identification information of the virtual machine (i.e., the name of the virtual machine), if the cloud database of the single version needs to be extended on the enterprise equipment, the enterprise equipment is in communication connection with the corresponding virtual machine through the communication address and the identification information of the virtual machine, as shown in fig. 6.
And then, when the enterprise equipment needs to store data, the data to be stored can be sent to the virtual machine, the data to be stored is converted into a file in a corresponding database format by the virtual machine, and the converted file is stored to a corresponding storage node in the cloud storage system by a cloud storage module corresponding to the virtual machine. Specifically, the cloud storage module calls a block repository, i.e., a librbd file, and stores the converted file in a corresponding storage node through a block storage interface of the cloud storage management device.
An embodiment of the present invention further provides a deployment apparatus of a database, such as the cloud platform, where a schematic structural diagram of the deployment apparatus is shown in fig. 7, and the deployment apparatus specifically includes:
a request receiving unit 10, configured to receive an application request of a database sent by a terminal device, where the application request includes a type of the database;
an information configuration unit 11, configured to select a physical machine according to the application request received by the request receiving unit 10, and configure first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module, and third information of a corresponding database; the virtual machine processes data based on the database, and the cloud storage module is used for accessing cloud storage resources, and the cloud storage resources are used for storing the data processed by the virtual machine.
The first information specifically configured by the information configuration unit 11 may include: the virtual machine name and the mirror image file for creating the virtual machine are used for the physical machine to create the virtual machine according to the mirror image file and name the created virtual machine as the virtual machine name; the initial value of a first parameter related to the running of the virtual machine is used for initializing the created virtual machine by the physical machine according to the initial value of the first parameter; and the second parameter information of the virtual machine operation virtual disk is used for the physical machine to format the virtual disk of the created virtual machine according to the second parameter information.
If the application request received by the request receiving unit 10 further includes the size of the database, and the second information specifically configured by the information configuring unit 11, the allocation request may be sent to the cloud storage management device, where the allocation request includes the size of the database; receiving information of cloud storage resources and cloud storage library files returned by the storage management equipment according to the size of the database; the information of the cloud storage resources and the cloud storage library file are used for the virtual machine to create a cloud storage module so as to access the corresponding cloud storage resources through the cloud storage library file; and configuring an initial value of a third parameter related to the operation of the cloud storage module, and enabling the virtual machine to initialize the cloud storage module according to the initial value of the third parameter.
The third information specifically configured by the information configuration unit 11 may include: the initial value of a fourth parameter related to database operation is used for initializing the database by the virtual machine according to the initial value of the fourth parameter; and fifth parameter information of the virtual disk mount database of the virtual machine is used for the virtual machine to mount the database to the corresponding virtual disk according to the fifth parameter information.
A first creating unit 12, configured to send the first information configured by the information configuring unit 11 to the physical machine through a virtual machine creating request, so that the physical machine creates a virtual machine in the physical machine according to the first information.
A second creating unit 13, configured to send the second information configured by the information configuring unit 11 to the created virtual machine through a cloud storage module creating request, so that the virtual machine creates a corresponding cloud storage module according to the second information; and sending the configured third information and the type of the database in the application request received by the request receiving unit 10 to the virtual machine through a database creation request, so that the virtual machine creates a database according to the third information and the type of the database.
In this embodiment, an application request of a database may be initiated by a terminal device, then the information configuration unit 11 configures first information of a virtual machine, second information of a cloud storage module, and third information of the database, then the first creation unit 12 creates the virtual machine in a physical machine according to the first information, the second creation unit 13 creates the cloud storage module mounted by the virtual machine according to the second information, and finally creates a database in the virtual machine according to the third information and the application request. And the process of applying for the database is automatically completed through the communication between the terminal equipment and the deployment device of the database, so that the efficiency of applying for the database is improved. In addition, in the embodiment, the processing of the database is set on the physical machine, and the storage of the database is set on the cloud storage resource, so that the calculation and the storage of the data are separately performed, and the storage efficiency of the data can be improved; in addition, a plurality of virtual machines can be created in the physical machine, and each virtual machine can support one service, so that the physical machine can support more service operations, and the utilization rate of the physical machine is further improved.
Referring to fig. 8, in a specific embodiment, the database deployment apparatus may further include a viewing unit 14, a structure determining unit 15, a personalization unit 16, a storage unit 17, and an information delivery unit 18, in addition to the structure shown in fig. 7, wherein:
a checking unit 14, configured to check whether the locally stored image file includes the type of the database in the application request received by the request receiving unit 10, and if so, notify the information configuring unit 11 to configure the first information, the second information, and the third information.
A structure determining unit 15, configured to determine whether the architecture type of the database included in the application request is a standalone cloud database if the application request received by the request receiving unit 10 further includes the architecture type of the database, and if so, notify the information configuring unit 11 to configure the first information, the second information, and the third information.
A personalization unit 16, configured to send the communication address of the virtual machine to the virtual machine if the application request received by the request receiving unit 10 further includes the communication address of the virtual machine and the name of the physical machine, so that the virtual machine replaces a default value of the communication address of the virtual machine with the received communication address; and sending the name of the physical machine to the physical machine so that the physical machine replaces the default value of the name of the physical machine with the received name.
The storage unit 17 is configured to store the state information of the database created by the second creating unit 13 to the local, where the state information includes a corresponding relationship between the database and the virtual machine.
An information delivery unit 18, configured to send the communication address and the identification information of the virtual machine created by the first creating unit 12 to the user equipment corresponding to the user identifier if the application request received by the request receiving unit 10 further includes the user identifier of the user equipment.
Embodiments of the present invention further provide a server, such as the cloud platform, whose schematic structural diagram is shown in fig. 9, where the server may generate relatively large differences due to different configurations or performances, and may include one or more Central Processing Units (CPUs) 20 (e.g., one or more processors) and a memory 21, and one or more storage media 22 (e.g., one or more mass storage devices) storing the application programs 221 or the data 222. Wherein the memory 21 and the storage medium 22 may be a transient storage or a persistent storage. The program stored on the storage medium 22 may include one or more modules (not shown), each of which may include a series of instruction operations for the server. Still further, the central processor 20 may be configured to communicate with the storage medium 22 to execute a series of instruction operations in the storage medium 22 on the server.
Specifically, the application 221 stored in the storage medium 22 includes an application for deployment of a database, and the application may include the request receiving unit 10, the information configuring unit 11, the first creating unit 12, the second creating unit 13, the viewing unit 14, the structure determining unit 15, the personalizing unit 16, the storage unit 17, and the information delivering unit 18 in the deployment apparatus of the database, which will not be described herein again. Still further, the central processor 20 may be configured to communicate with the storage medium 22 to execute a series of operations on the server corresponding to the deployed application of the database stored in the storage medium 22.
The server may also include one or more power supplies 23, one or more wired or wireless network interfaces 24, one or more input-output interfaces 25, and/or one or more operating systems 223, such as Windows Server, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, and the like.
The steps performed by the database deployment apparatus in the above method embodiment may be based on the structure of the server shown in fig. 9.
The embodiment of the present invention further provides a storage device, where the storage device stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the database deployment method executed by the database deployment apparatus.
The embodiment of the invention also provides terminal equipment, which comprises a processor and storage equipment, wherein the processor is used for realizing each instruction;
the storage device is used for storing a plurality of instructions which are used for loading and executing the database deployment method executed by the database deployment device.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable storage medium, and the storage medium may include: read Only Memory (ROM), Random Access Memory (RAM), magnetic or optical disks, and the like.
The deployment method, the deployment device, and the storage device of the database provided by the embodiment of the present invention are described in detail above, and a specific example is applied in the description to explain the principle and the implementation of the present invention, and the description of the above embodiment is only used to help understanding the method and the core idea of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (15)
1. A method for deploying a database, comprising:
receiving an application request of a database sent by a terminal device, wherein the application request comprises the type of the database and the size of the database;
selecting a physical machine according to the application request, and configuring first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module and third information of a corresponding database; the virtual machine processes data based on the database, and the cloud storage module is used for accessing cloud storage resources which are used for storing the data processed by the virtual machine;
the configuring of the second information of the corresponding cloud storage module specifically includes: sending a distribution request to cloud storage management equipment in a cloud storage system, wherein the distribution request comprises the size of the database; receiving information of cloud storage resources and cloud storage library files returned by the cloud storage management equipment according to the size of the database; the information of the cloud storage resources and the cloud storage library file are used for the virtual machine to create a cloud storage module so as to access the corresponding cloud storage resources through the cloud storage library file; configuring an initial value of a third parameter related to the operation of the cloud storage module, and enabling the virtual machine to initialize the cloud storage module according to the initial value of the third parameter;
sending the configured first information to the physical machine through a virtual machine creation request so that the physical machine creates a virtual machine in the physical machine according to the first information;
sending the configured second information to the created virtual machine through a cloud storage module creation request so that the virtual machine can create a corresponding cloud storage module according to the second information;
and sending the configured third information and the type of the database to the virtual machine through a database creation request so that the virtual machine can create a database according to the third information and the type of the database.
2. The method of claim 1, wherein after receiving the request for application of the database sent by the terminal device, the method further comprises:
and checking whether the type of the database is included in the locally stored image file, and if so, executing the steps of configuring the first information, the second information and the third information.
3. The method according to claim 1 or 2, wherein the configuring of the first information of the virtual machine to be created in the physical machine specifically includes:
the virtual machine name and the mirror image file for creating the virtual machine are used for the physical machine to create the virtual machine according to the mirror image file and name the created virtual machine as the virtual machine name;
the initial value of a first parameter related to the running of the virtual machine is used for initializing the created virtual machine by the physical machine according to the initial value of the first parameter;
and the second parameter information of the virtual machine operation virtual disk is used for the physical machine to format the virtual disk of the created virtual machine according to the second parameter information.
4. The method according to claim 1 or 2, wherein the third information of the configured database specifically comprises:
the initial value of a fourth parameter related to database operation is used for initializing the database by the virtual machine according to the initial value of the fourth parameter;
and fifth parameter information of the virtual disk mount database of the virtual machine is used for the virtual machine to mount the database to the corresponding virtual disk according to the fifth parameter information.
5. The method of claim 1 or 2, wherein the application request further comprises: a communication address of the virtual machine, and a name of the physical machine;
after sending the configured first information to the physical machine so that the physical machine creates a virtual machine in the physical machine according to the first information, the method further includes:
sending the communication address of the virtual machine to the virtual machine so that the virtual machine replaces the default value of the communication address of the virtual machine with the received communication address;
and sending the name of the physical machine to the physical machine so that the physical machine replaces the default value of the name of the physical machine with the received name.
6. The method according to claim 1 or 2, wherein the application request further includes a user identifier of the user equipment, the method further comprising:
and sending the communication address and the identification information of the virtual machine to user equipment corresponding to the user identification.
7. The method of claim 1 or 2, wherein the method further comprises:
and storing the state information of the created database, wherein the state information comprises the corresponding relation between the database and the virtual machine.
8. An apparatus for deploying a database, comprising:
the device comprises a request receiving unit, a database processing unit and a database processing unit, wherein the request receiving unit is used for receiving an application request of a database sent by a terminal device, and the application request comprises the type of the database and the size of the database;
the information configuration unit is used for selecting a physical machine, configuring first information of a virtual machine to be created in the physical machine, second information of a corresponding cloud storage module and third information of a corresponding database; the cloud storage module is used for accessing cloud storage resources;
the information configuration unit is specifically configured to send an allocation request to a cloud storage management device in a cloud storage system, where the allocation request includes the size of the database; receiving information of cloud storage resources and cloud storage library files returned by the cloud storage management equipment according to the size of the database; the information of the cloud storage resources and the cloud storage library file are used for the virtual machine to create a cloud storage module so as to access the corresponding cloud storage resources through the cloud storage library file; configuring an initial value of a third parameter related to the operation of the cloud storage module, and enabling the virtual machine to initialize the cloud storage module according to the initial value of the third parameter;
a first creating unit, configured to send the configured first information to the physical machine through a virtual machine creating request, so that the physical machine creates a virtual machine in the physical machine according to the first information;
a second creating unit, configured to send the configured second information to the created virtual machine through a cloud storage module creating request, so that the virtual machine creates a corresponding cloud storage module according to the second information; and sending the configured third information and the type of the database to the virtual machine through a database creation request so that the virtual machine can create a database according to the third information and the type of the database.
9. The apparatus of claim 8, further comprising:
and the viewing unit is used for viewing whether the type of the database is included in the locally stored mirror image file, and if so, informing the information configuration unit to configure the first information, the second information and the third information.
10. The apparatus of claim 8 or 9,
the application request received by the request receiving unit further includes a communication address of the virtual machine and a name of the physical machine; the apparatus further comprises:
the personalization unit is used for sending the communication address of the virtual machine to the virtual machine so that the virtual machine can replace the default value of the communication address of the virtual machine with the received communication address; and sending the name of the physical machine to the physical machine so that the physical machine replaces the default value of the name of the physical machine with the received name.
11. The apparatus of claim 8 or 9,
the application request received by the request receiving unit further includes a user identifier of the user equipment, and then the apparatus further includes:
and the information delivery unit is used for sending the communication address and the identification information of the virtual machine to the user equipment corresponding to the user identification.
12. The apparatus of claim 8 or 9, further comprising:
and the storage unit is used for storing the state information of the created database, and the state information comprises the corresponding relation between the database and the virtual machine.
13. A storage device storing a plurality of instructions adapted to be loaded by a processor and to perform the method of deploying a database according to any one of claims 1 to 7.
14. A terminal device, comprising a processor and a storage device, wherein the processor is configured to implement instructions;
the storage device is used for storing a plurality of instructions which are used for loading and executing the deployment method of the database according to any one of claims 1 to 7 by a processor.
15. A computer-readable storage medium, characterized in that it stores a plurality of computer programs adapted to be loaded by a processor and to execute the method of deployment of a database according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711191088.XA CN109840094B (en) | 2017-11-24 | 2017-11-24 | Database deployment method and device and storage equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711191088.XA CN109840094B (en) | 2017-11-24 | 2017-11-24 | Database deployment method and device and storage equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109840094A CN109840094A (en) | 2019-06-04 |
| CN109840094B true CN109840094B (en) | 2021-08-31 |
Family
ID=66876153
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711191088.XA Active CN109840094B (en) | 2017-11-24 | 2017-11-24 | Database deployment method and device and storage equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109840094B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111400046B (en) * | 2020-03-16 | 2024-02-27 | 广州虎牙科技有限公司 | Database resource management method, device, resource management equipment and storage medium |
| CN113590271A (en) * | 2021-09-27 | 2021-11-02 | 武汉四通信息服务有限公司 | Database deployment method and device, electronic equipment and storage medium |
| CN114329563A (en) * | 2021-12-30 | 2022-04-12 | 北京人大金仓信息技术股份有限公司 | Database processing method, device, equipment and medium |
| CN117909023A (en) * | 2023-12-19 | 2024-04-19 | 曙光云计算集团股份有限公司 | Cloud platform deployment method and device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110009A (en) * | 2009-12-28 | 2011-06-29 | 中国移动通信集团公司 | Method for deploying application in virtual platform and virtual platform manager |
| CN103716347A (en) * | 2012-09-29 | 2014-04-09 | 国际商业机器公司 | Virtual machine creating method, virtual machine creating device and cloud server |
| CN104657200A (en) * | 2015-03-03 | 2015-05-27 | 浪潮电子信息产业股份有限公司 | Method for creating shared disk in virtual machine |
| CN106776998A (en) * | 2016-12-06 | 2017-05-31 | 华为技术有限公司 | A kind of database service provides method and server |
| CN106899518A (en) * | 2017-02-27 | 2017-06-27 | 腾讯科技（深圳）有限公司 | A kind of method for processing resource and device based on Internet data center |
-
2017
- 2017-11-24 CN CN201711191088.XA patent/CN109840094B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110009A (en) * | 2009-12-28 | 2011-06-29 | 中国移动通信集团公司 | Method for deploying application in virtual platform and virtual platform manager |
| CN103716347A (en) * | 2012-09-29 | 2014-04-09 | 国际商业机器公司 | Virtual machine creating method, virtual machine creating device and cloud server |
| CN104657200A (en) * | 2015-03-03 | 2015-05-27 | 浪潮电子信息产业股份有限公司 | Method for creating shared disk in virtual machine |
| CN106776998A (en) * | 2016-12-06 | 2017-05-31 | 华为技术有限公司 | A kind of database service provides method and server |
| CN106899518A (en) * | 2017-02-27 | 2017-06-27 | 腾讯科技（深圳）有限公司 | A kind of method for processing resource and device based on Internet data center |
Non-Patent Citations (1)
| Title |
|---|
| "Oracle 12cR1 RAC 在VMware Workstation上安装(上)—OS环境配置";^_^小麦苗^_^;《https://www.cnblogs.com/lhrbest/p/6337496.html》;20170121;第1-33 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109840094A (en) | 2019-06-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108809722B (en) | Method, device and storage medium for deploying Kubernetes cluster | |
| CN109547570B (en) | Service registration method, device, registration center management equipment and storage medium | |
| CN109840094B (en) | Database deployment method and device and storage equipment | |
| CN113296792B (en) | Storage method, device, equipment, storage medium and system | |
| CN113783922A (en) | Load balancing method, system and device | |
| CN105897946A (en) | Obtaining method and system of access address | |
| US9942087B2 (en) | Application resiliency using APIs | |
| US20170140315A1 (en) | Managing incident tickets in a cloud managed service environment | |
| CN114244717B (en) | Configuration method and device of virtual network card resources, computer equipment and medium | |
| US11652725B2 (en) | Performance testing of a test application in a network-as-a-service environment | |
| CN111045802B (en) | Redis cluster component scheduling system and method and platform equipment | |
| CN113626286A (en) | Multi-cluster instance processing method and device, electronic equipment and storage medium | |
| CN109618003B (en) | Server planning method, server and storage medium | |
| CN115428514A (en) | Sharing geographically focused workloads between adjacent MEC hosts of multiple operators | |
| CN105095103A (en) | Storage device management method and device used for cloud environment | |
| CN112114939A (en) | Distributed system deployment equipment and method | |
| US20160092206A1 (en) | Managing executable files | |
| CN114706690A (en) | Method and system for sharing GPU (graphics processing Unit) by Kubernetes container | |
| US10176059B2 (en) | Managing server processes with proxy files | |
| CN106550002B (en) | paas cloud hosting system and method | |
| CN114629958B (en) | Resource allocation method, device, electronic equipment and storage medium | |
| US20180123999A1 (en) | Tracking client location using buckets | |
| US10223463B2 (en) | Node controllers for hierarchical data structures | |
| CN115225645A (en) | Service updating method, device, system and storage medium | |
| CN113760446A (en) | Resource scheduling method, device, equipment and medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230920 Address after: 100086 Beijing Haidian District Zhichun Road 49 No. 3 West 309 Patentee after: TENCENT CLOUD COMPUTING (BEIJING) Co.,Ltd. Address before: 518057 Tencent Building, No. 1 High-tech Zone, Nanshan District, Shenzhen City, Guangdong Province, 35 floors Patentee before: TENCENT TECHNOLOGY (SHENZHEN) Co.,Ltd. |