CN105574195A - Method and device for judging whether to perform offline recycling on database or not - Google Patents

Abstract

The present invention provides a method and device for judging whether a database should be offline and recycled. The method includes: obtaining the type of the database as a judging object; judging whether the type of the database is a relational type; if so, obtaining the operation status information of the database; Based on the running status information, it is judged according to the corresponding predetermined policy whether the database meets the offline recovery conditions. The technical solution provided by the present invention can automatically obtain the operation status information of each relational database, and automatically judge whether a relational database needs to be recycled offline, so that resources can be recovered in time without any manual operation by the user, which greatly improves the resource utilization.

Description

Method and device for judging whether a database should be offline and recovered

technical field

The invention relates to the technical field of computers, in particular to a method and a device for judging whether a database should be recovered offline.

Background technique

In modern computer technology, the application of database is a very important technology. In the current Internet era, the application of database is more and more extensive. Whether it is various websites, platforms or various application software, it is necessary to set up various various databases.

Broadly speaking, databases can be divided into relational databases and non-relational databases. The resources of the database are limited, and they need to be used repeatedly. At present, when judging whether to recycle a certain database offline, it needs to be done manually. This will lead to untimely resource recovery. It will bring a lot of workload to the user.

Contents of the invention

The present invention proposes a method and device for judging whether a database should be taken offline for recovery to overcome the above problems or at least partly solve the above problems.

According to one aspect of the present invention, there is provided a method for judging whether the database should be recovered offline, including:

Obtain the type of the database as the judgment object;

Determine whether the type of the database is relational;

If so, obtain the running status information of the database;

Based on the running state information, it is judged according to a corresponding predetermined policy whether the database meets the offline recovery condition.

Optionally, the running status information includes at least one of the following:

The running state of the process of the database;

the connectivity status of the instance of the database;

The startup time of the instance of the database;

Whether there is a business library in the instance of the database, and whether there is a business table in the business library;

The last data modification time of the business table in the instance of the database;

Whether the proxy server used by the database is mounted under the Linux virtual server.

Optionally, judging whether the database meets the offline recovery condition according to a corresponding predetermined strategy includes at least one of the following:

Judging whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, if so, then judging that the database meets the offline recovery conditions;

Judging whether the process of the database is in a running state, if not, judging that the database meets the conditions for offline recovery;

Judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, then judging that the database meets the off-line recovery condition;

Judging whether the database starts exceeding the first time threshold, but does not establish a business library or business table, if so, then judging that the database meets the off-line recovery condition;

Judging whether the database starts exceeding the first time threshold, establishes a business library and a business table, and the last data modification time of the business table exceeds a second time threshold, if so, then judges that the database is within a predetermined time period Whether there is a statement access, if not, it is judged that the database meets the offline recovery condition.

Optionally, the acquiring the running status information of the database includes:

The script for obtaining the running state information of the database is executed regularly, and the running state information of the database is obtained and saved.

Optionally, if it is judged that the database meets the conditions for offline recovery, the description also includes:

Sending an offline recovery prompt to the administrator of the database according to a preset contact method, wherein the offline recovery prompt includes the database identifier and operation status information meeting the offline recovery conditions.

Optionally, the relational database includes: MySQL database.

According to another aspect of the present invention, there is also provided a device for judging whether the database should be recovered offline, including:

A type acquisition module, configured to acquire the type of the database as the judgment object;

A type judging module, configured to judge whether the type of the database is relational;

An information acquisition module, configured to acquire the operation status information of the database when the judgment result of the type judgment module is yes;

The recycling judging module is configured to judge whether the database meets the off-line recycling condition according to the corresponding predetermined strategy based on the running state information.

Optionally, the running status information includes at least one of the following:

The running state of the process of the database;

the connectivity status of the instance of the database;

The startup time of the instance of the database;

Whether there is a business library in the instance of the database, and whether there is a business table in the business library;

The last data modification time of the business table in the instance of the database;

Whether the proxy server used by the database is mounted under the Linux virtual server.

Optionally, the recycling judgment module includes:

The first judging unit is used to judge whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, and if so, judging that the database meets the off-line recovery condition;

The second judging unit is used for judging whether the process of the database is running, if not, judging that the database meets the off-line recovery condition;

