CN107666493B

CN107666493B - Database configuration method and equipment thereof

Info

Publication number: CN107666493B
Application number: CN201610598779.0A
Authority: CN
Inventors: 朱虹; 莫衍; 李小宁; 罗冬水; 余伯平; 许钺; 吴晓清; 胡林红
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Cloud Computing Beijing Co Ltd
Priority date: 2016-07-27
Filing date: 2016-07-27
Publication date: 2020-08-14
Anticipated expiration: 2036-07-27
Also published as: CN107666493A

Abstract

The embodiment of the invention discloses a database configuration method and a device thereof, wherein the method comprises the following steps: acquiring database creating condition information of a submitted service database for writing data into a target service; creating a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creation condition information, and configuring cloud storage resources for the virtual machine; initializing the virtual machine and cloud storage resources of the virtual machine, and performing domain access processing of a public network logic domain on the virtual machine; and configuring the database of the virtual machine after the domain entry processing, and connecting the database of the virtual machine and the cloud storage resource. By adopting the invention, the automatic configuration of the database can be realized, the number of the service databases borne by the server is increased, the utilization rate of the server is improved, and the cost of human resources, hardware resources and the like is effectively reduced.

Description

Database configuration method and equipment thereof

Technical Field

The invention relates to the technical field of internet, in particular to a database configuration method and a device thereof.

Background

With the continuous development and improvement of internet technology, the storage requirement of service data in a network can be met by configuring a database in a service server, the existing database is generally configured manually, meanwhile, the service data is stored by depending on the hard disk storage space of the service server, along with the increase of services, the number of the service servers needs to be correspondingly increased, the cost increase of human resources, hardware resources and the like is caused, and the utilization rate of the service server is reduced.

Disclosure of Invention

The embodiment of the invention provides a database configuration method and equipment thereof, which can realize automatic configuration of a database, increase the number of service databases borne by a server, improve the utilization rate of the server, and effectively reduce the costs of human resources, hardware resources and the like.

A first aspect of an embodiment of the present invention provides a database configuration method, which may include:

acquiring database creating condition information of a submitted service database for writing data into a target service;

creating a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creation condition information, and configuring cloud storage resources for the virtual machine;

initializing the virtual machine and cloud storage resources of the virtual machine, and performing domain access processing of a public network logic domain on the virtual machine;

and configuring the database of the virtual machine after the domain entry processing, and connecting the database of the virtual machine and the cloud storage resource.

A second aspect of an embodiment of the present invention provides a database configuration device, which may include:

the information acquisition unit is used for acquiring database creation condition information of a submitted service database for writing data into the target service;

the resource configuration unit is used for creating a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creation condition information and configuring cloud storage resources for the virtual machine;

the virtual machine initialization unit is used for initializing the virtual machine and cloud storage resources of the virtual machine and performing domain access processing of a public network logical domain on the virtual machine;

and the database configuration unit is used for configuring the database of the virtual machine after the domain entry processing, and connecting the database of the virtual machine and the cloud storage resource.

In the embodiment of the invention, the database creating condition information of the service database of the target service is acquired, the virtual machine corresponding to the target service is created in the target server under the cloud platform according to the database creating condition information, the cloud storage resources are configured for the virtual machine, the virtual machine and the cloud storage resources of the virtual machine are initialized, the virtual machine is subjected to domain entry processing of a public network logic domain, the database of the virtual machine is configured after the domain entry processing, and the database of the virtual machine and the cloud storage resources are finally connected. According to the acquired database creation condition information, the creation of the virtual machine and the configuration of the database are completed in the target server, the automatic configuration process of the database is realized, and meanwhile, the number of the service databases which can be borne by the server is increased by adopting the virtual machine and a cloud storage mode, so that the utilization rate of the server is improved, and the costs of human resources, hardware resources and the like are effectively reduced.

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, 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 the drawings without creative efforts.

Fig. 1 is a schematic flowchart of a database configuration method according to an embodiment of the present invention;

FIG. 2 is a flow chart illustrating another database configuration method according to an embodiment of the present invention;

FIG. 3 is a schematic diagram illustrating an example of a database configuration according to an embodiment of the present invention;

FIG. 4 is a flow chart illustrating a further database configuration method according to an embodiment of the present invention;

fig. 5 is a schematic structural diagram of a database configuration device according to an embodiment of the present invention;

fig. 6 is a schematic structural diagram of a resource allocation unit according to an embodiment of the present invention;

fig. 7 is a schematic structural diagram of a virtual machine initialization unit according to an embodiment of the present invention;

FIG. 8 is a schematic structural diagram of a database configuration unit according to an embodiment of the present invention;

FIG. 9 is a schematic structural diagram of another database configuration device according to an embodiment of the present invention;

fig. 10 is a schematic structural diagram of another database configuration device 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 database configuration method provided by the embodiment of the invention can be applied to the scene of configuring the database for each service in the server under the cloud platform, for example: the method comprises the steps that database configuration equipment obtains database creating condition information of a submitted service database for writing data of a target service into the service database, the database configuration equipment creates a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creating condition information and configures cloud storage resources for the virtual machine, the database configuration equipment initializes the virtual machine and the cloud storage resources of the virtual machine and performs domain entry processing of a public network logic domain for the virtual machine, the database configuration equipment configures a database of the virtual machine after the domain entry processing, and the scene of connecting the database of the virtual machine and the cloud storage resources is formed. According to the acquired database creation condition information, the creation of the virtual machine and the configuration of the database are completed in the target server, the automatic configuration process of the database is realized, and meanwhile, the number of the service databases which can be borne by the server is increased by adopting the virtual machine and a cloud storage mode, so that the utilization rate of the server is improved, and the costs of human resources, hardware resources and the like are effectively reduced.

The database configuration equipment related to the embodiment of the invention can be background service equipment for monitoring and managing the server under the cloud platform; the cloud platform may be used to provide the necessary underlying Internet Technology (IT) infrastructure services for computing resources, storage resources, network resources, and the like.

The database configuration method provided by the embodiment of the invention will be described in detail below with reference to fig. 1 to 4.

Referring to fig. 1, a flow chart of a database configuration method according to an embodiment of the present invention is shown. As shown in fig. 1, the method of an embodiment of the present invention may include the following steps S101-S104.

S101, obtaining database creating condition information of a submitted service database for writing data into a target service;

specifically, the database configuration device may obtain database creation condition information of a service database, which is submitted by a user and used for writing data into a target service, where the target service is a network service that needs to configure the service database to write and store service data into the service database, for example: game, special web page, etc., where the service data is data generated by the target service when the terminal runs, and may be data generated for personal operation, or may be data generated for a service framework of the current target service, for example: the database creation condition information may be related information created by a database inputted by a developer of the target service according to a requirement of the target service, such as: the service database configuration method includes the steps of obtaining a database type, database configuration demand information and the like, wherein the database configuration demand information can be used for representing whether a currently configured service database needs to be high-availability demand information or not, and preferably, the database configuration equipment can output a database configuration interface for a developer to select.

