Proxy server and data processing method and system of database

Abstract

An embodiment of the invention discloses a data processing method of a database. The data processing method includes: when receiving write operation requests transmitted form a client side, searching first master database information matched with the write operation requests in a preset main cluster list including at least one master database information according to the write operation requests; according to the first master database information, transmitting the write operation requests to a first server corresponding to the first master database information; when receiving successful signals that the first server returns in-write data to a first master database, searching the first back-up database information matched with the write operation requests in a preset standby cluster list including at least one back-up database information; according to the first back-up database information, transmitting the write operation requests to a second server corresponding to the first back-up database information. By the acting server and data processing method and system, security of data of the back-up database is effectively improved.

Description

technical field [0001] The invention relates to the communication field, in particular to a database data processing method, proxy server and system. Background technique [0002] At present, the data of the server is generally stored in the database of the server. When the client reads and writes the data on the server, it usually reads and writes the data by accessing the database of the server. However, if too many clients read and write to the database of the server, the IO port of the disk where the database is located may be congested or even paralyzed, causing the speed of the client to read and write the database to be too slow, so that the database cannot provide efficient services. [0003] Therefore, in order to improve the reading and writing speed of the client to read and write the database, at present, most of the methods adopted are to cache the database in the memory, so that the client can directly access the database from the server's memory. We can call ...

AI Technical Summary

Problems solved by technology

However, when the slave database is enabled abnormally in the master database, the client needs to be restarted to obtain the address of the slave database to operate on the slave database, which will cause the database to interrupt service and cause inconvenience to users, and when the slave database is damaged When restoring the data of the primary database, it will take a lot of time to copy and affect the normal operation of the server

Images