The third judging unit is used for judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, judging that the database meets the off-line recycling condition;

The fourth judging unit is used to judge whether the database has been activated for more than the first time threshold, but no business database or business table has been established, and if so, judging that the database meets the conditions for offline recovery; and/or

The fifth judging unit is used for judging whether the database starts exceeding the first time threshold, the business database and the business table are established, and the last data modification time of the business table exceeds the second time threshold, and if so, judging Whether the database is accessed by a statement within a predetermined period of time, and if not, it is judged that the database meets the offline recovery condition.

Optionally, the information acquisition module includes:

The timing acquisition unit is configured to regularly execute the script for acquiring the database operation status information, acquire and store the database operation status information.

Optionally, the above-mentioned device also includes:

The recovery prompt module is used to send an offline recovery prompt to the administrator of the database according to the preset contact method when the recovery judging module judges that the database meets the conditions for offline recovery, wherein the offline recovery prompt includes The identification of the database and the running status information meeting the offline recycling conditions.

Optionally, the relational database includes: MySQL database.

The technical solution provided by the invention can automatically obtain the running status information of each relational database, and automatically judge whether a relational database needs to be recycled offline, so that resources can be recovered in time without any manual operation by the user, which greatly improves the resource utilization.

The above description is only an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention, it can be implemented according to the contents of the description, and in order to make the above and other purposes, features and advantages of the present invention more obvious and understandable , the specific embodiments of the present invention are enumerated below.

Those skilled in the art will be more aware of the above and other objects, advantages and features of the present invention according to the following detailed description of specific embodiments of the present invention in conjunction with the accompanying drawings.

Description of drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiment. The drawings are only for the purpose of illustrating a preferred embodiment and are not to be considered as limiting the invention. Also throughout the drawings, the same reference numerals are used to designate the same components. In the attached picture:

Fig. 1 is a schematic flow chart of a method for judging whether a database should be offline and recovered according to an embodiment of the present invention;

Fig. 2 is a schematic flow chart of a method for judging whether a database should be offline and recovered according to another embodiment of the present invention;

Fig. 3 is a schematic flowchart of a method for judging whether a database should be offline and recovered according to yet another embodiment of the present invention

Fig. 4 is a structural block diagram of a device for judging whether a database should be offline and recycled according to an embodiment of the present invention;

Fig. 5 is a structural block diagram of an apparatus for judging whether a database should be taken offline for recovery according to another embodiment of the present invention.

detailed description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art. It should be noted that, on the premise of no conflict, the embodiments of the present invention and the technical features in the embodiments may be combined with each other.

FIG. 1 is a schematic flowchart of a method for judging whether a database should be taken offline for recovery according to an embodiment of the present invention. As shown in Figure 1, the above methods may include:

Step S102, acquiring the type of the database to be judged;

Step S104, judging whether the type of the database is relational;

Step S106, if yes, obtain the running status information of the database;

Step S108, based on the running status information, judge whether the database meets the condition for offline recycling according to the corresponding predetermined strategy.

The method provided in this embodiment will automatically obtain the running status information of each relational database, and automatically judge whether a relational database needs to be recycled offline, so that resources can be recovered in a timely manner without any manual operation by the user, which greatly improves the resource utilization.

In the method provided in this embodiment, in order to more efficiently and accurately judge whether a relational database can be recycled offline, it is necessary to reasonably set which running status information of the data needs to be obtained and judge whether the database can be offline based on the running status information. Strategies for line recycling. In an embodiment of the present invention, the above-mentioned running status information may include:

The running status of the database process;

The connectivity status of the instance of the database;

The startup time of the database instance;

Whether there is a business library in the database instance, and whether there is a business table in the business library;

The last data modification time of the business table in the database instance;

Whether the proxy server used by the database is mounted under the Linux virtual server.

This embodiment lists some of the most typical running status information that can be used to judge whether a relational database can be recycled offline. Based on these running status information, it can basically cover all typical relational databases that need to be recycled offline. Operating status. Of course, during specific implementation, one or more pieces of running state information may be selected to be acquired or new running state information may be added according to different needs, which is not specifically limited in the present invention.

In an embodiment of the present invention, corresponding to the above running status information, the above step S108 may include:

