Data storage method and device for database

Abstract

The invention discloses a data storage method and device for a database, which are used for providing a data storage mode of the database with high efficiency and lower maintenance cost. In the application, the data processing device can record the first log when detecting the data change of the database, the first log is preferentially stored in the first memory, and when the data processing device determines that the storage space in the first memory is insufficient, for example, less than the first threshold value, the data processing device can be switched to the second memory to continue to record the first log, the first memory and the second memory are deployed in different devices. The log of the database is not limited in the local memory any more, and when the storage space in the first memory is insufficient, the first memory can be switched to other memories to continue to store the log, so that the data storage mode of the database is more efficient, the multiple memories can be deployed in different devices, a larger local disk is not needed any more, the disk maintenance cost of the database can be effectively reduced.

Description

technical field

[0001] The present application relates to the technical field of communications, and in particular to a data storage method and device for a database. Background technique

[0002] At present, the files involved in the database, such as the log for recording data changes in the database, the sorting files generated by performing efflux, etc., are usually placed on the same disk, such as a local disk or a cloud disk.

[0003] For the case where the files involved in the database service are placed on the local disk, more local disk space is required, which increases the maintenance cost.

[0004] For the case where the files involved in the database service are placed on the cloud disk, remote direct memory access (RDMA) technology is required to read the data in the cloud disk, and the data reading and writing efficiency is poor.

[0005] To sum up, there is an urgent need for an efficient and low-maintenance database data storage method. Contents of the i...

Examples

Embodiment Construction

[0033] Such as figure 1 As shown, it is a schematic structural diagram of a system provided by an embodiment of the present application, and the system includes a data processing device 100 , a first memory 200 and a second memory 300 .

[0034] The first memory 200 may include a volatile memory (volatile memory), such as a random access memory (random access memory, RAM). The first memory may also include a non-volatile memory (non-volatile memory, NVM), such as a read-only memory (read-only memory, ROM), a flash memory, a hard disk (hard diskdrive, HDD) or a solid-state disk (solid-state drive, SSD). The first memory may also include a combination of the above categories. The first storage 200 is similar to the second storage 300 , for details, refer to the foregoing content, and details are not repeated here. Wherein, the first storage 200 and the second storage 300 are deployed in different data centers and located in different devices, for example, the first storage 20...

technical field

[0001] The present application relates to the technical field of communications, and in particular to a data storage method and device for a database. Background technique

[0002] At present, the files involved in the database, such as the log for recording data changes in the database, the sorting files generated by performing efflux, etc., are usually placed on the same disk, such as a local disk or a cloud disk.

[0003] For the case where the files involved in the database service are placed on the local disk, more local disk space is required, which increases the maintenance cost.

[0004] For the case where the files involved in the database service are placed on the cloud disk, remote direct memory access (RDMA) technology is required to read the data in the cloud disk, and the data reading and writing efficiency is poor.

[0005] To sum up, there is an urgent need for an efficient and low-maintenance database data storage method. Contents of the i...

Examples

Embodiment Construction

[0033] Such as figure 1 As shown, it is a schematic structural diagram of a system provided by an embodiment of the present application, and the system includes a data processing device 100 , a first memory 200 and a second memory 300 .

[0034] The first memory 200 may include a volatile memory (volatile memory), such as a random access memory (random access memory, RAM). The first memory may also include a non-volatile memory (non-volatile memory, NVM), such as a read-only memory (read-only memory, ROM), a flash memory, a hard disk (hard diskdrive, HDD) or a solid-state disk (solid-state drive, SSD). The first memory may also include a combination of the above categories. The first storage 200 is similar to the second storage 300 , for details, refer to the foregoing content, and details are not repeated here. Wherein, the first storage 200 and the second storage 300 are deployed in different data centers and located in different devices, for example, the first storage 20...

Images