Dynamic switching method and device based on multiple databases

Abstract

The invention provides a dynamic switching method and device based on multiple databases. The dynamic switching method based on the multiple databases comprises the steps that a relevant configuration file is read when a computer application system is started, wherein the configuration file comprises more than one key-value pair, each key is a database identification, and each value is a method name for accessing of a corresponding database; the database identifications in the configuration file are set in a thread pool of the computer application system; the method is intercepted when the method of the computer application system is called, a database identification corresponding to the method is obtained in the thread pool, and the intercepted method is released; the method is executed by means of the obtained database identification. The dynamic switching method and device based on the multiple databases have the advantages that read-write separation based on configuration can be achieved, and method-level database switching is achieved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a dynamic switching method and device based on multiple databases. Background technique [0002] When the database includes a master database and more than one slave database, the slave database synchronizes the data stored in the master database according to a fixed cycle. Computer application systems can write to the master database (including operations that change data content, such as adding, inserting, and deleting), and read from the slave database. A read operation or write operation performed by the computer application system on the master database or from the database is called a method; multiple methods form a class, and in a class of methods, all methods perform the same operation on the same database (that is, read operation or write operation). [0003] In the prior art, a corresponding database identifier (that is, a data source) is added to each database-read...

AI Technical Summary

Problems solved by technology

[0004] In order to realize the switch between multiple databases of the computer application system, it is necessary to completely separate the read operation method and the write operation method into different program codes, which not only destroys the structure of the computer application system, but also hinders the development of the computer application system. Increase the cost; moreover, the existing technology can only realize the database switch of the object level (that is, for the class), and cannot realize the database switch of the method level; at the same time, because the corresponding database identification is set for each type of method in advance, after the computer application system starts All the classes that need to read and write the database have been initialized, so the dynamic switching of the database cannot be realized when the computer application system is running

Images