1. Determine whether the database does not have records on the business cloud platform, but there is a data directory locally on the server or its instance has been started. If so, determine that the database meets the conditions for offline recovery;

2. Determine whether the process of the database is running, if not, determine that the database meets the conditions for offline recovery;

3. Determine whether the proxy server used by the database is mounted under the Linux virtual server, if not, determine that the database meets the conditions for offline recovery;

4. Judging whether the database startup exceeds the threshold for the first time, but no business database or business table has been established. If so, it is judged that the database meets the offline recovery conditions;

5. Judging whether the database startup exceeds the first time threshold, the business library and business table are established, and the last data modification time of the business table exceeds the second time threshold. If so, judge whether the database has statement access within the predetermined time period. If If not, it is judged that the database meets the offline recovery condition.

In this embodiment, if the database cannot be found on the business cloud platform, but there is a data directory locally on the server or the instance has been started, it indicates that the database has not been actually used and needs to be deleted, that is, offline and recycled; the process of the database is not In the running state, the instance is no longer used, but there are legacy files, so it needs to be deleted; if the database uses a proxy server (proxy, also known as proxy, network proxy), but it is not mounted on the Linux virtual server (LinuxVirtualServer, referred to as lvs ), it means that no online service is provided and needs to be deleted; if the database startup exceeds the first time threshold, for example, 60 days, but there is still no business library/table, it is overdue and unused and needs to be deleted; if the database startup exceeds the first time threshold Time threshold (60 days), there is a business library/table, and the last data modification time exceeds the second time threshold, such as 60 days (adjustable), then it is necessary to capture whether it currently has statement access, or within a certain period of time Whether there is statement access, if not, it indicates that its utility rate is very low, you can consider deleting it, in this case, in order to ensure that it will not be recycled by mistake, you can also confirm with the business personnel again, if it is confirmed that it is no longer used, you can delete it. The above-mentioned policies correspond to the above-mentioned running status information, and based on these policies, it can be efficiently and accurately judged whether a relational database can be recycled.

For relational data, many methods can be used to obtain the running state information, and the method of executing a special script is preferred in the present invention. In an embodiment of the present invention, the above step S104 may include: periodically executing a script for acquiring the running status information of the database, and acquiring and saving the running status information of the database.

Using a dedicated script to obtain the running status information of the database is simple to implement, occupies less resources, and has relatively high execution efficiency, which is an optimal solution.

In one embodiment of the present invention, as shown in Figure 2, when judging that the database meets the off-line recycling conditions, the above method may also include:

Step S110 , according to the preset contact method, send an offline recovery prompt to the administrator of the database, wherein the offline recovery prompt includes the identification of the database and the operation status information meeting the offline recovery conditions.

Based on the solution provided in this embodiment, the database administrator can be provided with complete right to know, so that the administrator can know the execution status of the automatic offline recovery of the database in real time. At the same time, it also enables the administrator to perform manual intervention in a timely manner, because in reality, it is very likely that a certain database meets the conditions for offline recovery, but the administrator still does not perform offline recovery for some special considerations , the solution provided by this embodiment provides a lot of autonomy for the administrator.

MySQL is a typical relational database management system, developed by the Swedish MySQLAB company, which currently belongs to Oracle. MySQL is the most popular relational database management system. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System, relational database management system) application software. MySQL is a relational database management system. Relational databases store data in different tables instead of putting all the data in one big warehouse, which increases speed and improves flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual authorization policy. It is divided into community edition and commercial edition. Due to its small size, fast speed, low overall cost of ownership, especially the open source feature, MySQL is generally chosen as the website database for the development of small and medium-sized websites. .

The MySQL database uses SQL (Structured Query Language, Structured Query Language), which is a special-purpose programming language, a database query and programming language for accessing data and querying, updating and managing relational database systems; it is also The extension for database script files.

Structured Query Language is a high-level non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured query language statements can be nested, which makes it extremely flexible and powerful.

The technical solutions provided by the above-mentioned embodiments of the present invention can be well applied to MySQL databases, and the statements involved in the above-mentioned embodiments mainly include SQL statements.

The above scheme is described below through a specific embodiment. FIG. 3 is a schematic flow diagram of a method for judging whether the database should be offline and recovered according to another embodiment of the present invention. As shown in FIG. 3 , the method may include:

