Read and write data separation scheduling method, device, equipment and medium

Abstract

The invention discloses a read-write data separation scheduling method, device, equipment and medium. Wherein, the method includes: collecting SQL information and its corresponding service information; parsing the SQL information into hint HINT information; registering the SQL information and corresponding service information to the SQL resource pool according to the preset structure information according to the hint HINT information; Call the information of the SQL resource pool, add and calculate the prompt HINT information, and generate the read-write type of the service according to the operation result; query the data source connection label corresponding to the read-write type according to the read-write type of the service; and send it to the application server to use The application server connects to the corresponding database according to the data source connection label to perform separate scheduling of reading and writing data. The invention can realize the loose coupling of application and data, flexibly realize the separation of reading and writing of the system, and solve the problems of incomplete separation of reading and writing and inflexible control.

Description

technical field [0001] The present invention relates to the technical field of overall framework for business support in the telecommunication industry, and in particular to a read-write data separation scheduling method, a read-write data separation scheduling device, computer equipment, and a computer-readable medium. Background technique [0002] At present, the business support system is getting bigger and bigger, and the number of reads and writes of the underlying data is becoming more and more frequent. Too many reads and writes bring huge overhead to the system I / O, especially for too many cross-node reads and writes. The database architecture in RAC mode will bring a large number of global buffer caches, which poses a huge challenge to the operation of the database. [0003] In order to solve the system bottleneck caused by high I / O, the first step is to continuously improve the performance of the hardware. If these read I / O operations can be separated from the pro...

AI Technical Summary

Problems solved by technology

[0007] Restricted development: Since system services require separate configuration and point to different databases, it is difficult to sort out applications, and this method requires separate consideration of the development of certain functions in the application architecture (such as adopting and producing different tables), resulting in application The system architecture is complex, and many codes are repeatedly developed

[0008] Restricted use: After an emergency or disaster recovery switchover occurs in the production system, the data sources used independently for this part of the read-only business system will be affected (the emergency database used has already assumed the production status or cannot replicate data), resulting in These split read-only application functions are unavailable or enabled, resulting in a sharp drop in disaster recovery system performance

[0009] Limited scope: This mode can only consider certain business types that can be strictly separated from daily production, resulting in limited business types for reading and writing classification, which is not conducive to full application control, and cannot fundamentally solve the problem of databases caused by reading and writing sharing Problems with GLOBAL BUFFER CA Che

Images