CN112685486B

CN112685486B - Data management method and device for database cluster, electronic equipment and storage medium

Info

Publication number: CN112685486B
Application number: CN202110008462.8A
Authority: CN
Inventors: 赖明星
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2021-01-05
Filing date: 2021-01-05
Publication date: 2023-10-24
Anticipated expiration: 2041-01-05
Also published as: CN112685486A

Abstract

The disclosure provides a data management method, a device, electronic equipment and a storage medium of a database cluster, wherein the method comprises the following steps: monitoring the working state of each database standby machine, wherein the database standby machines are contained in the same database cluster; screening target standby machines meeting preset service requirements from the database standby machines based on the working states of the database standby machines; and updating the target IP address corresponding to the read-only domain name of the database cluster in a domain name resolution server according to the IP address of each target standby machine, so that the read-only domain name sent by the service is resolved through the domain name resolution server, and the service reads only the target standby machine with the target IP address. The embodiment of the disclosure can meet the customized service demand while supporting the read operation of the service on the database cluster, reduce the consumption of hardware resources and realize the disaster recovery across the machine room.

Description

Data management method and device for database cluster, electronic equipment and storage medium

Technical Field

The disclosure relates to the field of database clusters, and in particular relates to a data management method, device, electronic equipment and storage medium of a database cluster.

Background

In the field of database clusters, it is necessary to ensure that the database services are highly available, i.e. that the machines in the database cluster can be switched quickly and that the downtime is short. In the prior art, a widely used service highly available technology for database cluster management is LVS (Linux Virtual Server) technology.

LVS is a high availability technology based on the IP layer, transparent to applications, and thus versatile. However, due to the versatility of application transparency, LVS cannot support any service logic, and in practical use, it is often necessary to implement specific service logic.

The LVS itself needs to occupy a considerable amount of hardware resources, and has high network bandwidth requirements on the hardware resources; in addition, to ensure high availability of the database clusters, the LVS itself also needs to be highly available, thus requiring more hardware resources.

Although the LVS realizes application transparency through the IP layer, it requires that its server and backend service are in the same physical network under the operating conditions of the best performing mode. Once the physical network fails physically (e.g., power down, network cable break), the database cluster service may be rendered unavailable. I.e. without disaster recovery capability across the machine room.

Disclosure of Invention

An object of the present disclosure is to provide a data management method, apparatus, electronic device, and storage medium for a database cluster, which can support a read operation of a service on the database cluster, meet a customized service requirement, reduce consumption of hardware resources, and implement disaster recovery across a machine room.

According to an aspect of an embodiment of the present disclosure, a data management method of a database cluster is disclosed, the method including:

monitoring the working state of each database standby machine, wherein the database standby machines are contained in the same database cluster;

screening target standby machines meeting preset service requirements from the database standby machines based on the working states of the database standby machines;

and updating the target IP address corresponding to the read-only domain name of the database cluster in a domain name resolution server according to the IP address of each target standby machine, so that the read-only domain name sent by the service is resolved through the domain name resolution server, and the service reads only the target standby machine with the target IP address.

According to an aspect of an embodiment of the present disclosure, there is disclosed a data management apparatus of a database cluster, the apparatus including:

The monitoring module is configured to monitor the working state of each database backup machine, wherein the database backup machines form the same database cluster;

the screening module is configured to screen target standby machines meeting preset service requirements from the database standby machines based on the working states of the database standby machines;

and the updating module is configured to update the target IP address corresponding to the read-only domain name of the database cluster in a domain name resolution server according to the IP address of each target standby machine, so that the read-only domain name sent by the service is resolved by the domain name resolution server, and the service reads only the target standby machine with the target IP address, wherein the read-only domain name is used for the service to read only the database cluster.

In an exemplary embodiment of the present disclosure, the apparatus is configured to:

receiving real-time attribute data of each database backup machine from the proxy service;

and monitoring the working state of each database standby machine based on the real-time attribute data of each database standby machine.

determining whether each database standby machine has faults or not based on the working state of each database standby machine;

And taking the database standby machine which does not have faults as the target standby machine.

determining the replication delay of each database standby machine for data replication from a database host machine based on the working state of each database standby machine;

and taking the database standby machine with the replication delay lower than a preset time threshold as the target standby machine.

determining the coincidence degree of each target standby machine and the service requirement based on the working state of each target standby machine;

