Internal and external network database optimization method based on read-write separated information system

Abstract

Provided is an internal and external network database optimization method based on a read-write separated information system. The method comprises: zoning storage of internal and external network databases, and separating read-write; snapping to an external network, and combing partitions to a plurality of libraries in a same instance; optimizing distributed database query; optimizing distributed database writing service; and recording optimizing logs, and other phases. The beneficial effects of the internal and external network database optimization method based on the read-write separated information system are that purposes of the method use data scatter storage and query concurrent execution as a main clue, so mass data is effectively organized, and query performance of mass data is improved. The method is creative optimization design for mass data and a high concurrency query platform at present stage.

Description

technical field [0001] The invention belongs to the technical field of enterprise informatization, and in particular relates to a method for optimizing an internal and external network database of an information system based on the separation of reading and writing. Background technique [0002] In the context of the increasing popularity of informatization, the enlargement and complexity of information systems is an inevitable trend. At present, most large-scale information systems use read-write separation technology at the database level, with one master database and multiple slave databases. The main library is responsible for data update and real-time data query, and the slave library is responsible for non-real-time data query. Because in practical applications, the database reads more and writes less (that is, the frequency of reading data is high, and the frequency of updating data is relatively small), and the more complex the system, the more system data, and the ...

AI Technical Summary

Problems solved by technology

Because in practical applications, the database reads more and writes less (that is, the frequency of reading data is high, and the frequency of updating data is relatively small), and the more complex the system, the more system data, and the more complex the query statement, the more complex the data read. The longer it takes, the more CPU is occupied by the database server, which reduces system performance and affects user experience.

However, the existing database read-write separation technology simply separates the read-write library to improve the concurrency rate, but does not solve the problems such as inconvenient data synchronization between the internal and external networks, too large database and complex query statements, resulting in slow query and other problems.

Images