S102, creating a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creation condition information, and configuring cloud storage resources for the virtual machine;

specifically, the database configuration device may create, according to the database creation condition information, a virtual machine corresponding to the target service in a target server under a cloud platform, and configure a cloud storage resource for the virtual machine, and further, the database configuration device may determine whether a database type selected in the database creation condition information is a preset database type, for example: whether the mirror name is the SQL Server or not can be judged, whether the mirror name contains 2012 characters or not is judged, namely whether the type of the selected database is the SQL Server 2012 or not is judged, and whether the configuration requirement information of the database indicates high availability requirement information or not is judged.

The database configuration device may determine, in a server cluster based on a machine room identifier selected by a cloud platform, a target server in a polling manner according to an arrangement order of network address information of each server in the server cluster, create a virtual machine corresponding to the target service in the target server, and configure a cloud storage resource for the virtual machine. It can be understood that a machine room identifier is set for the machine room where each server is located, so as to accurately locate the area where the current server is located, the database creation condition information may further include a machine room identifier selected by a developer, preferably, the database configuration device may further name the virtual machine, and each server under the selected machine room identifier is preset with network address information, for example: internet Protocol (IP) addresses, etc., and the database configuration device may search a first available server in each server according to the arrangement order of the network address information and in a polling manner, for example: the method includes the steps of determining a first available server as a target server, creating a virtual machine corresponding to a target service in the target server, setting network address information of a public network logic domain for the virtual machine, and configuring cloud storage resources for the virtual machine, wherein the public network logic domain can be represented as an external network, an external terminal bearing the target service can be connected with the virtual machine through the external network, the cloud storage resources are storage resources of storage nodes selected from a cloud storage resource pool, and the storage nodes can include a plurality of OSD.

S103, initializing the virtual machine and cloud storage resources of the virtual machine, and performing domain access processing of a public network logic domain on the virtual machine;

specifically, the database configuration device may perform initialization processing on the virtual machine and cloud storage resources of the virtual machine, the process of the initialization processing on the virtual machine may include naming the virtual machine, binding network address information of a public network logic domain of the virtual machine, initializing a disk, and the like, the process of the initialization processing on the cloud storage resources may include disk scanning, disk activation, disk formatting, setting a use disk identifier, and the like, and the database configuration device may further perform domain entry processing on the virtual machine after performing initialization processing on the virtual machine and cloud storage resources of the virtual machine.

S104, configuring the database of the virtual machine after domain entry processing, and connecting the database of the virtual machine and cloud storage resources;

specifically, after the domain entering processing of the public network logical domain is performed on the virtual machine, the database configuration device may further configure the database of the virtual machine, and connect the database of the virtual machine and the cloud storage resource.

It should be noted that the database input by the developer for the requirements of the current business creates condition information, such as: database types, database configuration requirement information, and the like, according to different database creation condition information, two database modes can be provided, namely "resident availability group creation" and "stand-alone creation", and the details of the two database modes of "resident availability group creation" and "stand-alone creation" will be described in detail below with reference to fig. 2 to 4.

Referring to fig. 2, a schematic flow chart of another database configuration method according to an embodiment of the present invention is provided. As shown in fig. 2, the method of the embodiment of the present invention is used for setting up the configuration process of the database schema of "resident availability group creation", and the method may include the following steps S201 to S207.

S201, obtaining database creating condition information of a submitted service database for writing data into a target service;

S202, when the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, creating a first service virtual machine and a second service virtual machine corresponding to the target service in a server cluster under a cloud platform, and respectively configuring cloud storage resources for the first service virtual machine and the second service virtual machine;

specifically, the database configuration device may determine whether the database type selected in the database creation condition information is a preset database type, for example: whether the mirror name is the SQLServer or not can be judged, whether the mirror name contains 2012 characters or not is judged, that is, whether the selected database type is the SQL Server 2012 or not is judged, and whether the database configuration requirement information indicates high availability requirement information or not is judged.

When the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, the database configuration device may configure a database mode of "resident availability group creation", where the database mode of the resident availability group creation may be understood as creating a failover cluster of three virtual machines, where two service virtual machines may each carry a service database and may synchronize service data, and the other virtual machine is an arbitration virtual machine for determining, together with any one service virtual machine, a service virtual machine in the failover cluster that has a failure, and when one service virtual machine has a failure, it may be determined that the service virtual machine that currently actually carries a service has a failure by real-time monitoring of the arbitration virtual machine and the other service virtual machine, and a target service may point to the service database of the other service virtual machine, and continuing to provide service for the target service. Preferably, the database configuration device may create a first service virtual machine, a second service virtual machine, and an arbitration virtual machine corresponding to the target service in a server cluster under a cloud platform, and configure cloud storage resources for the first service virtual machine and the second service virtual machine, respectively. Further, the database configuration device determines a first server in a polling manner according to an arrangement sequence of network address information of each server in a server cluster under a machine room identifier selected by a cloud platform, and creates a first service virtual machine corresponding to the target service in the first server, where it is understood that a machine room identifier is set for a machine room in which each server is located, so as to accurately locate an area in which a current server is located, the database creation condition information may further include a machine room identifier selected by a developer, network address information is preset for each server under the selected machine room identifier, the network address information of each server may be network address information of a private network logical domain or a public network logical domain, and the public network logical domain may be represented as an external network, the external terminal bearing the service may be connected to the servers through the external network, the private network logical domain is an internal local area network, the servers may perform internal communication through the local area network, the network address information is preferably an IP address, and the database configuration device may search a first available server in each server according to an arrangement sequence of the network address information and in a polling manner, for example: preferably, the database configuration device may further name the first service virtual machine, and a naming rule may be: the method includes the steps that a machine room identifier + MSSQL + 6-bit random serial number-1 is obtained, cloud Storage resources are configured for the first service virtual machine, the cloud Storage resources are Storage resources of Storage nodes selected from a cloud Storage resource pool, and the Storage nodes can include a plurality of provided Storage resources (OSD). The database configuration device determines, in a first remaining server of the server cluster except the first server, a second server in a polling manner according to an arrangement order of network address information of each server in the first remaining server, creates a second service virtual machine corresponding to the target service in the second server, and configures a cloud storage resource for the second service virtual machine, and may also name the second service virtual machine, where a naming rule may be: the method includes the steps that a machine room identifier + MSSQL + 6-bit random serial number-2 is adopted, similarly, the database configuration equipment determines a third server in a second remaining server of the server cluster except the first server and the second server in a polling mode according to the arrangement sequence of network address information of all servers in the second remaining server, and an arbitration virtual machine corresponding to the target service is created in the third server.