and sequencing the target standby machines based on the coincidence degree, and updating the IP address of the target standby machine with the forefront sequencing in the domain name resolution server by taking the IP address as the target IP address.

responding to the faults of the standby machines of the current read-only operation of the service, removing the faulty standby machines from the target standby machines, and updating the target IP addresses corresponding to the read-only domain names of the database clusters in a domain name resolution server according to the IP addresses of the target standby machines;

And responding to the service to resend the read-only domain name, and resolving the read-only domain name again through the domain name resolution server, so that the service continues to read-only operation on the database cluster.

and receiving a configuration request aiming at the read-only domain name through a configuration page, and configuring the read-only domain name of the requested configuration according to the configuration request.

According to an aspect of an embodiment of the present disclosure, there is disclosed a data management electronic device of a database cluster, including: a memory storing computer readable instructions; a processor reads the computer readable instructions stored in the memory to perform the method in any of the embodiments of the present disclosure.

According to an aspect of the disclosed embodiments, a computer program medium is disclosed, on which computer readable instructions are stored which, when executed by a processor of a computer, cause the computer to perform the method of any of the embodiments of the disclosure.

According to one aspect of the disclosed embodiments, a computer program product or computer program is provided, the computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The computer instructions are read from the computer-readable storage medium by a processor of a computer device, and executed by the processor, cause the computer device to perform the methods provided in the various alternative implementations described above.

In the embodiment of the disclosure, by configuring the interaction structure among the database standby machine, the domain name resolution server and the service, the service can read the database cluster by only sending the read-only domain name. Because the database standby machine serving as the communication interface between the service and the database cluster is screened out according to the service requirement, the embodiment of the disclosure can meet the customized service requirement while supporting the reading operation of the service on the database cluster; because the domain name resolution server belongs to a common component and occupies only few hardware resources, the embodiment of the disclosure can reduce the consumption of hardware resources while supporting the read operation of the business on the database cluster; and because the read-only domain name is only one parameter configured for the domain name resolution server to resolve the IP address, no physical limitation exists, the embodiment of the disclosure can realize disaster recovery across machine rooms or disaster recovery across cities while supporting the read operation of the business on the database cluster.

Other features and advantages of the present disclosure will be apparent from the following detailed description, or may be learned in part by the practice of the disclosure.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent by describing in detail exemplary embodiments thereof with reference to the attached drawings.

FIG. 1 illustrates an architecture of a data management platform for managing database clusters according to one embodiment of the present disclosure.

FIG. 2 illustrates a flow chart of a method of data management of a database cluster, according to one embodiment of the present disclosure.

Fig. 3A illustrates the composition of a blockchain system in accordance with an embodiment of the present disclosure.

Fig. 3B illustrates the structure of a block in a blockchain system in accordance with an embodiment of the present disclosure.

Fig. 3C illustrates a process of generating a new block according to one embodiment of the present disclosure.

Fig. 4 illustrates a block diagram of a data management apparatus of a database cluster, according to one embodiment of the present disclosure.

Fig. 5 illustrates a hardware diagram of a data management electronic device of a database cluster according to one embodiment of the present disclosure.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. However, the exemplary embodiments may be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these example embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus a repetitive description thereof will be omitted.

Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more example embodiments. In the following description, numerous specific details are provided to give a thorough understanding of example embodiments of the disclosure. One skilled in the relevant art will recognize, however, that the aspects of the disclosure may be practiced without one or more of the specific details, or with other methods, components, steps, etc. In other instances, well-known structures, methods, implementations, or operations are not shown or described in detail to avoid obscuring aspects of the disclosure.

Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in software or in one or more hardware modules or integrated circuits or in different networks and/or processor devices and/or microcontroller devices.

The basic architecture of an embodiment of the present disclosure is described below first with reference to fig. 1.

FIG. 1 illustrates an architecture of a data management platform for managing a database cluster in accordance with one embodiment of the present disclosure. The Database (Database), which may be referred to as an electronic file cabinet, is a place where electronic files are stored, and a user may perform operations such as adding, querying, updating, deleting, etc. on data in the files. A "database" is a collection of data stored together in a manner that can be shared with multiple users, with as little redundancy as possible, independent of the application.

