Database table switching method and device, electronic equipment and computer storage medium

Abstract

The embodiment of the invention discloses a database table switching method and device, electronic equipment and a computer storage medium, and the method comprises the steps: receiving a database table switching request, confirming a target logic database where a to-be-switched source table is located, and creating an intermediate table in the target logic database according to the to-be-switched source table; copying data in the source table to be switched into the intermediate table; and receiving a table switching command, and switching the related operation of the to-be-switched source table to the intermediate table after the completion of data copying is confirmed. According to the technical scheme, the situation of read-write errors during data migration can be avoided, the data read-write time is greatly shortened, the data read-write efficiency is improved, improvement of the data service quality is facilitated, meanwhile, the data table switching workload can be greatly reduced, and waste of computing resources is avoided.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular to a database table switching method, device, electronic equipment, and computer storage medium. Background technique [0002] With the development of data technology, the application of database is becoming more and more extensive, and more and more data needs to be stored in the database. However, if the database is too large, especially when the data writing operation is too frequent, it will It brings huge pressure, and at the same time greatly reduces the efficiency of data writing and data reading. The existing technology usually distributes the data stored in the same database to multiple databases according to certain preset conditions, or distributes the data stored in the same data table in a certain database to multiple data tables, so that It achieves the effect of dispersing the pressure of data writing and reading and improving the effi...

AI Technical Summary

Problems solved by technology

Although the above processing method can avoid reading and writing errors during data migration, due to the setting of a global write ban, the read and write permissions can only be opened after all data migration is completed, which will greatly affect the data read and write time. , which reduces the efficiency of data reading and writing, which is not conducive to the improvement of data service quality. In addition, due to the different names of the data tables before and after switching, it will lead to a large-scale update of data such as links that refer to the data tables, which greatly increases the data. The workload of table switching leads to the waste of computing resources

Images