It can be understood that the determining of the second server, the creating of the second service virtual machine, and the configuring of the cloud storage resource of the second service virtual machine may be the same as the determining of the first server, the creating of the first service virtual machine, and the configuring of the cloud storage resource of the first service virtual machine, and it should be noted that the cloud storage resource configured by the first service virtual machine and the cloud storage resource configured by the second service virtual machine need to be located in different storage nodes. The determination of the third server and the creation of the arbitration virtual machine may be the same as the above-described determination of the first server and the creation of the first traffic virtual machine, it being understood that since the arbitration handler is not involved in traffic bearers, it may be preferable to use the lowest configuration for the arbitration handler.

The database configuration device may set network address information of a private network logical domain for each of the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, where the network address information of the private network logical domain of any one of the first service virtual machine, the second service virtual machine, and the arbitration virtual machine is set according to a physical machine identifier of a server to which the any one virtual machine belongs, and it can be understood that a manager of the server may set a physical machine identifier for each server, for example: the database configuration device can respectively apply for the network address information of the private network logic domain of the first service virtual machine, the second service virtual machine and the arbitration virtual machine in a network address information pool according to the physical machine identifier of the server and the private network logic domain where the server is located.

In order to better ensure the high availability characteristic, the database configuration device may determine a second server among the remaining servers of the server cluster except for all servers of the rack in which the first server is located, a third server may be determined among the remaining servers of the server cluster except for all servers of the rack in which the first server is located and all servers of the rack in which the second server is located, namely, the first server, the second server and the third server are respectively positioned on different racks of the same machine room, by selecting servers of different racks of the same machine room to create the database and build the arbitration virtual machine, the failure of the server at the rack level can be avoided on the basis of reducing the time delay, and the characteristic of high availability is effectively ensured, and certainly, for the service data with low real-time performance, the servers of different machine rooms can be adopted to establish the database and the arbitration virtual machine.

S203, initializing the first service virtual machine, the second service virtual machine, the arbitration virtual machine, the cloud storage resource of the first service virtual machine and the cloud storage resource of the second service virtual machine;

specifically, the database configuration device may respectively perform initialization processing on the first service virtual machine, the second service virtual machine, cloud storage resources of the first service virtual machine, and cloud storage resources of the second service virtual machine when it is monitored that the first service virtual machine and the second service virtual machine are switched from a creation state to an operation state, where the initialization processing on the virtual machines may include naming the virtual machines, binding network address information of the virtual machines, initializing disks, and the like, and the initialization processing on the cloud storage resources may include disk scanning, disk activation, disk formatting, setting a use disk identifier, and the like.

S204, after initialization processing, according to the network address information of the public network logic domain respectively configured for the first service virtual machine, the second service virtual machine and the arbitration virtual machine in advance, performing domain access processing of the public network logic domain on the first service virtual machine, the second service virtual machine and the arbitration virtual machine;

specifically, the database configuration device may initialize the first service virtual machine, the second service virtual machine, the cloud storage resource of the first service virtual machine, and the cloud storage resource of the second service virtual machine, and wait for the network card configuration of the private network logical domain to be completed, according to the network address information of the public network logic domain which is respectively configured for the first service virtual machine, the second service virtual machine and the arbitration virtual machine in advance, performing domain entry processing of the public network logical domain on the first service virtual machine, the second service virtual machine and the arbitration virtual machine, it can be understood that the network address information of the public network logical domain respectively configured by the first service virtual machine, the second service virtual machine, and the arbitration virtual machine is respectively applied in the network address information pool after the database configuration device is created in each virtual machine.

S205, after domain entry processing, configuring a database of the first service virtual machine and a database of the second service virtual machine, connecting the database of the first service virtual machine and cloud storage resources, and connecting the database of the second service virtual machine and cloud storage resources;

specifically, the database configuration device may configure the database of the first service virtual machine and the database of the second service virtual machine, connecting the database and cloud storage resources of the first business virtual machine, and connecting the database and cloud storage resources of the second business virtual machine, it is to be understood that the database configuration device may configure a primary replica and a secondary replica, the primary replica being used to carry the database of the first service virtual machine, the auxiliary copy has read-write function, the auxiliary copy is used for bearing a database of a second service virtual machine and is used as a potential fault transfer target, the auxiliary copy can be a read-only copy, when a user inquires a target service, corresponding business data can be read through the auxiliary copy, and reasonable application of hardware resources is facilitated by adopting a database cluster and mirror database read-write separation mode.

S206, configuring virtual network address information of failover for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, and configuring virtual network address information of the target service for the first service virtual machine and the second service virtual machine;

specifically, the database configuration device may configure virtual network address information of failover for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, and configure virtual network address information of the target service for the first service virtual machine and the second service virtual machine, it may be understood that the virtual network address information of failover and the virtual network address information of the target service may be a common network address applied in a network address information pool by the database configuration device after each virtual machine is created, and preferably, the virtual network address information of failover and the virtual network address of the target service may be applied according to a physical machine identifier of the first server to which the first service virtual machine belongs and a public network logical domain to which the first server belongs, the virtual network address information of the failover is used for representing the network address of the failover cluster formed by the first service virtual machine, the second service virtual machine and the arbitration virtual machine, that is, the running states of the database of the first service virtual machine and the database of the second service virtual machine can be monitored in real time or at regular time among the three virtual machines according to the virtual network address information of the failover, and the network address information of the private network logic domain of each virtual machine is taken as the heartbeat network address information. The virtual network address information of the target service is used for representing a network address of data writing of the target service, namely, an external terminal bearing the target service can upload the service data of the target service to a database of a first service virtual machine or a database of a second service virtual machine by configuring the virtual network address information of the target service, and the network address of the actual public network logic domain of the first service virtual machine or the network address of the actual public network logic domain of the second service virtual machine does not need to be acquired, so that the network address pointing of the external terminal when the service data is written is prevented from being modified in batch when one virtual machine fails, and the data writing efficiency of the target service is improved.

S207, recording the creation state of the virtual machine, the configuration state of the cloud storage resource and the configuration state of the database of the virtual machine by adopting a preset monitoring script;

specifically, the database configuration device may further preset a monitoring script when acquiring the database creation condition information, the monitoring script is used for recording the creating state of the first service virtual machine, the creating state of the second service virtual machine, the creating state of the arbitration virtual machine, the configuration state of the cloud storage resource and the configuration state of the database, when any one of the creation of the first service virtual machine, the creation of the second service virtual machine, the creation state of the arbitration virtual machine, the configuration of the cloud storage resource and the configuration of the database is abnormal, so that the configuration of the database fails, the monitoring script can generate an error log and trigger a rollback operation, when the database configuration is successful, the listening script may generate notification information of the successful database configuration, and the notification information is preferably a pre-agreed script status value (e.g., 200, etc.).