The data management platform provided by the embodiment of the disclosure can be a database management system. Specifically, a database management system (Database Management System, abbreviated as DBMS in English) is a computer software system designed for managing databases, and generally has basic functions of storage, interception, security, backup and the like. The database management system may classify according to the database model it supports, e.g., relational, XML (Extensible Markup Language ); or by the type of computer supported, e.g., server cluster, mobile phone; or by the query language used, such as SQL (structured query language (Structured Query Language), XQuery, or by the energy impact emphasis, such as maximum-scale, maximum-speed, or other classification means, regardless of which classification means is used, some DBMSs can cross-category, for example, while supporting multiple query languages.

In this embodiment, the data management platform mainly includes: an administrator and domain name service. Wherein, the administrator refers to a management process for uniformly managing the database cluster; domain name service refers to a service process for resolving a domain name to an IP (Internet Protocol ) address, and the carrier of domain name service is typically a domain name resolution server.

The database cluster managed by the administrator consists of a database host M, a database standby machine S1, a database standby machine S2 and a database standby machine S3. Wherein, the data stored in each database standby machine is synchronized with the data stored in the database host machine M; the database backup machines S1, S2, S3 are merely illustrative of a plurality of database backup machines in a database cluster, and are not representative of only three database backup machines in a database reference.

The database host M and the database backup are generally independent servers, and are generally used for storing data collected from the terminal. The server may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing cloud computing service. The terminal may be, but is not limited to, a smart phone, a tablet computer, a notebook computer, a desktop computer, a smart speaker, a smart watch, etc. The terminal and the server may be directly or indirectly connected through wired or wireless communication, and the present application is not limited herein.

The service is a process which is located outside the data management platform, can communicate with the data management platform and is used for realizing specific service operation. And the business performs read-only operation on the database cluster through the read-only domain name of the database cluster.

Specifically, the service sends the read-only domain name of the database cluster to the domain name service, the domain name service analyzes the read-only domain name, and the analyzed target IP address is returned to the service. The target IP address is used to indicate a database backup to which the service should establish communication to perform a read operation on the database cluster. After receiving the target IP address, the service establishes communication with the database standby machine of the target IP address, and performs reading operation on the database standby machine of the target IP address, thereby realizing the reading operation on the database cluster.

And proxy services are arranged in each database standby machine, are used as the extension of an administrator in the database standby machine, and are responsible for monitoring the database standby machines, collecting and processing related data of the database standby machines, and sending the collected and processed data to the administrator so as to enable the administrator to monitor each database standby machine. And the administrator takes the IP address of one of the database backup machines as a target IP address associated with the read-only domain name according to the monitoring of the database backup machines, and updates the IP address in the domain name service.

It should be noted that the embodiment is only an exemplary illustration, and should not limit the function and scope of use of the present disclosure.

Before describing in detail the implementation of the embodiments of the present disclosure, a brief explanation of some concepts related to the embodiments of the present disclosure will be first provided.

Database backup refers to a machine in a database cluster that is primarily used for synchronous backup. The synchronous backup means that the database backup machine backs up the data in the database host machine so as to synchronize with the database host machine; the database standby machine and the database host machine form the same database cluster together, and the database cluster is expressed as a database on the logic of an application layer; the data stored in each database backup machine should eventually remain consistent.

Operations of the business on the database cluster are divided into two main types, namely a reading operation and an updating operation. Wherein, the updating, inserting and deleting belong to updating operation, and all the data stored in the database cluster are actually changed; read-only refers to a service that reads only data in a database cluster and does not update the contents of the database cluster.

In the embodiment of the disclosure, the updating operation of the database cluster is routed to the database host, and the business updates the database cluster through the updating operation database host; and routing the read-only operation of the database cluster to the database backup machine, and performing read-only operation on the database cluster by the service through the read-only operation database backup machine.

In the embodiment of the disclosure, the read-only domain name is a domain name provided for a service, and the service can only read the database cluster through the read-only domain name and does not update the database cluster.

Replication latency refers to the delay in the synchronization process by which a database backup machine synchronizes backup data from a database host machine. It can be appreciated that, because the hardware conditions of the machine are different and the load of the machine is different between each database backup machine, the replication delay of different database backup machines is long and short.

FIG. 2 illustrates a flow chart of a method of data management of database clusters of an embodiment of the present disclosure, illustratively in a data management platform execution body that uniformly manages each database cluster, the method comprising:

step S110, monitoring the working state of each database standby machine, wherein the database standby machines are contained in the same database cluster;

step S120, screening target standby machines meeting preset service requirements from the database standby machines based on the working states of the database standby machines;

step S130, updating the target IP address corresponding to the read-only domain name of the database cluster in a domain name resolution server according to the IP address of each target standby machine, so as to resolve the read-only domain name sent by the service through the domain name resolution server, so that the service can read-only operate the target standby machine with the target IP address.

In the embodiment of the present disclosure, in a state where a service of an application layer initiates a read-only operation: the service sends the read-only domain name of the database cluster to be read-only to the database management platform. After receiving the read-only domain name, the database management platform analyzes the read-only domain name through a domain name analysis server where a domain name service is located, and analyzes a target IP address corresponding to the read-only domain name. The target IP address points to a target standby in the database cluster. And after receiving the target IP address, the service performs read-only operation on the target standby machine of the target IP address. Because the data stored in each database standby machine is synchronous with the database host machine in the database cluster, the business operates the target standby machine of the target IP address in a read-only mode, namely the read-only operation database cluster is realized.

Therefore, when the state of the database standby machine is stable, the service only needs to interact with the domain name resolution server when being connected with the database management platform for the first time; under normal conditions, the service can directly communicate with the database standby machine to perform read operation, so that the intermediate interaction between the service and the database management platform is simplified, and the service performance of the database management platform is improved.

In the embodiment of the disclosure, the data management platform is in a normal operation state: for each database cluster, the data management platform monitors the working state of each database backup machine in the database cluster. The working state of the database backup machine mainly reflects various performances (such as CPU load, data transmission speed and the like) of the database backup machine when the database backup machine works currently. It can be understood that the hardware conditions of the machines are different among the database backup machines, and the loads of the machines are different; moreover, over time, the machine hardware conditions and cluster load of the same database backup machine change. In the embodiment of the disclosure, the working state of the database standby machine is monitored, and the method is mainly used for screening out target standby machines meeting service requirements, and specifically screening out target standby machines meeting service requirements related to read operations. Therefore, when the business reads only the operation target standby machine, the performance of the target standby machine can meet the business requirement.

Therefore, in the embodiment of the disclosure, by configuring the interaction structure among the database standby machine, the domain name resolution server and the service, the service can perform the reading operation on the database cluster only by sending the read-only domain name. Because the database standby machine serving as the communication interface between the service and the database cluster is screened out according to the service requirement, the embodiment of the disclosure can meet the customized service requirement while supporting the reading operation of the service on the database cluster; because the domain name resolution server belongs to a common component and occupies only few hardware resources, the embodiment of the disclosure can reduce the consumption of hardware resources while supporting the read operation of the business on the database cluster; and because the read-only domain name is only one parameter configured for the domain name resolution server to resolve the IP address, no physical limitation exists, the embodiment of the disclosure can realize disaster recovery across machine rooms or disaster recovery across cities while supporting the read operation of the business on the database cluster.

It should be noted that, if the function of the database management platform is weak enough to support the implementation of the method provided by the embodiment of the present disclosure, the functional module for monitoring the database backup machine may be transplanted into a database driver (for example, mySQL driver), and the database driver may monitor whether the database backup machine fails or not and whether copy delay occurs.

In one embodiment, the data management platform monitors the working states of the database backup machines respectively corresponding to the database backup machines through a blockchain system. Specifically, in this embodiment, each database backup machine is used as a blockchain node in the blockchain system, and the working states of each database backup machine are regularly identified and packed into a data block based on a preset identification algorithm, and the data block is uplink (the data block is input into the blockchain). Therefore, the data management platform can monitor the working states corresponding to the database backup machines respectively by inquiring the latest data blocks in the block chain.

The blockchain system is used for data sharing between nodes. Referring to the blockchain system 20 shown in fig. 3A, a plurality of nodes 201 may be included in the blockchain system, and the plurality of nodes 201 may refer to individual clients in the blockchain system. Each node 201 may receive input information during normal operation and maintain shared data within the blockchain system based on the received input information. In order to ensure the information intercommunication in the blockchain system, information connection can exist between every two nodes in the blockchain system, and the nodes can transmit information through the information connection. For example, when any node in the blockchain system receives input information, other nodes in the blockchain system acquire the input information according to a consensus algorithm, and store the input information as data in shared data, so that the data stored on all nodes in the blockchain system are consistent.

For each node in the blockchain system, the node identification corresponding to the node identification is provided, and each node in the blockchain system can store the node identifications of other nodes in the blockchain system so as to broadcast the generated blocks to other nodes in the blockchain system according to the node identifications of other nodes. Each node can maintain a node identification list shown in the following table, and the node names and the node identifications are correspondingly stored in the node identification list. The node identifier may be an IP address or any other information that can be used to identify the node, and table 1 is only described by taking the IP address as an example.

Node name	Node identification
		Node 1	117.114.151.174
Node 2	117.116.189.145
		...	...
Node N	119.123.789.258

TABLE 1 node identification list

Each node in the blockchain system stores one and the same blockchain. The blockchain is composed of a plurality of blocks, referring to fig. 3B, the blockchain is composed of a plurality of blocks, the starting block comprises a block header and a block main body, the block header stores an input information characteristic value, a version number, a time stamp and a difficulty value, and the block main body stores input information; the next block of the starting block takes the starting block as a father block, the next block also comprises a block head and a block main body, the block head stores the input information characteristic value of the current block, the block head characteristic value of the father block, the version number, the timestamp and the difficulty value, and the like, so that the block data stored in each block in the block chain are associated with the block data stored in the father block, and the safety of the input information in the block is ensured.

When each block in the blockchain is generated, referring to fig. 3C, when the node where the blockchain is located receives input information, checking the input information, after the checking is completed, storing the input information into a memory pool, and updating a hash tree used for recording the input information; then, updating the update time stamp to the time of receiving the input information, trying different random numbers, and calculating the characteristic value for a plurality of times, so that the calculated characteristic value can meet the following formula:

SHA256(SHA256(version+prev_hash+merkle_root+ntime+nbits+x))<TARGET

wherein SHA256 is a eigenvalue algorithm used to calculate eigenvalues; version (version number) is version information of the related block protocol in the block chain; the prev_hash is the block header characteristic value of the parent block of the current block; the merkle_root is a characteristic value of input information; ntime is the update time of the update timestamp; the nbits is the current difficulty, is a fixed value in a period of time, and is determined again after exceeding a fixed period of time; x is a random number; TARGET is a eigenvalue threshold that can be determined from nbits.

Thus, when the random number meeting the formula is calculated, the information can be correspondingly stored to generate the block head and the block main body, and the current block is obtained. And then, the node where the blockchain is located sends the newly generated blocks to other nodes in the blockchain system where the newly generated blocks are located according to the node identification of other nodes in the blockchain system, the other nodes verify the newly generated blocks, and the newly generated blocks are added into the blockchain stored in the newly generated blocks after the verification is completed.

The embodiment has the advantages that the working states of the database backup machines are managed through the block chain system, the transparency and the safety of the working state management are improved, and meanwhile, the data management platform can acquire the working states of the database backup machines more conveniently.

In an embodiment, pre-setting proxy service for each database backup machine, monitoring the working state of each database backup machine includes:

In this embodiment, the database management platform sets a proxy service in each database standby in the database cluster in advance, so as to monitor the working state of the database standby through the proxy service. The Agent service refers to an Agent of the autonomous Agent, and the Agent can be regarded as an extension of the database management platform on the database backup machine. Generally, the Agent uses a state machine model to execute an operation flow of a preset algorithm so as to complete information acquisition and processing and communicate with a database management platform.

Specifically, the Agent monitors the attribute performance of the database backup machine in real time in the database backup machine, and sends the real-time attribute data of the database backup machine to the database management platform. Specifically, the Agent may send real-time attribute data of the database backup machine to the database management platform periodically (e.g., every 5 seconds); the Agent can also send the real-time attribute data of the database standby machine to the database management platform after receiving the instruction of the database management platform.

And after receiving the real-time attribute data of each database standby machine, the database management platform can monitor the working state of each database standby machine on the basis.

The embodiment has the advantage that the real-time monitoring of the database backup machine is ensured through the setting of the proxy service.

It is to be understood that this embodiment is merely an exemplary illustration and should not be taken as limiting the function or scope of the disclosure. Besides monitoring the working state of each database backup machine by setting proxy service, the database management platform can also enable the database backup machine to report the respective real-time attribute data by itself through a protocol between the database management platform and the database backup machine, so that the database management platform monitors the working state of each database backup machine in this way.

In an embodiment, based on the working state of each database standby machine, selecting a target standby machine meeting a preset service requirement from the database standby machines includes:

In this embodiment, the database management platform uses whether the failure is the standard for screening the target standby.

Specifically, based on the monitored working states of the database standby machines, the database management platform determines whether each database standby machine has a fault. It can be appreciated that if one database backup machine fails, multiple attribute data of the database backup machine may be obviously abnormal (for example, the data transmission speed is too slow, communication cannot be established, etc.), so that the database backup machine can be determined to fail.

Further, the database management platform uses the database backup machine which does not have a fault as a target backup machine.

The embodiment has the advantages that by taking whether the fault is used as the standard for screening the target standby machine, the database standby machine with the fault is prevented from being read by the service invalidity, and the availability of the database cluster is ensured.

determining the replication delay of each database standby machine for data replication from the database host machine based on the working state of each database standby machine;

In this embodiment, the database management platform uses replication delay as a standard for screening target standby machines.

Specifically, based on the monitored working states of the database standby machines, the database management platform determines the replication delay of data replication of each database standby machine from the database host machine. The database management platform can determine the replication delay of the database backup machine according to the time stamp of the update data of the database host machine and the time stamp of the replication of the database backup machine to the same data. For example: the image data a is updated in the database host with a time stamp of T0. After the database host updates the image data a, each database backup machine copies the image data a from the database host to be backed up synchronously with the database host. If the time stamp of copying the database backup 1 to the image data a is T1 and the time stamp of copying the database backup 2 to the image data a is T2, the copy delay of the database backup 1 is (T1-T0) and the copy delay of the database backup 2 is (T2-T0).

Further, the database management platform takes the database standby machine with the replication delay lower than a preset time threshold as a target standby machine.

The advantage of this embodiment is that by taking the replication delay as a criterion for screening the target standby, it is ensured that the service can read the latest data in the database cluster.

In an embodiment, updating, in a domain name resolution server, a target IP address corresponding to a read-only domain name of the database cluster according to the IP address of each target standby machine includes:

In this embodiment, the database management platform updates the target IP address based on the compliance of the target standby machine with the service requirement.

Specifically, based on the monitored working states of the database standby machines, the database management platform determines the compliance of each target standby machine with the service requirements. The process of determining the conformity is equivalent to quantization of the process of screening the target standby machine, that is, the basic service requirement serving as a measurement standard is quantized according to parameters thereof (for example, quantized according to a speed parameter or quantized according to a throughput parameter) in advance, so as to obtain a reference value of the service requirement; according to the mode of quantifying the basic service requirement, quantifying the working state of the target standby machine according to the parameters of the target standby machine to obtain the expression value of the target standby machine; and obtaining the compliance of the target standby machine and the service requirement according to the relative height of the representation value and the reference value or the position of the representation value in a preset interval taking the reference value as an interval boundary.

The higher the conformity is, the more the target standby meets the service requirement, and the more the target standby should be sequenced. Further, the database management platform updates the IP address of the target standby machine with the first order as the target IP address in the domain name resolution server.

Thus, after the service sends the read-only domain name, the domain name resolution server resolves the read-only domain name to resolve the IP address of the target standby machine with the forefront ordering. Therefore, the business read-only operates the target standby machine with the forefront ordering, and the database cluster where the target standby machine with the forefront ordering is located is read-only operated.

For example: if the service requirement is related to the read-only operation speed, the speed of the service read-only operation database cluster is required to be as high as possible. The compliance of each target standby with the business requirements can be determined by quantifying the replication delay.

The preset time threshold for the copy delay is 30ms. The database backup machine with the replication delay higher than or equal to 30ms is removed; a database backup with a replication delay below 30ms is taken as the target backup.

Further, the target standby with the replication delay lower than 30ms and higher than or equal to 20ms is determined to be 80% in accordance with the service demand; a target standby with a copy delay of less than 20ms and more than or equal to 10ms is determined to have a degree of compliance with the service requirement of 90%; the target standby with a replication delay below 10ms is determined to be 100% compliant with the traffic demand.

If the IP address of the target standby machine 1 in one database cluster is IP1, the coincidence degree with the service requirement is 100%; the IP address of the target standby machine 2 is IP2, and the coincidence degree with the service requirement is 80%; the IP address of the target standby 3 is IP3, and the compliance with the service requirement is 90%. The target standby machines are sequentially sequenced to obtain a target standby machine 1, a target standby machine 3 and a target standby machine 2, and the target IP address corresponding to the read-only domain name is updated to be IP1 in the domain name resolution server. Therefore, after the service sends the read-only domain name of the database cluster, the domain name resolution server resolves the read-only domain name to obtain the IP1, and then the service reads only the operation target standby machine 1 to realize read-only operation of the database cluster.

The embodiment has the advantage that the target standby machines of the target IP address are ensured to be most in line with the service requirement by sequencing the target standby machines according to the coincidence degree so as to update the target IP address.

In one embodiment, the method further comprises:

responding to the fault of the standby machine of the current read-only operation of the service, removing the faulty standby machine from the target standby machine, and updating the target IP address corresponding to the read-only domain name of the database cluster in the domain name resolution server according to the IP address of each target standby machine;

In this embodiment, if the standby machine that is currently in read-only operation fails, the database management platform rejects the standby machine from the target standby machine, and then updates the target IP address corresponding to the read-only domain name in the domain name resolution server again according to the IP address of the target standby machine.

Further, after the service resends the read-only domain name, the domain name resolution server resolves the read-only domain name again, so that an updated target IP address can be resolved; and after the service receives the updated target IP address, the service reads only the target standby machine of the updated target IP address, and further continues to read only the database cluster.

For example: sequentially sequencing target standby machines in a database cluster to obtain a target standby machine 1, a target standby machine 3 and a target standby machine 2; the IP address of the target standby 1 is IP1, the IP address of the target standby 2 is IP2, and the IP address of the target standby 3 is IP3.

The read-only domain name of the database cluster in the domain name resolution server corresponds to IP1. Thus, the business read-only operates the target standby machine 1 to realize read-only operation database clusters.

If the target standby machine 1 fails in the process of operating the target standby machine 1 through service read only, the database management platform rejects the target standby machine 1. The target standby machines which remain after the rejection are the target standby machine 3 and the target standby machine 2 in sequence. And the database management platform updates the IP address corresponding to the read-only domain name of the database cluster in the domain name resolution server into IP3. Further, after the service resends the read-only domain name, the domain name resolution server resolves the IP3; after the service receives the IP3, the target standby machine 3 is read only, and then the database cluster is continuously read only.

An advantage of this embodiment is that by timely troubleshooting, downtime of the database cluster is reduced, ensuring high availability of the database cluster.

In one embodiment, the method further comprises:

and receiving a configuration request for the read-only domain name through a configuration page, and configuring the read-only domain name of the requested configuration according to the configuration request.

In this embodiment, the database management platform provides a configuration page for configuring the read-only domain name. Wherein configuring the read-only domain name comprises: view, add, modify read-only domain names.

The user can manually operate the configuration of the read-only domain name on the configuration page, and the manual operation of the user triggers the generation and the transmission of the configuration request. Thus, through the configuration page, the database management platform receives a configuration request for the read-only domain name, and further configures the read-only domain name (i.e., the read-only domain name manually operated by the user) requested to be configured according to the configuration request.

The embodiment has the advantage that the configuration page is provided, so that a user can flexibly configure the read-only domain name.

Fig. 4 illustrates a data management apparatus of a database cluster according to an embodiment of the present disclosure, the apparatus including:

a monitoring module 310 configured to monitor an operating state of each database backup machine, wherein the database backup machines form the same database cluster;

the screening module 320 is configured to screen out a target standby machine meeting a preset service requirement from the database standby machines based on the working states of the database standby machines;

the updating module 330 is configured to update, in a domain name resolution server, a target IP address corresponding to a read-only domain name of the database cluster according to the IP address of each target standby machine, so that the read-only domain name sent by the service is resolved by the domain name resolution server, so that the service reads only the target standby machine with the target IP address, where the read-only domain name is used for the service to read only the database cluster.

The data management electronics 40 of a database cluster according to an embodiment of the present disclosure are described below with reference to fig. 5. The data management electronics 40 of the database cluster shown in fig. 5 is only one example and should not be construed as limiting the functionality and scope of use of the disclosed embodiments.

As shown in fig. 5, the data management electronics 40 of the database cluster are in the form of general purpose computing devices. The components of the data management electronics 40 of the database cluster may include, but are not limited to: the at least one processing unit 410, the at least one memory unit 420, and a bus 430 connecting the various system components, including the memory unit 420 and the processing unit 410.

Wherein the storage unit stores program code that is executable by the processing unit 410 such that the processing unit 410 performs the steps according to various exemplary embodiments of the present invention described in the description of the exemplary methods described above in this specification. For example, the processing unit 410 may perform the various steps as shown in fig. 2.

The storage unit 420 may include readable media in the form of volatile storage units, such as Random Access Memory (RAM) 4201 and/or cache memory 4202, and may further include Read Only Memory (ROM) 4203.

The storage unit 420 may also include a program/utility 4204 having a set (at least one) of program modules 4205, such program modules 4205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment.

Bus 430 may be a local bus representing one or more of several types of bus structures including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or using any of a variety of bus architectures.

The data management electronic device 40 of the database cluster may also communicate with one or more external devices 500 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the data management electronic device 40 of the database cluster, and/or with any device (e.g., router, modem, etc.) that enables the data management electronic device 40 of the database cluster to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 450. An input/output (I/O) interface 450 is connected to the display unit 440. Also, the data management electronic device 40 of the database cluster may also communicate with one or more networks, such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the internet, through the network adapter 460. As shown, the network adapter 460 communicates with the other modules of the data management electronic device 40 of the database cluster via the bus 430. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with the data management electronics 40 of the database cluster, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.

From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Thus, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.) or on a network, including several instructions to cause a computing device (may be a personal computer, a server, a terminal device, or a network device, etc.) to perform the method according to the embodiments of the present disclosure.

