Main and standby database delay time processing method and device, medium and electronic equipment

Abstract

The invention relates to a main and standby database delay time processing method and device, a storage medium and electronic equipment. The method comprises the following steps: monitoring a preset operation method of a data access object DAO layer, and judging the category of the preset operation method according to a preset annotation carried by the preset operation method; when it is judged that the preset operation method is a query operation, obtaining a delay data difference threshold value corresponding to the query operation from a preset annotation, wherein the delay data differencethreshold value is in direct proportion to the read-write delay time; obtaining the maximum first data record ID in the current main database and the standby database, and calculating the difference between the two obtained maximum first data record IDs; and comparing the difference value with a delay data difference threshold, and if the difference value is greater than or equal to the delay datadifference threshold, routing the corresponding query operation to the main database. According to the invention, different read-write delay times can be set for different service scenes, the application range is wide, the scheme development is simple and convenient, and the manpower and material resource cost is saved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a delay time processing method for active and standby databases, a delay time processing device for active and standby databases, and a computer-readable storage medium and electronic equipment for implementing the delay time processing method for active and standby databases. Background technique [0002] At present, in order to alleviate the pressure on database servers, many companies such as large Internet companies often use databases with read-write separation between active and standby. The principle of master-slave read-write separation is to route the operations of modifying data to the primary database for execution, and route the operations of querying data to the standby database for execution, and then use the master-slave replication function of the database to synchronize the operations of the primary database to the standby database. database to ens...

AI Technical Summary

Problems solved by technology

However, there are the following problems in the current related technology using the database MySQL-Proxy plug-in to write Lua scripts, for example, it is not possible to set different read and write delay timeouts for different query scenarios, and it is not possible to alarm when the read and write delay is too high. It is also impossible to modify the read and write delay timeout in real time and respond immediately

Images