Referring to fig. 3 together, an exemplary diagram of a database configuration is provided for a database schema of "resident availability group creation". As shown in fig. 3, a first server, a second server and a third server are determined by a polling method, a first service virtual machine is created under a first host in the first server, and simultaneously a cloud storage resource is mounted, a second service virtual machine is created under a second host in the second server, an arbitration virtual machine is created under a third host in the third server, and simultaneously a cloud storage resource is respectively mounted on the first service virtual machine and the second service virtual machine, the cloud storage resource is connected to a storage node in a cloud storage resource pool, the storage node includes a plurality of OSDs for subsequently storing service data in a service database DB1, as can be seen from fig. 3, the service database configured in the first service virtual machine and the service database configured in the second service virtual machine are both 1, and the service databases represented as both DB are synchronous databases for a target service, meanwhile, the first service virtual machine, the second service virtual machine and the arbitration virtual machine can monitor each other in real time or at regular time to detect whether database faults exist, so that a database mode of 'resident availability group creation' is realized.

In the embodiment of the present invention, database creation condition information of a service database of a target service is acquired, a virtual machine corresponding to the target service is created in a target server under a cloud platform according to the database creation condition information, a cloud storage resource is configured for the virtual machine, initialization processing is performed on the virtual machine and the cloud storage resource of the virtual machine, domain entry processing of a public network logical domain is performed on the virtual machine, the database of the virtual machine is configured after the domain entry processing, and finally the database of the virtual machine and the cloud storage resource are connected. The establishment of the virtual machine and the configuration of the database are completed in the target server according to the acquired database establishment condition information, so that the automatic configuration process of the database is realized, and meanwhile, the number of service databases which can be borne by the server is increased by adopting a virtual machine and cloud storage mode, the utilization rate of the server is improved, and the costs of human resources, hardware resources and the like are effectively reduced; the deployment of a high-availability architecture is realized by configuring a database mode of 'resident availability group creation'; by selecting servers of different racks in the same computer room to establish a database and constructing an arbitration virtual machine, the fault of the servers at the rack level can be avoided on the basis of reducing time delay, and the characteristic of high availability is effectively ensured.

Referring to fig. 4, a schematic flow chart of another database configuration method according to an embodiment of the present invention is provided. As shown in fig. 4, the method of the embodiment of the present invention is used for illustrating the configuration process of the database schema of "stand-alone creation", and the method may include the following steps S301 to S305.

S301, acquiring database creation condition information of a submitted service database for writing data into a target service;

S302, when the selected database type is a preset database type and the database configuration demand information indicates that the database configuration demand information is not high-availability demand information, determining a target server in a server cluster based on a machine room identifier selected by a cloud platform in a polling mode according to the arrangement sequence of network address information of each server in the server cluster, creating a virtual machine corresponding to the target service in the target server, and configuring cloud storage resources for the virtual machine;

When the selected database type is a preset database type and the database configuration demand information indicates that the database configuration demand information is not high available demand information, the database configuration device can configure a database mode of 'stand-alone creation', and the database mode of the single click creation can be understood as a single virtual machine bearing service database. Preferably, the database configuration device may determine, in a server cluster under a machine room identifier selected based on a cloud platform, a target server in a polling manner according to an arrangement order of network address information of each server in the server cluster, create a virtual machine corresponding to the target service in the target server, and configure a cloud storage resource for the virtual machine. It can be understood that a machine room identifier is set for the machine room in which each server is located, so as to accurately locate the area in which the current server is located, the database creation condition information may further include the machine room identifier selected by the developer, preferably, the database configuration device may further name the virtual machine, and the naming rule may be: machine room identification + MSSQL + 6-bit random serial number-0, and each server under the selected machine room identification is preset with network address information, such as: IP addresses, etc., and the database configuration device may find a first available server in each server according to the arrangement order of the network address information and in a polling manner, for example: the method includes the steps of determining a first available server as a target server, creating a virtual machine corresponding to a target service in the target server, setting network address information of a public network logic domain for the virtual machine, and configuring cloud storage resources for the virtual machine, wherein the public network logic domain can be represented as an external network, an external terminal bearing the target service can be connected with the virtual machine through the external network, the cloud storage resources are storage resources of storage nodes selected from a cloud storage resource pool, and the storage nodes can include a plurality of OSD.

S303, initializing the virtual machine and cloud storage resources of the virtual machine, and performing domain access processing of a public network logic domain on the virtual machine;

S304, configuring the database of the virtual machine after domain entry processing, and connecting the database of the virtual machine and cloud storage resources;

S305, recording the creation state of the virtual machine, the configuration state of the cloud storage resource and the configuration state of a database of the virtual machine by adopting a preset monitoring script;

specifically, the database configuration device may further preset a monitoring script when acquiring the database creation condition information, where the monitoring script is configured to record a creation state of the virtual machine, a configuration state of the cloud storage resource, and a configuration state of the database of the virtual machine, and when any one of the creation of the virtual machine, the configuration of the cloud storage resource, and the configuration of the database of the virtual machine is abnormal and causes a failure in database configuration, the monitoring script may generate an error log and trigger a rollback operation, and when the database configuration is successful, the monitoring script may generate notification information that the database configuration is successful, where the notification information is preferably a predetermined script state value (e.g., 200).

The database configuration device provided by the embodiment of the invention will be described in detail with reference to fig. 5 to 9. It should be noted that, the database configuration apparatus shown in fig. 5-9 is used for executing the method of the embodiment shown in fig. 1-4 of the present invention, and for convenience of description, only the portion related to the embodiment of the present invention is shown, and details of the specific technology are not disclosed, please refer to the embodiment shown in fig. 1-4 of the present invention.

Fig. 5 is a schematic structural diagram of a database configuration device according to an embodiment of the present invention. As shown in fig. 5, the database configuration device 1 according to the embodiment of the present invention may include: the system comprises an information acquisition unit 11, a resource configuration unit 12, a virtual machine initialization unit 13 and a database configuration unit 14.

An information obtaining unit 11, configured to obtain database creation condition information of a service database in which data is written to a target service;

in a specific implementation, the information obtaining unit 11 may obtain database creation condition information of a service database, which is submitted by a user and used for writing data into a target service, where the target service is a network service that needs to configure the service database to write and store service data, for example: game, special web page, etc., where the service data is data generated by the target service when the terminal runs, and may be data generated for personal operation, or may be data generated for a service framework of the current target service, for example: the database creation condition information may be related information created by a database inputted by a developer of the target service according to a requirement of the target service, such as: the service database configuration method includes the steps of obtaining a database type, database configuration demand information and the like, wherein the database configuration demand information can be used for representing whether a currently configured service database needs to be high-availability demand information or not, and preferably, the database configuration device 1 can output a database configuration interface for a developer to select.

A resource configuration unit 12, configured to create, in a target server under a cloud platform, a virtual machine corresponding to the target service according to the database creation condition information, and configure a cloud storage resource for the virtual machine;

in a specific implementation, the resource configuration unit 12 may create, according to the database creation condition information, a virtual machine corresponding to the target service in a target server under a cloud platform, and configure a cloud storage resource for the virtual machine, and further, the resource configuration unit 12 may determine whether a database type selected in the database creation condition information is a preset database type, for example: whether the mirror name is the SQL Server or not can be judged, whether the mirror name contains 2012 characters or not is judged, namely whether the type of the selected database is the SQL Server 2012 or not is judged, and whether the configuration requirement information of the database indicates high availability requirement information or not is judged.