Step S302, determine the MySQL database as the judgment object, and obtain the type of the MySQL database, which is a relational database;

Step S304, judging whether the type of the MySQL database as the judging object is a relational type, and the judging result is yes;

Step S306, regularly execute the script for obtaining the running state information of the MySQL database, obtain and save the running state information of the database, including: the running state of the process of the MySQL database; the connection state of the instance of the MySQL database; the instance of the MySQL database The startup time; whether there is a business library in the MySQL database instance, whether there is a business table in the business library; the last data modification time of the business table in the MySQL database instance; whether the proxy server used by the MySQL database is mounted under the Linux virtual server;

Step S308, judging whether the MySQL database does not have records on the business cloud platform, but there is a data directory locally on the server or its instance has been started, if yes, then execute step S318, if no, then execute step S310;

Step S310, judge whether the process of MySQL database is in running state, if not, then execute step S318, if yes, then execute step S312;

Step S312, judging whether the proxy of the MySQL database is mounted under lvs, if not, then execute step S318, if yes, then execute step S314;

Step S314, judging whether the MySQL database has been started for more than 60 days, but no business storehouse or business table has been established, if so, then execute step S318, if otherwise execute step S316;

Step S316, judging whether the MySQL database has been started for more than 60 days, the business database and the business table have been set up and the last data modification time of the business table has exceeded 60 days, if yes, then further judge whether the MySQL database has SQL statement access within the predetermined time period, If no, then execute step S318, if yes, then return to step S302;

Step S318, determining that the MySQL database meets the conditions for offline recycling;

Step S320, sending an offline recycling reminder to the administrator of the MySQL database by text message, email or other similar means, wherein the offline recycling reminder includes the logo of the MySQL database and the running status information meeting the offline recycling conditions;

Step S322, on the premise that the administrator does not issue a command not to allow recovery, the MySQL database is recovered offline.

When specifically implementing the solution provided by this embodiment, the server can locally execute the script at regular intervals every Sunday morning to automatically analyze all database port instances on the local machine, and record the analysis results to a local file. The script can be executed regularly on the management machine every Sunday afternoon, polling and accessing all the database instances managed by the database administrator (Database Administrator, referred to as DBA) to obtain the analysis results, and then enter the specific database. By logging in to a specific web page, the DBA will automatically execute specific SQL in the background to display the analysis results, and the entire analysis process does not require manual access.

Corresponding to the methods provided in the foregoing embodiments, the embodiment of the present invention also provides a corresponding device for judging whether the database should be taken offline for recovery. Fig. 4 is a structural block diagram of an apparatus for judging whether a database should be taken offline for recovery according to an embodiment of the present invention. As shown in Figure 4, the device may include:

The type acquisition module 10 is used to acquire the type of the database as the judgment object;

Type judging module 20, for judging whether the type of database is relational;

The information acquisition module 30 is used to obtain the running status information of the database when the judgment result of the type judgment module 20 is yes;

The recycling judging module 40 is configured to judge whether the database meets the off-line recycling condition according to the corresponding predetermined strategy based on the running state information.

The device provided in this embodiment will automatically obtain the running status information of each relational database, and automatically judge whether a relational database needs to be recycled offline, so that resources can be recovered in a timely manner without any manual operation by the user, which greatly improves the resource utilization.

In an embodiment of the present invention, the running status information may include at least one of the following:

The running status of the database process;

The connectivity status of the instance of the database;

The startup time of the database instance;

Whether there is a business library in the database instance, and whether there is a business table in the business library;

The last data modification time of the business table in the database instance;

Whether the proxy server used by the database is mounted under the Linux virtual server.

This embodiment lists some of the most typical running status information that can be used to judge whether a relational database can be recycled offline. Based on these running status information, it can basically cover all typical relational databases that need to be recycled offline. Operating status. Of course, during specific implementation, one or more pieces of running state information may be selected to be acquired or new running state information may be added according to different needs, which is not specifically limited in the present invention.

In one embodiment of the present invention, as shown in FIG. 5, the recovery judging module 40 may include:

The first judging unit 41 is used to judge whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, and if so, it is judged that the database meets the off-line recovery condition;

The second judging unit 42 is used to judge whether the process of the database is in the running state, if not, then judging that the database meets the off-line recovery condition;