In an exemplary embodiment of the present disclosure, there is also provided a computer-readable storage medium having stored thereon computer-readable instructions, which, when executed by a processor of a computer, cause the computer to perform the method described in the method embodiment section above.

According to an embodiment of the present disclosure, there is also provided a program product for implementing the method in the above method embodiments, which may employ a portable compact disc read only memory (CD-ROM) and comprise program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited thereto, and in this document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium can be, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium would include the following: an electrical connection having one or more wires, a portable disk, a hard disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

The computer readable signal medium may include a data signal propagated in baseband or as part of a carrier wave with readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A readable signal medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

It should be noted that although in the above detailed description several modules or units of a device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit in accordance with embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into a plurality of modules or units to be embodied.

Furthermore, although the steps of the methods in the present disclosure are depicted in a particular order in the drawings, this does not require or imply that the steps must be performed in that particular order or that all illustrated steps be performed in order to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step to perform, and/or one step decomposed into multiple steps to perform, etc.

From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Thus, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.) or on a network, including several instructions to cause a computing device (may be a personal computer, a server, a mobile terminal, or a network device, etc.) to perform the method according to the embodiments of the present disclosure.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

Claims

1. A method of data management for a database cluster, the method comprising:

determining the coincidence degree of each target standby machine and the preset service requirement based on the working state of each target standby machine;