The resource configuration unit 12 may determine, in a server cluster based on a machine room identifier selected by a cloud platform, a target server in a polling manner according to an arrangement order of network address information of each server in the server cluster, create a virtual machine corresponding to the target service in the target server, and configure a cloud storage resource for the virtual machine. It can be understood that a machine room identifier is set for the machine room where each server is located, so as to accurately locate the area where the current server is located, the database creation condition information may further include a machine room identifier selected by a developer, preferably, the resource configuration unit 12 may further name the virtual machine, and each server under the selected machine room identifier is preset with network address information, for example: IP addresses, etc., the resource configuration unit 12 may find a first available server in each server according to the arrangement order of the network address information and by using a polling method, for example: the method includes the steps of determining a first available server as a target server, creating a virtual machine corresponding to a target service in the target server, setting network address information of a public network logic domain for the virtual machine, and configuring cloud storage resources for the virtual machine, wherein the public network logic domain can be represented as an external network, an external terminal bearing the target service can be connected with the virtual machine through the external network, the cloud storage resources are storage resources of storage nodes selected from a cloud storage resource pool, and the storage nodes can include a plurality of OSD.

It should be noted that the database input by the developer for the requirements of the current business creates condition information, such as: the database type, the database configuration requirement information and the like can provide two database modes according to different database creation condition information, namely 'resident availability group creation' and 'stand-alone creation'.

Referring to fig. 6 together, a schematic structural diagram of a resource configuration unit is provided for a first possible implementation manner of the embodiment of the present invention ("database schema of resident availability group creation"). As shown in fig. 6, the resource configuration unit 12 may include:

a virtual machine creating subunit 121, configured to, when the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, determine, in a server cluster based on a machine room identifier selected by a cloud platform, a first server in a polling manner according to an arrangement order of network address information of servers in the server cluster, create, in the first server, a first service virtual machine corresponding to the target service, and configure a cloud storage resource for the first service virtual machine;

the virtual machine creating subunit 121 is further configured to determine, in a first remaining server of the server cluster except the first server, a second server in a polling manner according to an arrangement order of network address information of each server in the first remaining server, create, in the second server, a second service virtual machine corresponding to the target service, and configure a cloud storage resource for the second service virtual machine;

the virtual machine creating subunit 121 is further configured to determine, in a second remaining server of the server cluster except the first server and the second server, a third server in a polling manner according to an arrangement order of network address information of each server in the second remaining server, and create an arbitration virtual machine corresponding to the target service in the third server;

in a specific implementation, when the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, the database configuration device 1 may configure a database mode of "creation of a resident availability group", where the database mode of creation of the resident availability group may be understood as creating a failover cluster of three virtual machines, where two service virtual machines may respectively carry service databases and may synchronize service data, and the other virtual machine is an arbitration virtual machine for determining, together with any service virtual machine, a service virtual machine in the failover cluster that has a failure, and when one of the service virtual machines has a failure, the service virtual machine that currently actually carries a service may be determined to have a failure by real-time monitoring of the arbitration virtual machine and the other service virtual machine, the target service can point to the service database of the other service virtual machine to continue to provide service for the target service. Preferably, the virtual machine creating subunit 121 may create, in a server cluster under a cloud platform, a first service virtual machine, a second service virtual machine, and an arbitration virtual machine corresponding to the target service, and configure cloud storage resources for the first service virtual machine and the second service virtual machine respectively. Further, the virtual machine creating subunit 121 determines, in a server cluster based on a machine room identifier selected by a cloud platform, a first server in a polling manner according to an arrangement order of network address information of each server in the server cluster, and creates a first service virtual machine corresponding to the target service in the first server, where it is understood that a machine room identifier is set for a machine room in which each server is located, so as to accurately locate an area in which a current server is located, the database creating condition information may further include a machine room identifier selected by a developer, each server under the selected machine room identifier is pre-set with network address information, the network address information of each server may be network address information of a private network logical domain or network address information of a public network logical domain, and the public network logical domain may be represented as an external network, the external terminal bearing the service may be connected to the servers through the external network, the private network logical domain is an internal local area network, the servers may perform internal communication through the local area network, the network address information is preferably an IP address, and the virtual machine creating subunit 121 may search a first available server in the servers according to an arrangement sequence of the network address information and by using a polling method, for example: preferably, the virtual machine creating subunit 121 may further name the first service virtual machine, where the naming rule may be: the method includes the steps that a machine room identifier + MSSQL + 6-bit random serial number-1 is obtained, cloud Storage resources are configured for the first service virtual machine, the cloud Storage resources are Storage resources of Storage nodes selected from a cloud Storage resource pool, and the Storage nodes can include a plurality of provided Storage resources (OSD). The virtual machine creating sub-unit 121 determines, in a first remaining server of the server cluster except the first server, a second server in a polling manner according to an arrangement order of network address information of each server in the first remaining server, creates a second service virtual machine corresponding to the target service in the second server, and configures a cloud storage resource for the second service virtual machine, and the virtual machine creating sub-unit 121 may also name the second service virtual machine, where a naming rule may be: the machine room identifier + MSSQL + 6-bit random sequence number-2, and similarly, the virtual machine creating sub-unit 121 determines, in a second remaining server of the server cluster except the first server and the second server, a third server in a polling manner according to an arrangement order of network address information of each server in the second remaining server, and creates an arbitration virtual machine corresponding to the target service in the third server.

To better ensure the high availability characteristic, the virtual machine creation subunit 121 may determine a second server among the remaining servers of the server cluster except for all servers of the rack where the first server is located, a third server may be determined among the remaining servers of the server cluster except for all servers of the rack in which the first server is located and all servers of the rack in which the second server is located, namely, the first server, the second server and the third server are respectively positioned on different racks of the same machine room, by selecting servers of different racks of the same machine room to create the database and build the arbitration virtual machine, the failure of the server at the rack level can be avoided on the basis of reducing the time delay, and the characteristic of high availability is effectively ensured, and certainly, for the service data with low real-time performance, the servers of different machine rooms can be adopted to establish the database and the arbitration virtual machine.

An information setting subunit 122, configured to set network address information of a private network logical domain for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, respectively;

in a specific implementation, the information setting subunit 122 may set network address information of a private network logical domain for each of the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, where the network address information of the private network logical domain of any one of the first service virtual machine, the second service virtual machine, and the arbitration virtual machine is set according to a physical machine identifier of a server to which the any one virtual machine belongs, and it can be understood that a manager of the server may set a physical machine identifier for each server, for example: the information setting subunit 122 may apply for the network address information of the private network logical domain of the first service virtual machine, the second service virtual machine, and the arbitration virtual machine in the network address information pool, respectively, according to the physical machine identifier of the server and the private network logical domain where the server is located.

And for a second possible implementation of an embodiment of the invention (a "stand-alone" database schema):

