Data base read-write system and method

Abstract

The invention discloses a system and method for reading and writing a database. The system for reading and writing the database of the present invention includes: a writing server, a synchronization unit and at least one reading server; the writing server is used to receive the data written by the user and store it in the writing database; the synchronization unit is used to Synchronize the data written by the user to the reading database of the reading server; the reading database is used to store the reading database for the user to read data. The database reading and writing method of the present invention includes: writing data into a writing database; synchronizing said data to at least one reading database; connecting said at least one reading database to read data. The invention can realize fast reading and writing of the database.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a system and method for reading and writing a database. Background technique [0002] With the advent of the information age and the rapid development of the Internet, searching for information online has become a part of people's daily life; many large-scale websites provide people with fast and rich information and win people's favor. A large number of users visit these sites every day. Websites pose a great challenge to the stable operation of these website databases. [0003] In the prior art, the databases are all on one server. Existing technology 1, the method of sub-table is used to solve the query pressure of the database, that is, the database is classified according to the content, and the content of different categories is stored in different tables; but as the content of the database increases, the number of table splits There are also more and more, and the time for...

AI Technical Summary

Problems solved by technology

Existing technology 1, the method of sub-table is used to solve the query pressure of the database, that is, the database is classified according to the content, and the content of different categories is stored in different tables; but as the content of the database increases, the number of table splits There are also more and more, and the time for users to access web pages to connect to the database will also increase. Users cannot see the content to be accessed for a long time, and the experience is very poor.

The second prior art uses caching technology to alleviate the query pressure of the database, stores infrequently queried content in the database, and frequently queried content but infrequently updated content is stored in an array file, which acts as a cache , the user can connect to the array file at a faster speed, which relieves the query pressure on the database; however, the caching technology does not work for websites that need to be updated frequently (such as forums), and the scope of application is limited

When the database is accessed in large quantities, the reading of the database is affected, and the connection speed is slow. Similarly, the writing of the database will also be affected, and the writing speed is slow, which affects the update of the database.

Images