and sequencing the target standby machines based on the coincidence degree, and updating the IP address of the target standby machine with the forefront sequencing in a domain name resolution server by taking the IP address of the target standby machine with the forefront sequencing as the target IP address so as to resolve a read-only domain name sent by a service through the domain name resolution server, so that the service can read-only operate the target standby machines with the target IP address.

2. The method of claim 1, wherein a proxy service is pre-configured for each of the database backup machines, and wherein monitoring the operating state of each of the database backup machines comprises:

3. The method of claim 1, wherein the screening the target backup machine from the database backup machines that meets the preset service requirement based on the working state of each database backup machine comprises:

4. The method of claim 1, wherein the screening the target backup machine from the database backup machines that meets the preset service requirement based on the working state of each database backup machine comprises:

5. The method according to claim 1, wherein the method further comprises:

6. The method according to claim 1, wherein the method further comprises:

7. A data management apparatus for a database cluster, the apparatus comprising:

the updating module is configured to determine the compliance of each target standby machine with the preset service requirement based on the working state of each target standby machine; and sequencing the target standby machines based on the coincidence degree, and updating the IP address of the target standby machine with the forefront sequencing in a domain name resolution server by taking the IP address of the target standby machine as the target IP address so as to resolve a read-only domain name sent by a service through the domain name resolution server, so that the service can read-only operate the target standby machines with the target IP address, wherein the read-only domain name is used for the service to read-only operate the database cluster.

8. A data management electronic device of a database cluster, comprising:

a memory storing computer readable instructions;

a processor reading computer readable instructions stored in a memory to perform the method of any one of claims 1-6.

9. A computer readable storage medium having stored thereon computer readable instructions which, when executed by a processor of a computer, cause the computer to perform the method of any of claims 1-6.