when the selected database type is a preset database type and the database configuration demand information indicates that the database configuration demand information is not high available demand information, the database configuration device 1 may configure a "stand-alone creation" database mode, and the database mode created by one-click may be understood as a single virtual machine bearing a service database. Preferably, the resource configuration unit 12 may determine, in a server cluster under a machine room identifier selected based on a cloud platform, a target server in a polling manner according to an arrangement order of network address information of each server in the server cluster, create a virtual machine corresponding to the target service in the target server, and configure a cloud storage resource for the virtual machine. It can be understood that a machine room identifier is set for the machine room where each server is located, so as to accurately locate the area where the current server is located, the database creation condition information may further include the machine room identifier selected by the developer, and preferably, the resource configuration unit 12 may also name the virtual machine, and the naming rule may be: machine room identification + MSSQL + 6-bit random serial number-0, and each server under the selected machine room identification is preset with network address information, such as: IP addresses, etc., the resource configuration unit 12 may find a first available server in each server according to the arrangement order of the network address information and by using a polling method, for example: the method includes the steps of determining a first available server as a target server, creating a virtual machine corresponding to a target service in the target server, setting network address information of a public network logic domain for the virtual machine, and configuring cloud storage resources for the virtual machine, wherein the public network logic domain can be represented as an external network, an external terminal bearing the target service can be connected with the virtual machine through the external network, the cloud storage resources are storage resources of storage nodes selected from a cloud storage resource pool, and the storage nodes can include a plurality of OSD.

A virtual machine initialization unit 13, configured to initialize the virtual machine and cloud storage resources of the virtual machine, and perform domain access processing of a public network logical domain on the virtual machine;

in a specific implementation, the virtual machine initialization unit 13 may perform initialization processing on the virtual machine and cloud storage resources of the virtual machine, where the process of performing initialization processing on the virtual machine may include naming the virtual machine, binding network address information of a public network logic domain of the virtual machine, initializing a disk, and the like, the process of performing initialization processing on the cloud storage resources may include disk scanning, disk activation, disk formatting, setting a use drive, and the like, and after performing initialization processing on the virtual machine and cloud storage resources of the virtual machine, the virtual machine initialization unit 13 may further perform domain entry processing on the virtual machine in the public network logic domain.

With reference to fig. 7, a schematic structural diagram of a virtual machine initialization unit is provided in an embodiment of the present invention. As shown in fig. 7, the virtual machine initialization unit 13 may include:

an initialization processing subunit 131, configured to perform initialization processing on the first service virtual machine, the second service virtual machine, the arbitration virtual machine, the cloud storage resource of the first service virtual machine, and the cloud storage resource of the second service virtual machine;

in a specific implementation, the initialization processing subunit 131 may respectively perform initialization processing on the first service virtual machine, the second service virtual machine, the cloud storage resource of the first service virtual machine, and the cloud storage resource of the second service virtual machine when it is monitored that the first service virtual machine and the second service virtual machine are switched from a creation state to an operation state, where the initialization processing of the virtual machines may include naming the virtual machines, binding network address information of the virtual machines, initializing disks, and the like, and the initialization processing of the cloud storage resources may include disk scanning, disk activation, disk formatting, setting a use disk identifier, and the like.

A domain entry processing subunit 132, configured to perform, after initialization processing, domain entry processing on the public network logical domain for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine according to network address information of the public network logical domain that is respectively configured for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine in advance;

in a specific implementation, the domain entry processing subunit 132 may perform initialization processing on the first service virtual machine, the second service virtual machine, the cloud storage resource of the first service virtual machine, and the cloud storage resource of the second service virtual machine, and after waiting for completion of network card configuration of the private network logical domain, according to the network address information of the public network logic domain which is respectively configured for the first service virtual machine, the second service virtual machine and the arbitration virtual machine in advance, performing domain entry processing of the public network logical domain on the first service virtual machine, the second service virtual machine and the arbitration virtual machine, it can be understood that the network address information of the public network logical domain respectively configured by the first service virtual machine, the second service virtual machine, and the arbitration virtual machine is respectively applied in the network address information pool after each virtual machine is created by the database configuration device 1.

For the second possible implementation manner, the virtual machine initialization unit 13 may perform initialization processing on the virtual machine and the cloud storage resource of the virtual machine, where the process of performing initialization processing on the virtual machine may include naming the virtual machine, binding network address information of a public network logical domain of the virtual machine, initializing a disk, and the like, the process of performing initialization processing on the cloud storage resource may include disk scanning, disk activation, disk formatting, setting a use drive, and the like, and after performing initialization processing on the cloud storage resource of the virtual machine and the virtual machine, the virtual machine initialization unit 13 may further perform domain entry processing on the public network logical domain of the virtual machine.

The database configuration unit 14 is configured to configure the database of the virtual machine after domain entry processing, and connect the database of the virtual machine and the cloud storage resource;

in a specific implementation, after performing domain entry processing of a public network logical domain on the virtual machine, the database configuration unit 14 may further configure the database of the virtual machine, and connect the database of the virtual machine and the cloud storage resource.

Referring to fig. 8 together with the above-mentioned first possible implementation manner, a schematic structural diagram of a database configuration unit is provided for an embodiment of the present invention. As shown in fig. 8, the database configuration unit 14 may include:

a database configuration subunit 141, configured to configure, after domain entry processing, a database of the first service virtual machine and a database of the second service virtual machine, connect the database of the first service virtual machine and cloud storage resources, and connect the database of the second service virtual machine and cloud storage resources;

in a specific implementation, the database configuration subunit 141 may configure the database of the first service virtual machine and the database of the second service virtual machine, connect the database of the first service virtual machine and the cloud storage resource, and connect the database of the second service virtual machine and the cloud storage resource, it is understood that the database configuration device 1 may configure a primary copy and an auxiliary copy, where the primary copy is used to carry the database of the first service virtual machine and has a read-write function, the auxiliary copy is used to carry the database of the second service virtual machine as a potential fault transfer target, and the auxiliary copy may be a read-only copy, and when a user queries a target service, the user may read corresponding service data through the auxiliary copy, and by adopting a database cluster and a mirror read-write separation manner, and reasonable application hardware resources are facilitated.

An information configuration subunit 142, configured to configure virtual network address information of failover for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, and configure virtual network address information of the target service for the first service virtual machine and the second service virtual machine;

in a specific implementation, the information configuring subunit 142 may configure virtual network address information of failover for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, and configure virtual network address information of the target service for the first service virtual machine and the second service virtual machine, it may be understood that the virtual network address information of failover and the virtual network address information of the target service may be a common network address applied in a network address information pool after each virtual machine is created by the database configuration device 1, and preferably, the virtual network address information of failover and the virtual network address application of the target service may be performed according to a physical machine identifier of the first server to which the first service virtual machine belongs and a public network logical domain to which the first server belongs, the virtual network address information of the failover is used for representing the network address of the failover cluster formed by the first service virtual machine, the second service virtual machine and the arbitration virtual machine, that is, the running states of the database of the first service virtual machine and the database of the second service virtual machine can be monitored in real time or at regular time among the three virtual machines according to the virtual network address information of the failover, and the network address information of the private network logic domain of each virtual machine is taken as the heartbeat network address information. The virtual network address information of the target service is used for representing a network address of data writing of the target service, namely, an external terminal bearing the target service can upload the service data of the target service to a database of a first service virtual machine or a database of a second service virtual machine by configuring the virtual network address information of the target service, and the network address of the actual public network logic domain of the first service virtual machine or the network address of the actual public network logic domain of the second service virtual machine does not need to be acquired, so that the network address pointing of the external terminal when the service data is written is prevented from being modified in batch when one virtual machine fails, and the data writing efficiency of the target service is improved.

