CN111552637B - Database state detection method and device, electronic equipment and storage medium thereof - Google Patents
Database state detection method and device, electronic equipment and storage medium thereof Download PDFInfo
- Publication number
- CN111552637B CN111552637B CN202010310910.5A CN202010310910A CN111552637B CN 111552637 B CN111552637 B CN 111552637B CN 202010310910 A CN202010310910 A CN 202010310910A CN 111552637 B CN111552637 B CN 111552637B
- Authority
- CN
- China
- Prior art keywords
- check
- state
- database
- verification
- states
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3604—Software analysis for verifying properties of programs
- G06F11/3608—Software analysis for verifying properties of programs using formal methods, e.g. model checking, abstract interpretation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The application provides a method, a device, an electronic device and a storage medium for detecting a database state, wherein the method is applied to an application server, and the application server is correspondingly connected with a master database and at least one slave database, and comprises the following steps: acquiring the running state of middleware in an application server; when the running state of the middleware is acquired to be a starting state, a plurality of verification coroutines of a verification database are created in the middleware; and determining the state of the main database according to the plurality of check-up covariates. According to the method and the device, the middleware is used for creating a plurality of check-up co-procedures to detect the state of the database, judging whether the main database fails or not, and comprehensively judging the state of the main database through the states of the plurality of check-up co-procedures, so that the database is not judged to be abnormal because the abnormality occurs in a single check-up co-procedure, the main database is prevented from being misjudged as a failure database, the error switching of the failure database is avoided, and the failure detection precision is improved.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method and apparatus for detecting a database state, an electronic device, and a storage medium thereof.
Background
Currently, with the tremendous growth of IOE (IBM, ORACLE, EMC) movement, more and more internet enterprises use MySQL database as a background database. The construction of a highly available server based on MySQL (MySQL is a relational database management system) and NFS (NetworkFile System ) is very mature, and a highly available scheme requires that the database be reliable, which means that the data is reliable, that the data cannot be lost, etc., that the database is available, that the database service is available, that the server cannot be down, etc.
Existing high availability schemes typically consist of two parts, MHA Manager and MHA Node (data Node), through high availability tools such as MHA (Master High Availability) and an organizer software. MHA Manager may be deployed on a single machine to manage multiple master-slave clusters, or on a slave node. The MHA Node operates on each MySQL server, the MHA Manager detects the nodes of the main library in the cluster at regular time, when the main library fails, the fault switching is automatically executed, namely, the slave library of the latest data is lifted to a new main library, and then all other slave libraries are redirected to the new main library. The Orcheator is a node which periodically connects or disconnects the MySQL master library, if the master library is not connected, the slave library is connected, the read-write thread between the master library and the slave library is checked by the slave library, and if the read-write thread of the slave library also shows abnormality, the master library fault is judged.
The two high-availability schemes have the problem of low precision caused by single-point detection, and the MHA only carries out single-point detection on one node of the main library nodes, so that misjudgment is easy to cause, and the timeliness is low; the detection mechanism of the etcher may cause a database fault to be misjudged when the etcher itself cannot acquire the status of the read/write thread when the node of the main library of the etcher detects a problem and is rammed from the library. At present, both high-availability schemes cause the problem that the detection result is not accurate enough, and the master database is possibly used as a fault database and is mistakenly cut into the slave databases.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a method, an apparatus, an electronic device, and a storage medium for detecting a database state, which can improve the accuracy of database failure detection.
In one aspect, the present application provides a method for detecting a database state, which is applied to an application server, where the application server is correspondingly connected with a master database and at least one slave database, and includes:
acquiring the running state of middleware in an application server;
when the running state of the middleware is acquired to be a starting state, a plurality of verification coroutines of a verification database are created in the middleware;
And determining the state of the main database according to the plurality of check-up covariates.
In some embodiments, the plurality of check protocols Cheng Baokuo is a first check protocol;
the step of determining the state of the main database according to the plurality of check-up coroutines comprises the following steps:
database verification is carried out according to the plurality of verification auxiliary programs to obtain a plurality of verification states, wherein the plurality of verification states are obtained by respectively carrying out database verification on the plurality of verification auxiliary programs except the first verification auxiliary program;
when any one of the plurality of check states is an abnormal state, acquiring the plurality of check states according to the first check cooperative distance;
and determining the state of the main database according to the plurality of verification states.
In some embodiments, the plurality of check protocols Cheng Baokuo are second check protocols, the plurality of check states including a first check state, the first check state being a state obtained by the second check protocol checking database;
the step of determining the state of the main database according to the plurality of verification states comprises the following steps:
according to the first value, the second value and the third value of the second check-up protocol Cheng Huoqu, the first value is the number of times that the second check-up protocol sends the data writing request to a main database node of a database, the second value is the number of times that the data writing request received by the second check-up protocol returns to the main database node, and the third value is the third value obtained according to the first value and the second value;
Comparing the third value with a first preset threshold value to obtain a comparison result;
and obtaining a first check state according to the comparison result.
In some embodiments, the plurality of check-up protocols Cheng Baokuo includes a third check-up protocol, the plurality of check-up states including a second check-up state, the second check-up state being a state obtained by a third check-up protocol checking database;
the step of determining the state of the main database according to the plurality of verification states comprises the following steps:
transmitting a request for inserting the test data into the main database to the main database node according to the third check protocol, and obtaining a first result and a second result, wherein the first result is a result of whether the data is successfully inserted into the main database or not, and the second result is a result of whether the request is successfully transmitted or not;
and obtaining the second checking state according to the first result and the second result.
In some embodiments, the plurality of check protocols Cheng Baokuo includes a fourth check state, the fourth check state being a state obtained by a third check protocol checking database;
the step of determining the state of the main database according to the plurality of verification states comprises the following steps:
Acquiring the state of a read-write thread of a slave database according to the fourth check cooperative program, wherein the state of the read-write thread is the connection state of the slave database and the master database through the read-write thread;
and obtaining a third verification state according to the state of the read-write thread.
In some embodiments, the step of determining the state of the master database from the plurality of check states comprises:
when the first check state, the second check state and the third check state are abnormal states, determining that the state of the database is an abnormal state;
and when any one of the first check state, the second check state and the third check state is a normal state, determining that the state of the database is a normal state.
In some embodiments, after the step of determining that the state of the database is an abnormal state, the method further includes:
and when the state of the database is determined to be abnormal, selecting a target database from the at least one slave database, and adjusting the target database to be a master database.
In another aspect, the present application further provides a device for detecting a state of a database, where the device includes:
The detection unit is used for acquiring the running state of the middleware in the application server;
the creation unit is used for creating a plurality of verification coroutines of the verification database in the middleware when the running state of the middleware is acquired to be a starting state;
and the processing unit is used for determining the state of the main database according to the plurality of check-up co-ordinates.
In some embodiments, the plurality of check protocols Cheng Baokuo is a first check protocol; the processing unit is used for:
database verification is carried out according to the plurality of verification auxiliary programs to obtain a plurality of verification states, wherein the plurality of verification states are obtained by respectively carrying out database verification on the plurality of verification auxiliary programs except the first verification auxiliary program;
when any one of the plurality of check states is an abnormal state, acquiring the plurality of check states according to the first check cooperative distance;
and determining the state of the main database according to the plurality of verification states.
In some embodiments, the plurality of check protocols Cheng Baokuo are second check protocols, the plurality of check states including a first check state, the first check state being a state obtained by the second check protocol checking database; the processing unit is used for:
According to the first value, the second value and the third value of the second check-up protocol Cheng Huoqu, the first value is the number of times that the second check-up protocol sends the data writing request to a main database node of a database, the second value is the number of times that the data writing request received by the second check-up protocol returns to the main database node, and the third value is the third value obtained according to the first value and the second value;
comparing the third value with a first preset threshold value to obtain a comparison result;
and obtaining a first check state according to the comparison result.
In some embodiments, the plurality of check-up protocols Cheng Baokuo includes a third check-up protocol, the plurality of check-up states including a second check-up state, the second check-up state being a state obtained by a third check-up protocol checking database; the processing unit is used for:
transmitting a request for inserting the test data into the main database to the main database node according to the third check protocol, and obtaining a first result and a second result, wherein the first result is a result of whether the data is successfully inserted into the main database or not, and the second result is a result of whether the request is successfully transmitted or not;
And obtaining the second checking state according to the first result and the second result.
In some embodiments, the plurality of check protocols Cheng Baokuo includes a fourth check state, the fourth check state being a state obtained by a third check protocol checking database; the processing unit is used for:
acquiring the state of a read-write thread of a slave database according to the fourth check cooperative program, wherein the state of the read-write thread is the connection state of the slave database and the master database through the read-write thread;
and obtaining a third verification state according to the state of the read-write thread.
In some embodiments, the processing unit is to:
when the first check state, the second check state and the third check state are abnormal states, determining that the state of the database is an abnormal state;
and when any one of the first check state, the second check state and the third check state is a normal state, determining that the state of the database is a normal state.
In some embodiments, the processing unit is further to:
and when the state of the database is determined to be abnormal, selecting a target database from the at least one slave database, and adjusting the target database to be a master database.
In another aspect, the present application further provides an electronic device, including:
one or more processors;
a memory for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method for detecting a database state.
In another aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, is a method of detecting a state of a database.
According to the method and the device, the middleware is used for creating a plurality of check-up co-procedures to detect the state of the database, judging whether the main database fails or not, and comprehensively judging the state of the main database through the states of the plurality of check-up co-procedures, so that the database is not judged to be abnormal because the abnormality occurs in a single check-up co-procedure, the main database is prevented from being misjudged as a failure database, the error switching of the failure database is avoided, and the failure detection precision is improved.
Drawings
Technical solutions and other advantageous effects of the present application will be made apparent from the following detailed description of specific embodiments of the present application with reference to the accompanying drawings.
Fig. 1 is a schematic system architecture diagram of a method for detecting a database state according to an embodiment of the present application.
Fig. 2 is a flowchart of a method for detecting a database state according to an embodiment of the present application.
Fig. 3 is a flowchart of a method for detecting a database state according to another embodiment of the present application.
Fig. 4 is a schematic flow chart of an embodiment of step 103 in the embodiment of the present application.
Fig. 5 is a flow chart of a further embodiment of step 103 in the embodiment of the present application.
Fig. 6 is a flow chart of a further embodiment of step 103 in the embodiment of the present application.
Fig. 7 is a schematic diagram of a database state detection device according to an embodiment of the present application.
Fig. 8 is a schematic structural diagram of an electronic device for detecting a database state according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by those skilled in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.
In the description of the present application, it should be understood that the terms "center," "longitudinal," "transverse," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," etc. indicate or are based on the orientation or positional relationship shown in the drawings, merely for convenience of description and to simplify the description, and do not indicate or imply that the devices or elements referred to must have a specific orientation, be configured and operated in a specific orientation, and thus should not be construed as limiting the present application. Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more of the described features. In the description of the present application, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
In the description of the present application, it should be noted that, unless explicitly specified and limited otherwise, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be either fixedly connected, detachably connected, or integrally connected, for example; can be mechanically connected, electrically connected or can be communicated with each other; can be directly connected or indirectly connected through an intermediate medium, and can be communicated with the inside of two elements or the interaction relationship of the two elements. The specific meaning of the terms in this application will be understood by those of ordinary skill in the art as the case may be.
In this application, unless expressly stated or limited otherwise, a first feature "above" or "below" a second feature may include both the first and second features being in direct contact, and may also include the first and second features not being in direct contact but being in contact with each other by way of additional features therebetween. Moreover, a first feature being "above," "over" and "on" a second feature includes the first feature being directly above and obliquely above the second feature, or simply indicating that the first feature is higher in level than the second feature. The first feature being "under", "below" and "beneath" the second feature includes the first feature being directly under and obliquely below the second feature, or simply means that the first feature is less level than the second feature.
The following disclosure provides many different embodiments or examples for implementing different structures of the present application. In order to simplify the disclosure of the present application, the components and arrangements of specific examples are described below. Of course, they are merely examples and are not intended to limit the present application. Furthermore, the present application may repeat reference numerals and/or letters in the various examples, which are for the purpose of brevity and clarity, and which do not in themselves indicate the relationship between the various embodiments and/or arrangements discussed. In addition, the present application provides examples of various specific processes and materials, but one of ordinary skill in the art may recognize the application of other processes and/or the use of other materials.
Referring to fig. 1, the method for detecting a database state provided in the present application may be applied to an application environment as shown in fig. 1, that is, may include an application server 10, a client device 20, and a data storage 30, where the client device 20 and the data storage 30 are connected to the application server 10 through a network, the client device 20 is loaded with a client, the application server 10 is loaded with a middleware 40, the data storage 30 is used for storing data, for example, a database 50 is provided, the middleware 40 is used for analyzing according to a data access request received from a client in the client device 20, and establishing a connection with the database 50, and the middleware 40 also receives a returned result from the data access request of the database 50 and returns the result to the client.
Wherein the data access request may include a data write request and a data read request. The database 50 may include a master database and at least one slave database, where the master database 50 is configured to receive a data write request of a data access request, write data carried in the data write request into the master database, and synchronously update the write data into the slave database, and the target slave database receives a data read request through the middleware 40.
The data access request may be in the form of an SQL language, for example, after the middleware 40 receives the data access request in the form of the SQL language, the middleware may analyze the target database to be accessed by the client according to the content of the SQL language, and establish access connection with the target database, and further forward the access request to the target database directly, so as to initiate access to the target data to the target database directly through the SQL language; the data access request may also be generated according to a preset command format, and the middleware 40 extracts the target information in the data access request after receiving the data access request, so as to learn that the user needs to access the target database and the existence position of the target data in the database, further generate a corresponding SQL according to the data access requirement of the user, and initiate access to the target data to the database through the generated SQL.
The database 50 may be a relational database cluster, i.e. an open database connection driver may be configured to integrate the databases with each other, for example, in this embodiment, the database 50 may be a MySQL database, or may be an open database such as a MariaDB, a Percona Server, etc., where the database 50 may include a master database and at least one slave database, which are not limited herein.
In the present embodiment, the middleware 40 is loaded in the application server 10, and the middleware 40 is independent system software or service program located between the client in the client device 20 and the data storage 30. Middleware 40 is a type of computer software that connects software components and applications, and includes a set of services to facilitate the interaction of multiple software running on one or more machines over a network, and the interoperability provided by this technology promotes the evolution of a consistent distributed architecture, typically used to support and simplify those complex distributed applications, including web servers, transaction monitors, and message queuing software. The middleware may be Proxy, cobar, myCat, vitess, atlas, etc.
In the embodiment of the present application, a plurality of check-up routines of the check database are created in the middleware 40 to detect the state of the master database; and determining the state of the main database according to the plurality of check-up co-programs, judging whether the main database fails, and returning the result of detecting the state of the main database to the client.
In embodiments of the present application, communication between the client and the middleware 40 may be achieved by any communication means, including, but not limited to, mobile communication based on the third generation partnership project (3rd Generation Partnership Project,3GPP), long term evolution (Long Term Evolution, LTE), worldwide interoperability for microwave access (Worldwide Interoperability for Microwave Access, wiMAX), or computer network communication based on the TCP/IP protocol family (TCP/IP Protocol Suite, TCP/IP), user datagram protocol (User Datagram Protocol, UDP), etc.
Those skilled in the art will understand that the application environment shown in fig. 1 is merely an application scenario corresponding to the present application scenario, and is not limited to the application scenario of the present application scenario, and other application environments may further include more or fewer servers than those shown in fig. 1, for example, only 1 server is shown in fig. 1, and it may be understood that the application environment may further include other clients corresponding to one or more accessible application servers, which is not limited herein. The client device 20 may include at least one of a cell phone, a tablet computer, a notebook computer, a personal digital assistant, a wearable device, and the like.
Specifically, referring to fig. 2, an embodiment of the present application provides a method for detecting a database state, which specifically includes steps 101 to 103:
The running state of the middleware can be obtained through a preset command statement, and the running state of the middleware is obtained by the following steps: the object of the present embodiment is to acquire the running state of the middleware, for example, when the middleware between the client and the master database is Proxy, the running state of the Proxy is the startup state, or the stop state, the normal termination state, or the like.
And 102, when the running state of the middleware is acquired to be the starting state, creating a plurality of check coroutines for checking the main database in the middleware.
In this embodiment, the middleware Proxy is connected with a back-end database, and is used for storing data of the MySQL database collected by the middleware Proxy; for example, the back-end database may be an SQLite database, and a corresponding storage table is built in the MySQL database to store real-time data collected by a corresponding client, so as to facilitate transfer and history retrieval; and then, the collected real-time data is stored into a corresponding MySQL working database space through one-time transfer by an operation mode of SQLite database interaction, namely, after a Proxy obtains the check state of the MySQL database through a plurality of check co-procedures, each co-procedure obtains the check code, the IP address, the port and other data of the Proxy and stores the data into the SQLite database.
And step 103, determining the state of the main database according to the plurality of check-up coroutines.
Taking the main database as a MySQL database as an example, the state of the MySQL database may be a normal state or a fault state, where the normal state is a state in which the database operates normally, and the fault state database is in a fault state. Common cases of MySQL data failures include: mySQL port connection number full fault, mySQL disk full fault, mySQL main database downtime, etc. For the situation that the connection number of MySQL ports is full, namely that switching is not needed to be executed generally, the corresponding solution is to set an alarm threshold, for example, when the connection number reaches 80% of the preset port connection number, alarm is started, and manual intervention is performed; if the port connection number is full but no alarm occurs, the port connection number can be artificially increased. For the condition of full capacity fault of MySQL disk, the general solution is to set an alarm threshold, start alarming when the connection number reaches 80%, and perform manual intervention; if the disk capacity is full but no alarm is given, a failover is required, i.e., one of the secondary databases is switched to the primary database and the failed primary database is switched to the secondary database. For cases where MySQL master database is down or restarted for other reasons, then a failover needs to be performed as well.
According to the method, the middleware is used for creating a plurality of check-up co-programs to detect the state of the main database, whether the main database fails or not is judged, the state of the main database is comprehensively judged through the states of the plurality of check-up co-programs, the abnormality of the main database is not judged because the abnormality occurs to one check-up co-program alone, the main database is prevented from being misjudged as a failure database, and therefore error switching of the failure database is avoided, and the failure detection precision is improved.
In some embodiments, the plurality of check protocols Cheng Baokuo is a first check protocol; correspondingly, the step 103, determining the state of the master database according to the plurality of check-up procedures, please refer to fig. 3, specifically includes the following steps 201-203:
The first check cooperative program is used for waiting for the call of other cooperative programs in the middleware Proxy. Each protocol obtains a check state after detecting the main database, and in this embodiment, the check state may be represented by a preset check code, and the check code may be a binary code. For example, when the verification state is normal, it may be indicated by any one of 0, 00, and 010, and correspondingly, when the verification state is abnormal, it may be indicated by any one of 1, 11, and 101. It should be understood that the above status code is only one expression form of checking status, and the status code may be deformed, expressed in letter or text form, or the like, besides the above expression form, which is not limited in this application.
If the checking state of a certain checking assistant program is abnormal, an arbitration task is initiated, namely, the first checking assistant program is called to check the states of other checking assistant programs, and after the first checking assistant program obtains the checking results of all other checking assistant programs, the state of the main database is comprehensively judged according to the obtained checking results.
And 203, determining the state of the main database according to the plurality of verification states.
When a certain check cooperative program check state is abnormal and the first check cooperative program is called to check the states of other check cooperative programs, if the first check cooperative program detects that the state code of any check cooperative program is not 1, the check result generated by the first check cooperative program is 0, and at the moment, the main database is considered to be not failed, and the first check cooperative program gives up to continue checking other check cooperative programs; if the first check co-procedure verifies that the state codes of all other check co-procedures are 1, the check result generated by the first check co-procedure is 0, and the main database fault is judged.
In some embodiments, the plurality of check-up protocols Cheng Baokuo are second check-up protocols, and the plurality of check-up states include a first check-up state, the first check-up state being a state obtained by the second check-up protocol checking the MySQL database.
The second check-up routine is used to count failure rates of transactions sent to the master database within a preset time period, where the preset time period may be, for example, a time period of one second.
The first value is the number of times that the second check-up routine sends the data write-in request to a main database node of the MySQL database, that is, the total transaction number.
And the second value is the number of times the data write request received by the second check routine is returned to the master database node.
The third value is obtained according to the first value and the second value, and is used for representing the failure rate of the transaction sent to the main database in each second, and the middleware Proxy can identify whether the read flow or the write flow is transmitted when transmitting the instruction, and if the read flow or the write flow is transmitted to the nodes of the main database. Since the failure rate statistics are based on the fact that the middleware Proxy receives the return of the transaction, the transaction is finished, but all the results which are not normally returned are calculated by failure, and the transaction is not finished or all the return null values are calculated successfully, the failure rate calculation method can be expressed by the following mathematical formula:
Where r represents the failure rate, m represents a total number of times the middleware Proxy forwards instructions to the master database, and n represents a total number of times the middleware Proxy receives the master database return. m, n, r correspond to a first value, a second value, and a third value, respectively.
The above mathematical expression is only one expression of the first value, the second value, and the third value, and the expression may be modified by adding parameters or performing operations, and the present application is not limited thereto.
the second checking protocol is provided with two counters, namely a first counter and a second counter, the first counter and the second counter analyze instruction sentences in a middleware Proxy, if the operation is sent to a main database, the first counter is marked as m+1, the return result of the main database is judged at the same time, if the return result is reported wrong, the second counter is marked as n+1, and the value of r is compared with a first preset threshold, wherein the first preset threshold can be represented by a binary state code; for example, whether the value of r is equal to 1.
And 302, obtaining a first verification state according to the comparison result.
For example, whether the state code of the second check co-procedure is equal to 1 is determined, if the state code is equal to 1, which indicates that the check result of the second check co-procedure is abnormal, the first check co-procedure is invoked to check the states of other check co-procedures.
Meanwhile, the second check-up routine is executed once per second to store the value of r, the connection address of the middleware Proxy, which is a network address for connecting to the database, which may include an internet protocol address (Internet Protocol Address, IP address) and a network port, into the back-end database. The backend data may be, for example, an SQLite database; a corresponding storage table is established in the MySQL database so as to store real-time data collected by corresponding equipment, thereby facilitating transfer and historical retrieval; and then, the collected real-time data is stored into a corresponding MySQL working database space through one-time transfer by an operation mode of SQLite database interaction.
In some embodiments, the plurality of check protocols Cheng Baokuo includes a third check protocol, and the plurality of check states includes a second check state, the second check state being a state obtained by the third check protocol checking database.
The step 203, the step of determining the state of the master database according to the plurality of verification states, as shown in fig. 5, specifically includes the following steps 401-402:
And step 402, obtaining the second checking state according to the first result and the second result.
And the third checking protocol establishes a new connection with the main database according to the preset frequency, for example, establishes a connection with the main database every 1 second, and establishes a connection with the main data again in the next second by inserting preset monitoring data into the main data and judging a return result to obtain the return result and then disconnecting the return result from the database.
The purpose of inserting the monitoring data is to detect whether the number of port connections is full and whether the disk is full, wherein whether the disk is full is judged by whether the monitoring data can be inserted into the disk, the returned result is a detection result, and the detection result comprises a first result and a second result, for example, the first result corresponds to the result of whether the connection is successful or not, the second result corresponds to the result of whether the monitoring data can be inserted into the disk, if the third protocol Cheng Chenggong is connected with the main database and the monitoring database is successfully inserted into the disk, the check state of the third check protocol is marked as successful, the state code 0 is used for representing the check state, and meanwhile, the IP address of the Proxy and the port are written into the rear end storage database SQLite; if the third cooperative program is not connected with the main database or the monitoring data cannot be inserted into the disk, marking that the check state of the third check cooperative program is failed, representing by a state code 1, writing the IP address and the port of the Proxy into the rear-end storage database SQLite, and calling the first check cooperative program to arbitrate.
And through continuous connection, disconnection and insertion operations, judging whether the port connection number of the main library is full or judging whether the disk is full or not is judged by faults.
In some embodiments, the plurality of check protocols Cheng Baokuo includes a fourth check state, the fourth check state being a state obtained by a third check protocol checking database;
the step 203, the step of determining the state of the master database according to the plurality of verification states, as shown in fig. 6, specifically includes the following steps 501-502:
And establishing connection between the slave database and the master database through a fourth check-up procedure according to a preset frequency, for example, acquiring monitoring states of the master database and the slave database once every 1 second, namely judging whether a read-write thread of the slave database can be connected with the master database, if the connection is successful, marking the check state of the third check-up procedure as successful, using a state code 0 to indicate that the IP address and the port of the Proxy are written into a rear-end storage database, and if not, marking the check state of the third check-up procedure as failed, using a state code 1 to indicate that the IP address and the port of the Proxy are written into the rear-end storage database SQLite, and calling the first check-up procedure to carry out arbitration. The state monitoring of the master database node is realized through judging the read-write state in the slave database node.
In some embodiments, the step 203, the step of determining the state of the master database according to the plurality of check states, specifically includes the following steps 601-602:
step 601, if the first check state, the second check state and the third check state are all abnormal states, determining that the state of the main database is an abnormal state;
the first check state, the second check state and the third check state may be represented by a status code, for example, the status code is 0 or 1,0 indicates that the check state is normal, and 1 indicates that the check state is abnormal.
After the middleware Proxy is started, the information of a master database node and a slave database node of MySQL is obtained from a configuration file, and four processes including a first check co-procedure, a second check co-procedure and a fourth check co-procedure are started at the same time, after the service flow reaches the Proxy, the Proxy performs SQL analysis, the read flow is forwarded to a corresponding slave node according to a certain rule, the write flow is forwarded to a corresponding master node, and if the first check co-procedure checks a first check state, a second check state and a third check state, namely, the state codes obtained by the second check co-procedure, the third check co-procedure and the fourth check co-procedure are all 1, the first check co-procedure check result is recorded as 1, and the master database fault is judged.
Step 602, if any one of the first check state, the second check state and the third check state is a normal state, determining that the state of the main database is a normal state.
For example, when the second checking assistant process finishes checking the main database to obtain the first checking state, if the state code of the first checking state is 1, the second checking assistant process actively calls the first checking assistant process to check the states of the third checking assistant process and the fourth checking assistant process, if only one of the third checking assistant process and the fourth checking assistant process has a checking state other than 1, the checking result of the first checking assistant process is recorded as 0, and the state of the main database at this time is judged to be a normal state, namely the database is normal, and then the fault switching is abandoned and the state checking of the third checking assistant process and the fourth checking assistant process is continued.
In some embodiments, if the result of the first check-up procedure is recorded as 1, the first check-up procedure repeatedly checks the states of the second check-up procedure, the third check-up procedure and the fourth check-up procedure for two rounds, if the state codes obtained by three rounds of check-up of the first check-up procedure are all 1, the state of the database is judged to be abnormal, otherwise, the state of the database is judged to be normal, and no operation is executed.
In some embodiments, after the determining 603 that the state of the master database is an abnormal state, the method further includes:
and 603, selecting a target database from the at least one slave database when the state of the master database is determined to be abnormal, and adjusting the target database to be the master database.
When the state of the main database is abnormal, namely the main database fails, performing fault switching, lifting the slave database of the latest data to be a new main database, and then redirecting all other slave databases to the new main database, thereby ensuring the normal operation of the server.
And by calling the states of the second check protocol, the second check protocol and the third check protocol of the first check protocol Cheng Jianyan, comprehensively judging according to the check result, and if the result is determined to be reliable, executing the fault switching operation.
In the foregoing embodiments, the descriptions of the embodiments are focused on, and the portions of one embodiment that are not described in detail in the foregoing embodiments may be referred to in the foregoing detailed description of other embodiments, which are not described herein again.
In the implementation, each unit or structure may be implemented as an independent entity, or may be implemented as the same entity or several entities in any combination, and the implementation of each unit or structure may be referred to the foregoing method embodiments and will not be repeated herein.
In order to better implement the method for detecting the state of the database in the embodiment of the application, the embodiment of the application also provides a device for detecting the state of the database on the basis of the method for detecting the state of the database. The state detection device of the database is integrated in equipment, and the equipment can be a server or a client, such as a mobile phone, a tablet personal computer, a desktop computer and the like.
Fig. 7 is a schematic block diagram of a state detection apparatus of a database provided in an embodiment of the present application, where the state detection apparatus of the database includes an acquisition unit 701, a creation unit 702, and a processing unit 703, as shown in fig. 7, in which:
an acquiring unit 701, configured to acquire an operation state of middleware in an application server;
a creating unit 702, configured to create a plurality of verification coroutines of a verification database in the middleware when the running state of the middleware is acquired to be a startup state;
a processing unit 703, configured to determine a state of the master database according to the plurality of check-coroutines.
In some embodiments, the plurality of check protocols Cheng Baokuo is a first check protocol; the processing unit 703 is configured to:
database verification is carried out according to the plurality of verification auxiliary programs to obtain a plurality of verification states, wherein the plurality of verification states are obtained by respectively carrying out database verification on the plurality of verification auxiliary programs except the first verification auxiliary program;
When any one of the plurality of check states is an abnormal state, acquiring the plurality of check states according to the first check cooperative distance;
and determining the state of the main database according to the plurality of verification states.
In some embodiments, the plurality of check protocols Cheng Baokuo are second check protocols, the plurality of check states including a first check state, the first check state being a state obtained by the second check protocol checking database; the processing unit 703 is configured to:
according to the first value, the second value and the third value of the second check-up protocol Cheng Huoqu, the first value is the number of times that the second check-up protocol sends the data writing request to a main database node of a database, the second value is the number of times that the data writing request received by the second check-up protocol returns to the main database node, and the third value is the third value obtained according to the first value and the second value;
comparing the third value with a first preset threshold value to obtain a comparison result;
and obtaining a first check state according to the comparison result.
In some embodiments, the plurality of check-up protocols Cheng Baokuo includes a third check-up protocol, the plurality of check-up states including a second check-up state, the second check-up state being a state obtained by a third check-up protocol checking database; the processing unit 703 is configured to:
Transmitting a request for inserting the test data into the main database to the main database node according to the third check protocol, and obtaining a first result and a second result, wherein the first result is a result of whether the data is successfully inserted into the main database or not, and the second result is a result of whether the request is successfully transmitted or not;
and obtaining the second checking state according to the first result and the second result.
In some embodiments, the plurality of check protocols Cheng Baokuo includes a fourth check state, the fourth check state being a state obtained by a third check protocol checking database; the processing unit 703 is configured to:
acquiring the state of a read-write thread of a slave database according to the fourth check cooperative program, wherein the state of the read-write thread is the connection state of the slave database and the master database through the read-write thread;
and obtaining a third verification state according to the state of the read-write thread.
In some embodiments, the processing unit 703 is configured to:
when the first check state, the second check state and the third check state are abnormal states, determining that the state of the main database is an abnormal state;
And when any one of the first check state, the second check state and the third check state is a normal state, determining that the state of the main database is a normal state.
In some embodiments, the processing unit 703 is further configured to:
and when the state of the master database is determined to be abnormal, selecting a target database from the at least one slave database, and adjusting the target database to be the master database.
According to the device, the acquiring unit 701 acquires the starting state of the middleware, the creating unit 702 creates a plurality of check-up co-programs in the middleware in the starting state, the processing unit 703 detects the state of the database through the plurality of check-up co-programs, judges whether the main database fails, comprehensively judges the state of the main database through the states of the plurality of check-up co-programs, judges that the database is abnormal without the abnormality of a certain check-up co-program, and avoids the main database from being misjudged as a fault database, thereby avoiding the error switching of the fault database and improving the fault detection precision.
The embodiment of the application further provides an electronic device, which integrates the state detection device of any database provided in the embodiment of the application, please refer to fig. 8, fig. 8 shows a schematic structural diagram of the electronic device according to the embodiment of the application, specifically:
The electronic device may include one or more processing cores 'processors 801, one or more computer-readable storage media's memory 802, power supply 803, and input unit 804, among other components. It will be appreciated by those skilled in the art that the electronic device structure shown in fig. 8 is not limiting of the electronic device and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components. Wherein:
the processor 801 is a control center of the electronic device, connects various parts of the entire electronic device using various interfaces and lines, and performs various functions of the electronic device and processes data by running or executing software programs and/or modules stored in the memory 802, and calling data stored in the memory 802, thereby performing overall monitoring of the electronic device. Optionally, the processor 801 may include one or more processing cores; preferably, the processor 801 may integrate an application processor that primarily handles operating systems, user interfaces, applications, etc., with a modem processor that primarily handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 801.
The memory 802 may be used to store software programs and modules, and the processor 801 executes various functional applications and data processing by executing the software programs and modules stored in the memory 802. The memory 802 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program (such as a sound playing function, an image playing function, etc.) required for at least one function, and the like; the storage data area may store data created according to the use of the electronic device, etc. In addition, memory 802 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device. Accordingly, the memory 802 may also include a memory controller to provide the processor 801 with access to the memory 802.
The electronic device further comprises a power supply 803 for powering the various components, preferably the power supply 803 can be logically coupled to the processor 801 via a power management system such that functions such as managing charging, discharging, and power consumption are performed by the power management system. The power supply 803 may also include one or more of any components, such as a direct current or alternating current power supply, a recharging system, a power failure detection circuit, a power converter or inverter, a power status indicator, and the like.
The electronic device may further comprise an input unit 804, which input unit 804 may be used for receiving input digital or character information and for generating keyboard, mouse, joystick, optical or trackball signal inputs in connection with user settings and function control.
Although not shown, the electronic device may further include a display unit or the like, which is not described herein. In particular, in this embodiment, the processor 801 in the electronic device loads executable files corresponding to the processes of one or more application programs into the memory 802 according to the following instructions, and the processor 801 executes the application programs stored in the memory 802, so as to implement various functions as follows:
acquiring the running state of middleware in an application server; when the running state of the middleware is acquired to be a starting state, a plurality of verification coroutines of a verification database are created in the middleware; and determining the state of the main database according to the plurality of check-up covariates.
According to the method, the middleware is used for creating a plurality of check-up co-programs to detect the state of the database, whether the main database fails or not is judged, the state of the main database is comprehensively judged through the states of the plurality of check-up co-programs, the database is not judged to be abnormal because the abnormality occurs to one check-up co-program, the main database is prevented from being misjudged as the failure database, accordingly error switching of the failure database is avoided, and the failure detection precision is improved.
Those of ordinary skill in the art will appreciate that all or a portion of the steps of the various methods of the above embodiments may be performed by instructions, or by instructions controlling associated hardware, which may be stored in a computer-readable storage medium and loaded and executed by a processor.
To this end, embodiments of the present application provide a computer readable storage medium, which may include: read Only Memory (ROM), random access Memory (RAM, random Access Memory), magnetic or optical disk, and the like. On which a computer program is stored, which is loaded by a processor to perform the steps of any of the method for distributed point of sale location of a stream provided in the embodiments of the present application. For example, the loading of the computer program by the processor may perform the steps of:
acquiring the running state of middleware in an application server; when the running state of the middleware is acquired to be a starting state, a plurality of verification coroutines of a verification database are created in the middleware; and determining the state of the main database according to the plurality of check-up covariates.
In the foregoing embodiments, the descriptions of the embodiments are focused on, and the portions of one embodiment that are not described in detail in the foregoing embodiments may be referred to in the foregoing detailed description of other embodiments, which are not described herein again.
In the implementation, each unit or structure may be implemented as an independent entity, or may be implemented as the same entity or several entities in any combination, and the implementation of each unit or structure may be referred to the foregoing method embodiments and will not be repeated herein.
The specific implementation of each operation above may be referred to the previous embodiments, and will not be described herein.
The method, the device, the electronic equipment and the storage medium for selecting the physical distribution points provided by the embodiment of the application are described in detail, and the specific examples are applied to the embodiment of the application to illustrate the principle and implementation of the embodiment of the application, and the description of the embodiment is only used for helping to understand the method and the core idea of the embodiment of the application; meanwhile, those skilled in the art, based on the ideas of the embodiments of the present application, may change the specific implementation and application scope, and in summary, the present disclosure should not be construed as limiting the embodiments of the present application.
Claims (9)
1. The method for detecting the database state is characterized by being applied to an application server, wherein the application server is correspondingly connected with a master database and at least one slave database, and comprises the following steps:
Acquiring the running state of middleware in an application server;
when the running state of the middleware is acquired to be a starting state, a plurality of check coroutines for checking a database are created in the middleware, and the plurality of check coroutines Cheng Baokuo are first check coroutines, wherein the first check coroutines are used for waiting for the calling of other coroutines in the middleware;
determining a state of the master database according to the plurality of check-up coroutines, comprising:
database verification is carried out according to the plurality of verification co-ranges to obtain a plurality of verification states, wherein the plurality of verification states are obtained by respectively carrying out database verification on the plurality of verification co-ranges except the first verification co-range;
when any one of the plurality of check states is an abnormal state, acquiring and checking the plurality of check states according to the first check cooperative distance;
if the first check co-procedure detects that the state of any check co-procedure is normal, determining that the main database fails, the first check co-procedure gives up to check other check co-procedures, and if the first check co-procedure detects that the states of all other check co-procedures are abnormal, determining that the main database fails.
2. The method of claim 1, wherein the plurality of check protocols Cheng Baokuo are second check protocols, the plurality of check states including a first check state, the first check state being a state obtained by a second check protocol checking database;
the step of determining the state of the main database according to the plurality of verification states comprises the following steps:
according to the first value, the second value and the third value of the second check-up protocol Cheng Huoqu, the first value is the number of times that the second check-up protocol sends a data writing request to a main database node of a database, the second value is the number of times that the data writing request received by the second check-up protocol returns to the main database node, and the third value is the third value obtained according to the first value and the second value;
comparing the third value with a first preset threshold value to obtain a comparison result;
and obtaining the first check state according to the comparison result.
3. The method of claim 2, wherein the plurality of check protocols Cheng Baokuo are third check protocols, the plurality of check states including a second check state, the second check state being a state obtained by a third check protocol check database;
The step of determining the state of the main database according to the plurality of verification states comprises the following steps:
transmitting a request for inserting the test data into the main database to the main database node according to the third check protocol, and obtaining a first result and a second result, wherein the first result is a result of whether the data is successfully inserted into the main database or not, and the second result is a result of whether the request is successfully transmitted or not;
and obtaining the second checking state according to the first result and the second result.
4. A method as claimed in any one of claims 2 to 3, wherein the plurality of check protocols Cheng Baokuo are fourth check protocols, the plurality of check states including a fourth check state, the fourth check state being a state obtained by a third check protocol checking database;
the step of determining the state of the main database according to the plurality of verification states comprises the following steps:
acquiring the state of a read-write thread of a slave database according to the fourth check cooperative program, wherein the state of the read-write thread is the connection state of the slave database and the master database through the read-write thread;
and obtaining a third verification state according to the state of the read-write thread.
5. The method of claim 4, wherein the step of determining the state of the master database from the plurality of check states comprises:
when the first check state, the second check state and the third check state are abnormal states, determining that the state of the database is an abnormal state;
and when any one of the first check state, the second check state and the third check state is a normal state, determining that the state of the database is a normal state.
6. The method of claim 5, wherein after the step of determining that the state of the database is an abnormal state, further comprising:
and when the state of the database is determined to be abnormal, selecting a target database from the at least one slave database, and adjusting the target database to be a master database.
7. A device for detecting a state of a database, comprising:
the acquisition unit is used for acquiring the running state of the middleware in the application server;
the establishing unit is used for establishing a plurality of check coroutines of the check database in the middleware when the running state of the middleware is acquired to be a starting state, wherein the plurality of check coroutines Cheng Baokuo are first check coroutines, and the first check coroutines are used for waiting for the calling of other coroutines in the middleware;
The processing unit is configured to determine a state of the master database according to the plurality of check-up coroutines, and includes:
database verification is carried out according to the plurality of verification co-ranges to obtain a plurality of verification states, wherein the plurality of verification states are obtained by respectively carrying out database verification on the plurality of verification co-ranges except the first verification co-range;
when any one of the plurality of check states is an abnormal state, acquiring and checking the plurality of check states according to the first check cooperative distance;
if the first check co-procedure detects that the state of any check co-procedure is normal, determining that the main database fails, the first check co-procedure gives up to check other check co-procedures, and if the first check co-procedure detects that the states of all other check co-procedures are abnormal, determining that the main database fails.
8. An electronic device, the electronic device comprising:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement the method of detecting a database state as recited in any one of claims 1-6.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a method for detecting a state of a database as claimed in any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010310910.5A CN111552637B (en) | 2020-04-20 | 2020-04-20 | Database state detection method and device, electronic equipment and storage medium thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010310910.5A CN111552637B (en) | 2020-04-20 | 2020-04-20 | Database state detection method and device, electronic equipment and storage medium thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111552637A CN111552637A (en) | 2020-08-18 |
| CN111552637B true CN111552637B (en) | 2023-05-19 |
Family
ID=72002466
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010310910.5A Active CN111552637B (en) | 2020-04-20 | 2020-04-20 | Database state detection method and device, electronic equipment and storage medium thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111552637B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2014137798A (en) * | 2013-01-18 | 2014-07-28 | Oki Electric Ind Co Ltd | Database system and control method for database system |
| CN105577799A (en) * | 2015-12-25 | 2016-05-11 | 北京奇虎科技有限公司 | Method and device for detecting fault of database cluster |
| CN109344061A (en) * | 2018-09-25 | 2019-02-15 | 阿里巴巴集团控股有限公司 | A kind of method for detecting abnormality of interface, device, equipment and system |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP3525410B2 (en) * | 1998-12-16 | 2004-05-10 | 富士通株式会社 | Disaster recovery method and computer readable program recording medium for the same |
| CN101183377B (en) * | 2007-12-10 | 2010-09-08 | 华中科技大学 | High availability data-base cluster based on message middleware |
| JP6126891B2 (en) * | 2013-03-29 | 2017-05-10 | 富士通株式会社 | Detection method, detection program, and detection apparatus |
| CN104503965B (en) * | 2014-10-16 | 2017-08-29 | 杭州斯凯网络科技有限公司 | The elastomeric High Availabitities of PostgreSQL and implementation of load balancing |
| CN105404581B (en) * | 2015-12-25 | 2019-03-05 | 北京奇虎科技有限公司 | A kind of evaluating method and device of database |
| CN110162428A (en) * | 2019-05-17 | 2019-08-23 | 中国铁道科学研究院集团有限公司 | Method of data synchronization and device, electronic equipment and computer readable storage medium |
| CN110362625A (en) * | 2019-05-30 | 2019-10-22 | 杭州数梦工场科技有限公司 | Data base read-write separation method, device, electronic equipment and storage medium |
| CN110673994B (en) * | 2019-09-20 | 2023-05-12 | 北京百度网讯科技有限公司 | Database testing method and device |
-
2020
- 2020-04-20 CN CN202010310910.5A patent/CN111552637B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2014137798A (en) * | 2013-01-18 | 2014-07-28 | Oki Electric Ind Co Ltd | Database system and control method for database system |
| CN105577799A (en) * | 2015-12-25 | 2016-05-11 | 北京奇虎科技有限公司 | Method and device for detecting fault of database cluster |
| CN109344061A (en) * | 2018-09-25 | 2019-02-15 | 阿里巴巴集团控股有限公司 | A kind of method for detecting abnormality of interface, device, equipment and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111552637A (en) | 2020-08-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109308227B (en) | Fault detection control method and related equipment | |
| CN106843749A (en) | Write request processing method, device and equipment | |
| US10698605B2 (en) | Multipath storage device based on multi-dimensional health diagnosis | |
| GB2407887A (en) | Automatically modifying fail-over configuration of back-up devices | |
| CN108206768A (en) | Cluster monitoring and switching method and device | |
| CN106331081B (en) | Information synchronization method and device | |
| CN112039970A (en) | Distributed business lock service method, server, system and storage medium | |
| CN114265753A (en) | Management method and management system of message queue and electronic equipment | |
| US20050234919A1 (en) | Cluster system and an error recovery method thereof | |
| CN110717130B (en) | Dotting method, dotting device, dotting terminal and storage medium | |
| CN111552637B (en) | Database state detection method and device, electronic equipment and storage medium thereof | |
| CN112650629A (en) | Block chain index data recovery method, device, equipment and computer storage medium | |
| CN112632093A (en) | Work order processing method, device, system, storage medium and program product | |
| CN115190044B (en) | Device connection state checking method, device and storage medium | |
| CN115221060A (en) | Case generation method, device and equipment based on associated field and storage medium | |
| CN115174890A (en) | Flow playback test method and device, computer equipment and storage medium | |
| CN114816914A (en) | Data processing method, equipment and medium based on Kubernetes | |
| CN115914016A (en) | Cluster fault diagnosis method, device, equipment and storage medium | |
| CN105574020B (en) | Database operation method and device | |
| WO2022143065A1 (en) | Database probing method and apparatus | |
| CN114546759B (en) | Database access error monitoring and analyzing method and device and electronic equipment | |
| EP4319254A1 (en) | Load query processing method and apparatus, storage medium, and electronic apparatus | |
| CN116302823A (en) | Database processing method, device, server and storage medium | |
| CN114595208A (en) | Database switching method and device and storage medium | |
| CN116166461A (en) | Error diagnosis method, storage medium and device for database operation statement |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |