CN111506560A - Database master-slave switching method, terminal and storage medium - Google Patents
Database master-slave switching method, terminal and storage medium Download PDFInfo
- Publication number
- CN111506560A CN111506560A CN202010319897.XA CN202010319897A CN111506560A CN 111506560 A CN111506560 A CN 111506560A CN 202010319897 A CN202010319897 A CN 202010319897A CN 111506560 A CN111506560 A CN 111506560A
- Authority
- CN
- China
- Prior art keywords
- master
- slave
- database
- time difference
- delay time
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 87
- 238000012544 monitoring process Methods 0.000 claims description 17
- 238000004891 communication Methods 0.000 claims description 3
- 230000007547 defect Effects 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method, a terminal and a storage medium for database master-slave switching, and belongs to the technical field of database master-slave switching. The method comprises the following steps: receiving a master-slave delay time difference sent by a server, and storing the master-slave delay time difference into a common configuration object; comparing the master-slave delay time difference with a configuration threshold value of the public configuration object to update the switch attribute of the public configuration object; and making corresponding database master-slave switching selection according to the switch attribute of the common configuration object. The technical scheme of the invention can effectively solve the technical problems that the master-slave switching can not be dynamically changed, the code redundancy can not be realized, a plurality of slave libraries can not be switched in a balanced manner and the like which can not be simultaneously solved by the conventional database master-slave switching implementation scheme.
Description
Technical Field
The embodiment of the invention relates to the technical field of database master-slave switching, in particular to a database master-slave switching method, a database master-slave switching terminal and a database master-slave switching storage medium.
Background
The database generally adopts a master-slave architecture to provide high-availability services, so that when a client accesses the database of a server, a corresponding database master-slave switching selection is required. Currently, the following three database master-slave switching embodiments are mainly used in the project:
the method comprises the steps of firstly, using a Sharding-JDBC framework (positioned as a lightweight Java framework and providing additional services at a JDBC layer of Java, wherein the method uses a client direct connection database to provide services in a jar packet form, does not need additional deployment and dependence, can be understood as an enhanced JDBC driver, and is completely compatible with JDBC and various ORM frameworks) to actively declare and switch; i.e., forced use of reads from the master library, the disadvantage of this approach is that each query requires use of the master library with such a statement once. When a plurality of databases are queried in the method, multiple declarations are needed, so that a large number of complicated redundant codes irrelevant to the service exist in the method, namely, debugging and maintenance of the codes are influenced, errors are easy to occur, and if one query is forgotten to be declared, the query cannot be read from a main library, and the accuracy of the service is influenced.
Secondly, using a Spring frame (a lightweight control inversion (IoC) and a container frame facing to a tangent plane (AOP)) to scan mappers (mapping objects) under different paths to realize read-write separation; in the method, read-write data source data sources, namely ReadDataSource and WriteDataSource, need to be configured in the SpringBoot respectively, and then Mapper paths of the respective data sources are configured respectively to realize read-write separation. The most important point is that the slave libraries cannot be switched uniformly, multiple sets of configuration are needed, and if multiple slave libraries are used, multiple Read configuration files and Mapper files need to be configured.
Thirdly, completely depending on a springAop section scanning Mapper method; the method is non-invasive switching, avoids a second variety of manually configured data sources, can perform a simple load balancing algorithm on multiple slave libraries, also avoids a writing method of a forced master library under the first condition, and can solve the problem of the forced master library only by adding annotations, namely, two query methods with the same function exist in the read operation in the Mapper, one is master library check and the other is slave library check. The method has the defects that the method of switching the master and the slave into the write-dead mode cannot be dynamically changed, although the configuration code is reduced, the interface method is redundant, and the problem of code repetition is not completely solved.
Therefore, the existing database master-slave switching implementation schemes have various defects, and the technical problems that master-slave switching cannot be dynamically changed, codes are redundant, multiple slave libraries cannot be switched in a balanced mode and the like cannot be simultaneously solved.
Disclosure of Invention
The embodiment of the invention mainly aims to provide a method, a terminal and a storage medium for database master-slave switching, and aims to solve the technical problems that the master-slave switching cannot be dynamically changed, codes are redundant, multiple slave libraries cannot be switched in a balanced manner and the like, which cannot be simultaneously solved by the conventional database master-slave switching implementation scheme.
In order to achieve the above object, an embodiment of the present invention provides a method for database master-slave switching, where based on a server, the method includes the following steps: updating the data of the delay monitoring table at regular time to generate updating time; the updating time is inquired in a timed master-slave mode to calculate master-slave delay time difference; and sending the master-slave delay time difference to a client so that the client can make corresponding master-slave switching selection of the database according to the master-slave delay time difference.
Optionally, the step of updating the data of the delay monitoring table at regular time and generating the update time specifically includes: and automatically updating the data of the delay monitoring table every first preset time interval, generating updating time and writing the updating time into an updating time field of the delay monitoring table.
Optionally, the step of querying the update time by the timing master-slave to calculate the master-slave delay time difference specifically includes: inquiring the updating time field of the delay monitoring table in sequence through the master database and the slave database at every interval of second preset time to obtain first updating time and second updating time; and calculating the difference between the first updating time and the second updating time to obtain the master-slave delay time difference.
In addition, to achieve the above object, an embodiment of the present invention further provides a method for database master-slave switching, where based on a client, the method includes the following steps: receiving a master-slave delay time difference sent by a server, and storing the master-slave delay time difference into a common configuration object; comparing the master-slave delay time difference with a configuration threshold of the common configuration object to update a switch attribute of the common configuration object; and making corresponding database master-slave switching selection according to the switch attribute of the common configuration object.
Optionally, the step of comparing the master-slave delay time difference with the configuration threshold of the common configuration object to update the switch attribute of the common configuration object specifically includes: if the master-slave delay time difference is larger than the configuration threshold, a first attribute value is stored in the switch attribute; and if the master-slave delay time difference is smaller than or equal to the configuration threshold, saving a second attribute value into the switch attribute.
Optionally, before the step of making the corresponding database master-slave switching selection according to the switch attribute of the common configuration object, the method further includes: reading data of a manual intervention entrance to judge whether manual intervention configuration exists; if the manual intervention configuration exists, corresponding database master-slave switching selection is directly made according to the data of the manual intervention entrance; and if no manual intervention configuration exists, making corresponding database master-slave switching selection according to the switch attribute of the public configuration object.
Optionally, the step of making a corresponding database master-slave switching selection according to the switch attribute of the common configuration object specifically includes: if the switch attribute is a first attribute value, selecting to read data from a database; and if the switch attribute is the second attribute value, selecting a main database to read data.
In addition, in order to achieve the above object, an embodiment of the present invention further provides a terminal, where the terminal includes a memory, a processor, a program stored in the memory and executable on the processor, and a data bus for implementing connection communication between the processor and the memory, and the program implements the steps of the above method when executed by the processor.
In addition, to achieve the above object, an embodiment of the present invention further proposes a storage medium for computer-readable storage, where one or more programs are stored, and the one or more programs are executable by one or more processors to implement the steps of the above method.
According to the method, the terminal and the storage medium for switching the master and the slave of the database, when a client accesses the database of the server, the client firstly receives the master and slave delay time difference sent by the server and stores the master and slave delay time difference into a common configuration object. Then, the master-slave delay time difference is compared with a configuration threshold value of the common configuration object to update the switch attribute of the common configuration object. And finally, according to the switch attribute of the public configuration object, making corresponding database master-slave switching selection. Therefore, developers do not need to pay attention to the master-slave switching of the database on a code level, dynamic master-slave switching of the database can be automatically realized only by introducing a client jar packet and configuring a timeout threshold (namely a configuration threshold of a public configuration object) of master-slave delay time difference on the client, and the technical problems that the master-slave switching cannot be dynamically changed, the code redundancy, the multiple slave libraries cannot be switched in a balanced mode and the like which cannot be solved by the conventional implementation scheme of master-slave switching of the database are effectively solved.
Drawings
Fig. 1 is a flowchart of a method for database master-slave switching according to an embodiment of the present invention.
Fig. 2 is a detailed flowchart of step S120 of the database master-slave switching method shown in fig. 1.
Fig. 3 is a flowchart of a method for master-slave switching of a second database according to an embodiment of the present invention.
Fig. 4 is a detailed flowchart of step S220 of the database master-slave switching method shown in fig. 3.
Fig. 5 is a block diagram of a terminal according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
In the following description, suffixes such as "module", "component", or "unit" used to denote elements are used only for facilitating the explanation of the present invention, and have no specific meaning in itself. Thus, "module", "component" or "unit" may be used mixedly.
The terminal may be implemented in various forms. For example, the terminal described in the present invention may include a mobile terminal such as a mobile phone, a tablet computer, a notebook computer, a palmtop computer, a Personal Digital Assistant (PDA), a Portable Media Player (PMP), a navigation device, a wearable device, a smart band, a pedometer, and the like, and a fixed terminal such as a Digital TV, a desktop computer, and the like.
The following description will be given by way of example of a mobile terminal, and it will be understood by those skilled in the art that the construction according to the embodiment of the present invention can be applied to a fixed type terminal, in addition to elements particularly used for mobile purposes.
Example one
As shown in fig. 1, an embodiment of the present invention provides a method for database master-slave switching, where based on a server, the method specifically includes the following steps:
step S110: and updating the data of the delay monitoring table at regular time to generate updating time.
Specifically, the method for database master-slave switching of the present invention is mainly applied to the Sharding-JDBC framework sublevel scenario, and the method for database master-slave switching of the present embodiment is mainly applied to the server side providing the delayed discovery service. The server is configured with a delay monitoring table (three fields of id, touch and update time, and one piece of information exists), namely the delay monitoring table comprises an id field, a touch field and an update time field.
Taking the first preset time (which can be adjusted according to actual needs) as 1 second as an example, triggering a timing task once every 1 second, updating a touch field (touch +1) mod 2) of the delay monitoring table, updating the field every time, and synchronously updating a corresponding UPDATE time (UPDATE time) field by ON UPDATE CURRENT _ TIMESTAMP in MySQ L.
Step S120: the master-slave timing inquires the updated time to calculate the master-slave delay time difference.
Specifically, after the update time is obtained through the above method steps, the step "regularly master-slave query the update time to calculate the master-slave delay time difference" may be executed, as shown in fig. 2, the specific process is as follows:
step S121: and inquiring the updating time field of the delay monitoring table in sequence through the master database and the slave database every second preset time to obtain first updating time and second updating time.
Step S122: and calculating the difference between the first updating time and the second updating time to obtain the master-slave delay time difference.
Taking the second preset time (which can be adjusted according to actual needs) as 1 second as an example, every 1 second interval, the master database queries the update time field of the delay monitoring table to obtain a first update time, then the master database queries the update time field of the delay monitoring table to obtain a second update time, and the difference between the first update time and the second update time is calculated to obtain the master-slave delay time difference.
Step S130: and sending the master-slave delay time difference step to a client so that the client can make corresponding master-slave switching selection of the database according to the master-slave delay time difference.
Specifically, after the master-slave delay time difference is obtained through the steps of the method, the master-slave delay time difference can be sent to the client side, so that the client side can make corresponding database master-slave switching selection according to the master-slave delay time difference. The message notification service of the service end generally uses an MQ mode to perform asynchronous notification, and can also define a notification mode by user, such as a Netty mode or a Mina mode, so that the performance can be further improved.
Example two
As shown in fig. 3, an embodiment of the present invention further provides a method for database master-slave switching, where based on a client, the method includes the following steps:
step S210: and receiving the master-slave delay time difference sent by the server, and storing the master-slave delay time difference into a common configuration object.
Specifically, the method for master-slave switching of the database is mainly applied to a Sharding-JDBC framework database-sharing scenario, and the method for master-slave switching of the database is mainly applied to a client. And when the server sends the master-slave delay time difference to the client, the client can make corresponding database master-slave switching selection according to the master-slave delay time difference. The client executes the steps of receiving the master-slave delay time difference sent by the server and storing the master-slave delay time difference into a common configuration object. The master-slave delay time difference sent by the server is saved in a public configuration object dsProperties of the client.
Step S220: and comparing the master-slave delay time difference with a configuration threshold value of the common configuration object to update the switch attribute of the common configuration object.
Specifically, after the master-slave delay time difference sent by the server is stored in the public configuration object dsProperties of the client through the above method steps, the method step "compare the master-slave delay time difference with the configuration threshold of the public configuration object to update the switch attribute of the public configuration object" may be executed, as shown in fig. 4, the specific process is as follows:
step S221: if the master-slave delay time difference is larger than the configuration threshold, a first attribute value is saved in the switch attribute.
Step S221: and if the master-slave delay time difference is smaller than or equal to the configuration threshold, saving a second attribute value into the switch attribute.
The configuration threshold value can be adjusted according to actual needs, if the master-slave delay time difference is larger than the configuration threshold value, the first attribute value true is stored in the switch attribute of the public configuration object dsProperties, otherwise, the second attribute value false is stored in the switch attribute of the public configuration object dsProperties.
Step S230: and making corresponding database master-slave switching selection according to the switch attribute of the common configuration object.
Specifically, when the client needs to access the database of the server, the corresponding database master-slave switching selection can be made according to the switch attribute of the public configuration object. If the switch attribute is the first attribute value true, selecting to read data from the database; and if the switch attribute is the second attribute value false, selecting the main database for data reading.
In addition, in order to further provide flexibility of database master-slave switching and meet more scene requirements of developers, the client of the embodiment of the present invention further provides a manual intervention entry, that is, before the step of executing the method, "making corresponding database master-slave switching selection according to the switch attribute of the common configuration object" may further include: reading data of a manual intervention entrance to judge whether manual intervention configuration exists; if the manual intervention configuration exists, corresponding database master-slave switching selection is directly made according to the data of the manual intervention entrance; and if no manual intervention configuration exists, making corresponding database master-slave switching selection according to the switch attribute of the common configuration object.
When a filtering condition request method which accords with an AOP section filter exists, a database master-slave switching method (namely, an execution method is matched according to a self-defined method name filter (fuzzy matching of method names) is executed, if the method is customized for the filter, the database master-slave switching method is executed), at the moment, manual intervention configuration is preferentially processed, namely, whether a switch which is forcibly opened by one key of a manual intervention inlet is opened or not is detected, when the switch which is forcibly opened by one key of the manual intervention inlet is opened, manual operation intervention is carried out, all judgment is based on a manual setting result, master-slave delay is not judged, and after the switch is opened, all reading operations forcibly remove a master database (namely, a master database is selected for data reading) or forcibly remove the master database (namely, a slave database is selected for data reading). If no manual intervention is pre-configured, reading the public configuration objects dsProperties, and switching whether to use reading from the database according to the switch attribute of the public configuration objects dsProperties (namely, if the switch attribute is a first attribute value true, selecting to read data from the database, and if the switch attribute is a second attribute value false, selecting to read data from the main database).
EXAMPLE III
As shown in fig. 5, a third embodiment of the present invention provides a terminal 20, where the terminal 20 includes a memory 21, a processor 22, a program stored in the memory and capable of running on the processor, and a data bus 23 for implementing connection communication between the processor 21 and the memory 22, where the program is executed by the processor to implement the steps of the method for switching between master and slave of the database in the first embodiment or the second embodiment, which are described above specifically and are not described herein again.
It should be noted that, the embodiment of the terminal 20 in the embodiment of the present invention and the first method embodiment or the second method embodiment belong to the same concept, and specific implementation processes thereof are detailed in the first method embodiment or the second method embodiment, and technical features in the first method embodiment or the second method embodiment are correspondingly applicable in the embodiment of the terminal 20, which is not described herein again.
Example four
A fourth embodiment of the present invention provides a storage medium for computer-readable storage, where the storage medium stores one or more programs, and the one or more programs are executable by one or more processors to implement specific steps of the method for database master-slave switching in the first embodiment or the second embodiment.
It should be noted that the storage medium and the first method embodiment or the second method embodiment belong to the same concept, and specific implementation processes thereof are detailed in the first method embodiment or the second method embodiment, and technical features in the first method embodiment or the second method embodiment are correspondingly applicable to the storage medium embodiment, which is not described herein again.
According to the method, the terminal and the storage medium for switching the master and the slave of the database, when a client accesses the database of the server, the client firstly receives the master and slave delay time difference sent by the server and stores the master and slave delay time difference into a common configuration object. Then, the master-slave delay time difference is compared with a configuration threshold value of the common configuration object to update the switch attribute of the common configuration object. And finally, according to the switch attribute of the public configuration object, making corresponding database master-slave switching selection. Therefore, developers do not need to pay attention to the master-slave switching of the database on a code level, dynamic master-slave switching of the database can be automatically realized only by introducing a client jar packet and configuring a timeout threshold (namely a configuration threshold of a public configuration object) of master-slave delay time difference on the client, and the technical problems that the master-slave switching cannot be dynamically changed, the code redundancy, the multiple slave libraries cannot be switched in a balanced mode and the like which cannot be solved by the conventional implementation scheme of master-slave switching of the database are effectively solved.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (9)
1. A method for switching master and slave of a database is based on a server side, and is characterized by comprising the following steps:
updating the data of the delay monitoring table at regular time to generate updating time;
the updating time is inquired in a timed master-slave mode to calculate master-slave delay time difference;
and sending the master-slave delay time difference to a client so that the client can make corresponding master-slave switching selection of the database according to the master-slave delay time difference.
2. The method according to claim 1, wherein the step of updating the data of the delay monitoring table periodically and generating the update time specifically comprises:
and automatically updating the data of the delay monitoring table every first preset time interval, generating updating time and writing the updating time into an updating time field of the delay monitoring table.
3. The method according to claim 2, wherein the step of the timed master-slave querying the update time to calculate the master-slave delay time difference specifically comprises:
inquiring the updating time field of the delay monitoring table in sequence through the master database and the slave database at every interval of second preset time to obtain first updating time and second updating time;
and calculating the difference between the first updating time and the second updating time to obtain the master-slave delay time difference.
4. A method for database master-slave switching is based on a client and is characterized by comprising the following steps:
receiving a master-slave delay time difference sent by a server, and storing the master-slave delay time difference into a common configuration object;
comparing the master-slave delay time difference with a configuration threshold of the common configuration object to update a switch attribute of the common configuration object;
and making corresponding database master-slave switching selection according to the switch attribute of the common configuration object.
5. The method according to claim 4, wherein the step of comparing the master-slave delay time difference with the configuration threshold of the common configuration object to update the switch attribute of the common configuration object specifically comprises:
if the master-slave delay time difference is larger than the configuration threshold, a first attribute value is stored in the switch attribute;
and if the master-slave delay time difference is smaller than or equal to the configuration threshold, saving a second attribute value into the switch attribute.
6. The method of claim 5, wherein the step of making the corresponding database master-slave switching selection according to the switch attribute of the common configuration object further comprises:
reading data of a manual intervention entrance to judge whether manual intervention configuration exists;
if the manual intervention configuration exists, corresponding database master-slave switching selection is directly made according to the data of the manual intervention entrance;
and if no manual intervention configuration exists, making corresponding database master-slave switching selection according to the switch attribute of the public configuration object.
7. The method according to claim 6, wherein the step of making the corresponding database master-slave switching selection according to the switch attribute of the common configuration object specifically comprises:
if the switch attribute is a first attribute value, selecting to read data from a database;
and if the switch attribute is the second attribute value, selecting a main database to read data.
8. A terminal, comprising: memory, a processor, a program stored on the memory and executable on the processor, and a data bus for enabling a connection communication between the processor and the memory, the program, when executed by the processor, implementing the steps of the method according to any one of claims 1-7.
9. A storage medium for computer readable storage, wherein the storage medium stores one or more programs which are executable by one or more processors to implement the steps of the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010319897.XA CN111506560A (en) | 2020-04-22 | 2020-04-22 | Database master-slave switching method, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010319897.XA CN111506560A (en) | 2020-04-22 | 2020-04-22 | Database master-slave switching method, terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111506560A true CN111506560A (en) | 2020-08-07 |
Family
ID=71876281
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010319897.XA Pending CN111506560A (en) | 2020-04-22 | 2020-04-22 | Database master-slave switching method, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111506560A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115328799A (en) * | 2022-08-31 | 2022-11-11 | 广州品唯软件有限公司 | Database operation testing method, device, storage medium and computer equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106453297A (en) * | 2016-09-30 | 2017-02-22 | 努比亚技术有限公司 | Master and slave time delay detection method, device and system |
| CN108319617A (en) * | 2017-01-17 | 2018-07-24 | 阿里巴巴集团控股有限公司 | Determine the method, apparatus and method for handover control, device of database principal and subordinate's difference |
| US20180246928A1 (en) * | 2017-02-27 | 2018-08-30 | Sap Se | Measuring Snapshot Delay Between Source Database System and Its Asynchronous Replica |
| CN110334150A (en) * | 2019-06-05 | 2019-10-15 | 上海易点时空网络有限公司 | Monitor method, monitor terminal and the system of master-slave database synchronizing relay |
-
2020
- 2020-04-22 CN CN202010319897.XA patent/CN111506560A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106453297A (en) * | 2016-09-30 | 2017-02-22 | 努比亚技术有限公司 | Master and slave time delay detection method, device and system |
| CN108319617A (en) * | 2017-01-17 | 2018-07-24 | 阿里巴巴集团控股有限公司 | Determine the method, apparatus and method for handover control, device of database principal and subordinate's difference |
| US20180246928A1 (en) * | 2017-02-27 | 2018-08-30 | Sap Se | Measuring Snapshot Delay Between Source Database System and Its Asynchronous Replica |
| CN110334150A (en) * | 2019-06-05 | 2019-10-15 | 上海易点时空网络有限公司 | Monitor method, monitor terminal and the system of master-slave database synchronizing relay |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115328799A (en) * | 2022-08-31 | 2022-11-11 | 广州品唯软件有限公司 | Database operation testing method, device, storage medium and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111143382B (en) | Data processing method, system and computer readable storage medium | |
| US8751442B2 (en) | Synchronization associated duplicate data resolution | |
| CN112699151B (en) | Data processing method, device, equipment and medium | |
| CN111651424B (en) | Data processing method, device, data node and storage medium | |
| CN114741335B (en) | Cache management method, device, medium and equipment | |
| CN112214505B (en) | Data synchronization method, device, computer readable storage medium and electronic equipment | |
| CN113220342A (en) | Centralized configuration method and device, electronic equipment and storage medium | |
| CN111506560A (en) | Database master-slave switching method, terminal and storage medium | |
| CN115113989B (en) | Transaction execution method, device, computing equipment and storage medium | |
| CN113807968A (en) | Block chain user request processing method, device, request server and storage medium | |
| CN109325057B (en) | Middleware management method, device, computer equipment and storage medium | |
| CN109600738B (en) | User information updating method, device, equipment and storage medium | |
| CN115344585B (en) | Data version management method and device, storage medium and electronic equipment | |
| CN112702270B (en) | Node calling method, system and storage medium based on event distribution mechanism | |
| CN116701413A (en) | Main data processing method and device | |
| CN115495463A (en) | Data processing method and device, intelligent equipment and storage medium | |
| CN112632294B (en) | Method and system for synchronizing Neo4j data to search server | |
| CN115357577A (en) | Data storage method and device, storage medium and computer equipment | |
| CN115495146A (en) | Parameter configuration method and device, electronic equipment and storage medium | |
| US10114864B1 (en) | List element query support and processing | |
| CN108491448B (en) | Data pushing method and device | |
| CN110059080B (en) | Data processing method and device | |
| CN114564466A (en) | Database management system and method for managing database | |
| CN113157722A (en) | Data processing method, device, server, system and storage medium | |
| CN113076343A (en) | Data query method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200807 |