For the second possible implementation manner, after performing domain entry processing on the virtual machine in the public network logical domain, the database configuration unit 14 may further configure the database of the virtual machine, and connect the database of the virtual machine and the cloud storage resource.

In the embodiment of the invention, the database creating condition information of the service database of the target service is acquired, the virtual machine corresponding to the target service is created in the target server under the cloud platform according to the database creating condition information, the cloud storage resources are configured for the virtual machine, the virtual machine and the cloud storage resources of the virtual machine are initialized, the virtual machine is subjected to domain entry processing of a public network logic domain, the database of the virtual machine is configured after the domain entry processing, and the database of the virtual machine and the cloud storage resources are finally connected. The establishment of the virtual machine and the configuration of the database are completed in the target server according to the acquired database establishment condition information, so that the automatic configuration process of the database is realized, and meanwhile, the number of service databases which can be borne by the server is increased by adopting a virtual machine and cloud storage mode, the utilization rate of the server is improved, and the costs of human resources, hardware resources and the like are effectively reduced; the deployment of a high-availability architecture is realized by configuring a database mode of 'resident availability group creation'; by selecting servers of different racks in the same computer room to create the database, the failure of the servers at the rack level can be avoided on the basis of reducing time delay, and the characteristic of high availability is effectively ensured; by providing database modes of 'resident availability group creation' and 'stand-alone creation', the configuration modes of the database can be enriched, and different service requirements can be met.

Referring to fig. 9, a schematic structural diagram of another database configuration device according to an embodiment of the present invention is provided. As shown in fig. 9, the database configuration device 1 according to the embodiment of the present invention may include: the system comprises an information acquisition unit 11, a resource configuration unit 12, a virtual machine initialization unit 13, a database configuration unit 14 and a state recording unit 15; the structures of the information obtaining unit 11, the resource configuring unit 12, the virtual machine initializing unit 13, and the database configuring unit 14 may refer to the specific description of the embodiment shown in fig. 5, which is not described herein again.

The state recording unit 15 is configured to record, by using a preset monitoring script, a creation state of the virtual machine, a configuration state of the cloud storage resource, and a configuration state of a database of the virtual machine;

in a specific implementation manner, for the first feasible embodiment, the state recording unit 15 may further preset a monitoring script when the information obtaining unit 11 obtains the database creation condition information, where the monitoring script is used to record a creation state of the first service virtual machine, a creation state of the second service virtual machine, a creation state of the arbitration virtual machine, a configuration state of the cloud storage resource, and a configuration state of the database, and when any one of the creation state of the first service virtual machine, the creation state of the second service virtual machine, the creation state of the arbitration virtual machine, the configuration of the cloud storage resource, and the configuration of the database is abnormal and database configuration fails, the monitoring script may generate an error log and trigger a rollback operation, and when database configuration is successful, the listening script may generate a notification message that the database configuration is successful, and the notification message is preferably a pre-agreed script status value (e.g., 200, etc.).

For the second possible implementation manner, the state recording unit 15 may further preset a monitoring script when the information obtaining unit 11 obtains the database creation condition information, where the monitoring script is configured to record a creation state of the virtual machine, a configuration state of the cloud storage resource, and a configuration state of the database of the virtual machine, and when any one of the creation state of the virtual machine, the configuration state of the cloud storage resource, and the configuration state of the database of the virtual machine is abnormal and results in a failure of database configuration, the monitoring script may generate an error log and trigger a rollback operation, and when the database configuration is successful, the monitoring script may generate notification information that the database configuration is successful, where the notification information is preferably a predetermined script state value (e.g., 200, etc.).

Referring to fig. 10, a schematic structural diagram of another database configuration device according to an embodiment of the present invention is provided. As shown in fig. 10, the database configuration apparatus 1000 may include: at least one processor 1001, such as a CPU, at least one network interface 1004, a user interface 1003, memory 1005, at least one communication bus 1002. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display) and a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a standard wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (non-volatile memory), such as at least one disk memory. The memory 1005 may optionally be at least one memory device located remotely from the processor 1001. As shown in fig. 10, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a database configuration application program.

In the database configuration apparatus 1000 shown in fig. 10, the user interface 1003 is mainly used as an interface for providing input for a user, and acquiring data input by the user; network interface 1004 is used for data communication with managed cloud servers; and the processor 1001 may be configured to invoke a database configuration application stored in the memory 1005 and specifically perform the following operations:

In one embodiment, the database creation condition information includes the selected database type and the selected database configuration requirement information;

when the processor 1001 creates a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creation condition information, and configures a cloud storage resource for the virtual machine, the following operations are specifically performed:

when the selected database type is a preset database type and the database configuration demand information indicates high available demand information, creating a first service virtual machine, a second service virtual machine and an arbitration virtual machine corresponding to the target service in a server cluster under a cloud platform, and respectively configuring cloud storage resources for the first service virtual machine and the second service virtual machine.

In an embodiment, when the processor 1001 creates a first service virtual machine, a second service virtual machine, and an arbitration virtual machine corresponding to the target service in a server cluster executing on a cloud platform, and configures cloud storage resources for the first service virtual machine and the second service virtual machine, the following operations are specifically executed:

in a server cluster under a machine room identifier selected based on a cloud platform, determining a first server in a polling mode according to the arrangement sequence of network address information of servers in the server cluster, creating a first service virtual machine corresponding to the target service in the first server, and configuring cloud storage resources for the first service virtual machine;

in a first remaining server of the server cluster except the first server, determining a second server in a polling manner according to an arrangement sequence of network address information of each server in the first remaining server, creating a second service virtual machine corresponding to the target service in the second server, and configuring a cloud storage resource for the second service virtual machine;

determining a third server in a second remaining server of the server cluster except the first server and the second server by adopting a polling mode according to the arrangement sequence of the network address information of each server in the second remaining server, and creating an arbitration virtual machine corresponding to the target service in the third server;

network address information of a private network logical domain is set for the first service virtual machine, the second service virtual machine and the arbitration virtual machine respectively;

the network address information of the private network logical domain of any virtual machine of the first service virtual machine, the second service virtual machine and the arbitration virtual machine is set according to the physical machine identifier of the server to which the any virtual machine belongs.

In one embodiment, the first server, the second server and the third server belong to the same computer room and belong to different racks.