The third judging unit 43 is used to judge whether the proxy server used by the database is mounted under the Linux virtual server, if not, then judging that the database meets the off-line recovery condition;

The fourth judging unit 44 is used to judge whether the database starts exceeding the first time threshold, but no business library or business table is established, if so, judging that the database meets the off-line recovery condition; and/or

The fifth judging unit 45 is used to judge whether the database has been started beyond the first time threshold, the business database and the business table have been established and the last data modification time of the business table has exceeded the second time threshold, if so, then judge that the database is within the predetermined time length Whether there is statement access, if not, it is judged that the database meets the conditions for offline recycling.

Corresponding to the above-mentioned typical running state information, based on each unit of the recycling judging module 40 provided in this embodiment, it is possible to efficiently and accurately judge whether a relational database can be recycled.

In one embodiment of the present invention, as shown in Figure 5, the information acquisition module 30 may include:

The timing acquisition unit 31 is configured to regularly execute a script for acquiring database operation status information, and acquire and save the database operation status information.

In the solution provided in this embodiment, the timing acquisition unit 31 belonging to the information acquisition module 30 acquires the running status information of the database using a dedicated script, which is simple to implement, occupies less resources, and has relatively high execution efficiency.

In one embodiment of the present invention, as shown in FIG. 5, the above-mentioned device may further include:

The recycling reminder module 50 is used to send an offline recycling reminder to the administrator of the database according to the preset contact method when the recycling judging module 40 judges that the database meets the offline recycling conditions, wherein the offline recycling reminder includes the identification of the database and meets the following requirements. Running status information for the line recycling condition.

In the solution provided in this embodiment, the recovery prompt module 50 provides the database administrator with complete right to know, so that the administrator can know the execution status of the automatic offline recovery of the database in real time. At the same time, it also enables the administrator to perform manual intervention in a timely manner, because in reality, it is very likely that a certain database meets the conditions for offline recovery, but the administrator still does not perform offline recovery for some special considerations , the solution provided by this embodiment provides a great autonomy for the administrator.

Preferably, in each of the above embodiments, the designed relational database may be a MySQL database, and the statements involved may be SQL statements.

The solution provided by the embodiment of the present invention will automatically obtain the operation status information of each relational database, and automatically judge whether a relational database needs to be taken offline for recycling. At the same time, the judgment result will be sent to the database administrator in a timely manner by reservation. Therefore, resources can be recovered in a timely manner without any manual operation by the user, which greatly improves the utilization rate of resources. Under special circumstances, the database administrator can also prevent the offline recovery operation of a specific database, providing administrators with great autonomy.

In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure the understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, in order to streamline this disclosure and to facilitate an understanding of one or more of the various inventive aspects, various features of the invention are sometimes grouped together in a single embodiment, figure, or its description. This method of disclosure, however, is not to be interpreted as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the Detailed Description are hereby expressly incorporated into this Detailed Description, with each claim standing on its own as a separate embodiment of this invention.

Those skilled in the art can understand that the modules in the device in the embodiment can be adaptively changed and arranged in one or more devices different from the embodiment. Modules or units or components in the embodiments may be combined into one module or unit or component, and furthermore may be divided into a plurality of sub-modules or sub-units or sub-assemblies. All features disclosed in this specification (including accompanying claims, abstract and drawings) and any method or method so disclosed may be used in any combination, except that at least some of such features and/or processes or units are mutually exclusive. All processes or units of equipment are combined. Each feature disclosed in this specification (including accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will understand that although some embodiments described herein include some features included in other embodiments but not others, combinations of features from different embodiments are meant to be within the scope of the invention. and form different embodiments. For example, in the claims, any one of the claimed embodiments can be used in any combination.

The various component embodiments of the present invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art should understand that a microprocessor or a digital signal processor (DSP) can be used in practice to implement some or all of the components in the device for judging whether the database should be offline for recycling according to an embodiment of the present invention. Full functionality. The present invention can also be implemented as an apparatus or an apparatus program (for example, a computer program and a computer program product) for performing a part or all of the methods described herein. Such a program for realizing the present invention may be stored on a computer-readable medium, or may be in the form of one or more signals. Such a signal may be downloaded from an Internet site, or provided on a carrier signal, or provided in any other form.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In a unit claim enumerating several means, several of these means can be embodied by one and the same item of hardware. The use of the words first, second, and third, etc. does not indicate any order. These words can be interpreted as names.

So far, those skilled in the art should appreciate that, although a number of exemplary embodiments of the present invention have been shown and described in detail herein, without departing from the spirit and scope of the present invention, the disclosed embodiments of the present invention can still be used. Many other variations or modifications consistent with the principles of the invention are directly identified or derived from the content. Accordingly, the scope of the present invention should be understood and deemed to cover all such other variations or modifications.

According to one aspect of the present invention, there is provided A1. A method for judging whether the database should be recovered offline, including:

Obtain the type of the database as the judgment object;

Determine whether the type of the database is relational;

If so, obtain the running status information of the database;

Based on the running state information, it is judged according to a corresponding predetermined policy whether the database meets the offline recovery condition.

A2. The method according to A1, wherein the running status information includes at least one of the following:

The running state of the process of the database;

the connectivity status of the instance of the database;

The startup time of the instance of the database;

Whether there is a business library in the instance of the database, and whether there is a business table in the business library;

The last data modification time of the business table in the instance of the database;

Whether the proxy server used by the database is mounted under the Linux virtual server.

A3. The method according to A2, wherein, based on the operation state information, judging whether the database meets the offline recovery condition according to the corresponding predetermined strategy includes at least one of the following:

Judging whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, if so, then judging that the database meets the offline recovery conditions;

Judging whether the process of the database is in a running state, if not, judging that the database meets the conditions for offline recovery;

Judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, then judging that the database meets the off-line recovery condition;

Judging whether the database starts exceeding the first time threshold, but does not establish a business library or business table, if so, then judging that the database meets the off-line recovery condition;

Judging whether the database starts exceeding the first time threshold, establishes a business library and a business table, and the last data modification time of the business table exceeds a second time threshold, if so, then judges that the database is within a predetermined time period Whether there is a statement access, if not, it is judged that the database meets the offline recovery condition.

A4. The method according to A1, wherein said obtaining the running status information of said database comprises:

The script for obtaining the running state information of the database is executed regularly, and the running state information of the database is obtained and saved.

A5. The method according to any one of A1-A4, wherein, if it is judged that the database meets the conditions for offline recovery, the method further includes:

Sending an offline recovery prompt to the administrator of the database according to a preset contact method, wherein the offline recovery prompt includes the database identifier and operation status information meeting the offline recovery conditions.

A6. The method according to any one of A1-A4, wherein the relational database comprises: a MySQL database.

According to another aspect of the present invention, there is also provided B7. A device for judging whether the database should be recovered offline, including:

A type acquisition module, configured to acquire the type of the database as the judgment object;

A type judging module, configured to judge whether the type of the database is relational;

An information acquisition module, configured to acquire the operation status information of the database when the judgment result of the type judgment module is yes;

The recycling judging module is configured to judge whether the database meets the off-line recycling condition according to the corresponding predetermined strategy based on the running status information.

B8. The device according to B7, wherein the operating status information includes at least one of the following:

The running state of the process of the database;

the connectivity status of the instance of the database;

The startup time of the instance of the database;

Whether there is a business library in the instance of the database, and whether there is a business table in the business library;

The last data modification time of the business table in the instance of the database;

Whether the proxy server used by the database is mounted under the Linux virtual server.

B9. The device according to B8, wherein the recovery judgment module includes:

The first judging unit is used to judge whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, and if so, judging that the database meets the off-line recovery condition;

The second judging unit is used for judging whether the process of the database is running, if not, judging that the database meets the off-line recovery condition;

The third judging unit is used for judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, judging that the database meets the off-line recycling condition;

The fourth judging unit is used to judge whether the database has been activated for more than the first time threshold, but no business database or business table has been established, and if so, judging that the database meets the conditions for offline recovery; and/or

The fifth judging unit is used for judging whether the database starts exceeding the first time threshold, the business database and the business table are established, and the last data modification time of the business table exceeds the second time threshold, and if so, judging Whether the database is accessed by a statement within a predetermined period of time, and if not, it is judged that the database meets the offline recovery condition.

B10. The device according to B7, wherein the information acquisition module includes:

The timing acquisition unit is configured to regularly execute the script for acquiring the database operation status information, acquire and store the database operation status information.

B11. The device according to any one of B7-B10, further comprising:

The recovery prompt module is used to send an offline recovery prompt to the administrator of the database according to the preset contact method when the recovery judging module judges that the database meets the conditions for offline recovery, wherein the offline recovery prompt includes The identification of the database and the running status information meeting the offline recycling conditions.

B12. The device according to any one of B7-B10, wherein the relational database comprises: a MySQL database.

Claims (10)

1. A method for judging whether a database should be taken offline for recycling, comprising: Obtain the type of the database as the judgment object; Determine whether the type of the database is relational; If so, obtain the running status information of the database; Based on the running state information, it is judged according to a corresponding predetermined policy whether the database meets the offline recovery condition. 2. The method according to claim 1, wherein the operating status information includes at least one of the following: The running state of the process of the database; the connectivity status of the instance of the database; The startup time of the instance of the database; Whether there is a business library in the instance of the database, and whether there is a business table in the business library; The last data modification time of the business table in the instance of the database; Whether the proxy server used by the database is mounted under the Linux virtual server. 3. The method according to claim 2, wherein said judging whether said database meets the off-line recycling condition according to a corresponding predetermined strategy based on said running state information comprises at least one of the following: Judging whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, if so, then judging that the database meets the offline recovery conditions; Judging whether the process of the database is in a running state, if not, judging that the database meets the conditions for offline recovery; Judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, then judging that the database meets the off-line recovery condition; Judging whether the database starts exceeding the first time threshold, but does not establish a business library or business table, if so, then judging that the database meets the off-line recovery condition; Judging whether the database starts exceeding the first time threshold, establishes a business library and a business table, and the last data modification time of the business table exceeds a second time threshold, if so, then judges that the database is within a predetermined time period Whether there is a statement access, if not, it is judged that the database meets the offline recovery condition. 4. The method according to claim 1, wherein said obtaining the running status information of said database comprises: The script for obtaining the running state information of the database is executed regularly, and the running state information of the database is obtained and saved. 5. The method according to any one of claims 1-4, wherein, if it is judged that the database meets the conditions for offline recovery, the method further comprises: Sending an offline recovery prompt to the administrator of the database according to a preset contact method, wherein the offline recovery prompt includes the database identifier and operation status information meeting the offline recovery conditions. 6. The method according to any one of claims 1-4, wherein the relational database comprises: a MySQL database. 7. A device for judging whether the database should be taken offline for recycling, comprising: A type acquisition module, configured to acquire the type of the database as the judgment object; A type judging module, configured to judge whether the type of the database is relational; An information acquisition module, configured to acquire the operation status information of the database when the judgment result of the type judgment module is yes; The recycling judging module is configured to judge whether the database meets the off-line recycling condition according to the corresponding predetermined strategy based on the running status information. 8. The device according to claim 7, wherein the operating status information includes at least one of the following: The running state of the process of the database; the connectivity status of the instance of the database; The startup time of the instance of the database; Whether there is a business library in the instance of the database, and whether there is a business table in the business library; The last data modification time of the business table in the instance of the database; Whether the proxy server used by the database is mounted under the Linux virtual server. 9. The device according to claim 8, wherein the recovery judging module comprises: The first judging unit is used to judge whether the database does not have a record on the business cloud platform, but there is a data directory locally on the server or its instance has been started, if so, judging that the database meets the off-line recovery condition; The second judging unit is used for judging whether the process of the database is running, if not, judging that the database meets the off-line recovery condition; The third judging unit is used for judging whether the proxy server used by the database is mounted under the Linux virtual server, if not, judging that the database meets the off-line recovery condition; The fourth judging unit is used for judging whether the database starts exceeding the first time threshold, but no business library or business table has been established, and if so, judging that the database meets the conditions for offline recovery; and/or The fifth judging unit is used for judging whether the database starts exceeding the first time threshold, the business library and business table are established, and the last data modification time of the business table exceeds the second time threshold, and if so, judge Whether the database is accessed by a statement within a predetermined period of time, and if not, it is judged that the database meets the offline recovery condition. 10. The device according to claim 7, wherein the information acquisition module comprises: The timing acquisition unit is configured to regularly execute the script for acquiring the database operation status information, acquire and save the database operation status information.