In an embodiment, when the processor 1001 performs initialization processing on the virtual machine and the cloud storage resource of the virtual machine, and performs domain entry processing of a public network logical domain on the virtual machine, the following operations are specifically performed:

initializing the first service virtual machine, the second service virtual machine, the arbitration virtual machine, the cloud storage resource of the first service virtual machine and the cloud storage resource of the second service virtual machine;

after initialization processing, according to network address information of a public network logic domain respectively configured for the first service virtual machine, the second service virtual machine and the arbitration virtual machine in advance, performing domain access processing of the public network logic domain on the first service virtual machine, the second service virtual machine and the arbitration virtual machine.

In an embodiment, when the processor 1001 configures the database of the virtual machine after performing the domain entry processing, and connects the database of the virtual machine and the cloud storage resource, the following operation is specifically performed:

after domain entry processing, configuring a database of the first service virtual machine and a database of the second service virtual machine, connecting the database of the first service virtual machine and cloud storage resources, and connecting the database of the second service virtual machine and cloud storage resources;

configuring virtual network address information of fault transfer for the first service virtual machine, the second service virtual machine and the arbitration virtual machine, and configuring virtual network address information of the target service for the first service virtual machine and the second service virtual machine;

the virtual network address information of the failover is used for representing the network address of a failover cluster formed by the first service virtual machine, the second service virtual machine and the arbitration virtual machine; the virtual network address information of the target service is used for representing a network address of data writing of the target service.

when the selected database type is a preset database type and the database configuration demand information indicates that the database configuration demand information is not high-availability demand information, in a server cluster under a machine room identifier selected based on a cloud platform, determining a target server in a polling mode according to the arrangement sequence of network address information of servers in the server cluster, creating a virtual machine corresponding to the target service in the target server, and configuring cloud storage resources for the virtual machine.

In one embodiment, the processor 1001 further performs the following operations:

and recording the creation state of the virtual machine, the configuration state of the cloud storage resource and the configuration state of the database of the virtual machine by adopting a preset monitoring script.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.

The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.

Claims

1. A database configuration method, comprising:

acquiring database creating condition information of a submitted service database for writing data into a target service, wherein the database creating condition information comprises the selected database type and the selected database configuration requirement information;

2. The method of claim 1,

the creating a virtual machine corresponding to the target service in a target server under a cloud platform according to the database creating condition information, and configuring cloud storage resources for the virtual machine, including:

3. The method according to claim 2, wherein the creating a first service virtual machine, a second service virtual machine, and an arbitration virtual machine corresponding to the target service in a server cluster under a cloud platform, and respectively configuring cloud storage resources for the first service virtual machine and the second service virtual machine comprises:

4. The method of claim 3, wherein the first server, the second server, and the third server are servers belonging to the same computer room and belonging to different racks.

5. The method according to claim 2, wherein initializing the virtual machine and cloud storage resources of the virtual machine, and performing domain entry processing of a public network logical domain on the virtual machine comprises:

6. The method of claim 2, wherein configuring the database of the virtual machine after the domain entry processing, and connecting the database of the virtual machine and the cloud storage resource comprises:

7. The method of claim 1,

8. The method of claim 1, further comprising:

9. A database configuration device, comprising:

the information acquisition unit is used for acquiring database creation condition information of a submitted service database for writing data into the target service, wherein the database creation condition information comprises the selected database type and the selected database configuration requirement information;

10. The apparatus of claim 9,

the resource configuration unit is specifically configured to, when the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, create a first service virtual machine, a second service virtual machine, and an arbitration virtual machine corresponding to the target service in a server cluster under a cloud platform, and configure cloud storage resources for the first service virtual machine and the second service virtual machine, respectively.

11. The apparatus of claim 10, wherein the resource configuration unit comprises:

a virtual machine creating subunit, configured to, when the selected database type is a preset database type and the database configuration demand information indicates high availability demand information, determine, in a server cluster based on a machine room identifier selected by a cloud platform, a first server in a polling manner according to an arrangement order of network address information of servers in the server cluster, create, in the first server, a first service virtual machine corresponding to the target service, and configure a cloud storage resource for the first service virtual machine;

the virtual machine creating subunit is further configured to determine, in a first remaining server of the server cluster except the first server, a second server in a polling manner according to an arrangement sequence of network address information of each server in the first remaining server, create, in the second server, a second service virtual machine corresponding to the target service, and configure a cloud storage resource for the second service virtual machine;

the virtual machine creating subunit is further configured to determine, in a second remaining server of the server cluster excluding the first server and the second server, a third server in a polling manner according to an arrangement order of network address information of each server in the second remaining server, and create an arbitration virtual machine corresponding to the target service in the third server;

an information setting subunit, configured to set network address information of a private network logical domain for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, respectively;

12. The apparatus of claim 11, wherein the first server, the second server, and the third server are servers belonging to a same room and belonging to different racks.

13. The apparatus of claim 10, wherein the virtual machine initialization unit comprises:

the initialization processing subunit is configured to perform initialization processing on the first service virtual machine, the second service virtual machine, the arbitration virtual machine, the cloud storage resource of the first service virtual machine, and the cloud storage resource of the second service virtual machine;

and the domain access processing subunit is configured to perform domain access processing on the public network logical domain for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine according to network address information of the public network logical domain, which is configured for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine in advance, after initialization processing.

14. The apparatus of claim 10, wherein the database configuration unit comprises:

the database configuration subunit is used for configuring the database of the first service virtual machine and the database of the second service virtual machine after domain entry processing, connecting the database of the first service virtual machine and the cloud storage resource, and connecting the database of the second service virtual machine and the cloud storage resource;

an information configuration subunit, configured to configure virtual network address information of failover for the first service virtual machine, the second service virtual machine, and the arbitration virtual machine, and configure virtual network address information of the target service for the first service virtual machine and the second service virtual machine;

15. The apparatus of claim 9,

the resource configuration unit is specifically configured to, when the selected database type is a preset database type and the database configuration demand information indicates that the database configuration demand information is not high-availability demand information, determine, in a server cluster based on a machine room identifier selected by a cloud platform, a target server in a polling manner according to an arrangement sequence of network address information of servers in the server cluster, create, in the target server, a virtual machine corresponding to the target service, and configure cloud storage resources for the virtual machine.

16. The apparatus of claim 9, further comprising:

and the state recording unit is used for recording the creation state of the virtual machine, the configuration state of the cloud storage resource and the configuration state of the database of the virtual machine by adopting a preset monitoring script.

17. A database configuration device, comprising a processor, a memory and a network interface, wherein the processor, the memory and the network interface are connected with each other, the network interface is used for data communication with a cloud server managed by the database configuration device, the memory is used for storing program codes, and the processor is used for calling the program codes and executing the database configuration method according to any one of claims 1 to 8.

18. A storage medium, characterized in that the storage medium stores a computer program comprising program instructions; the program instructions, when executed by a processor, cause the processor to perform the database configuration method of any of claims 1-8.