Data page disk refreshing method and device, equipment, and storage medium

Abstract

The embodiment of the invention discloses a data page disk refreshing method and device, equipment, and a storage medium. The method is applied to a database cluster, wherein the database cluster comprises a main database and at least two standby databases; the method comprises the following steps: the main library sends heartbeat messages or generated log packets to each standby library; the standby libraries extract a second submitted log sequence in a currently replayed log packet and a maximum log sequence in the last log packet written into the local disk, and obtain a page log sequence in a current to-be-refreshed disk data page; the standby libraries judge whether the to-be-refreshed disk data page meets disk refreshing conditions or not according to a first submitted log sequence, the second submitted log sequence, the maximum log sequence and the page log sequence; if the disk refreshing conditions are met, writing data in the to-be-refreshed data page into a local disk. The problems of insufficient data page cache and replay jamming of the standby libraries can be avoided, so that the database cluster can be ensured to run properly and stably.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of databases, and in particular, to a method, device, device, and storage medium for flashing data pages. Background technique [0002] With the rapid development of information technology, databases play an extremely important role in daily work, business activities and people's lives. In order to avoid downtime during database use and unable to provide services normally, existing applications often adopt the method of building database clusters, that is, multiple databases are divided into main database and standby database, so that the standby database can continue to provide services when the main database is down. Serve. [0003] In order to ensure the data synchronization of each database in the database cluster, a log package is generated when data modification operations such as addition, deletion, and modification are performed on the main database, and the log package is sent...

AI Technical Summary

Problems solved by technology

[0004] In the prior art, when the packet sequence number or log sequence of the log package being reproduced by the standby database is smaller than the packet sequence number or log sequence submitted by the primary database, at this time, the standby database replay needs to allocate new data pages, but the standby database appears If the data page cache is insufficient and cannot be allocated, the standby database will try to flush the allocated data pages to eliminate and release the available data page cache. The committed log sequence is relatively small. When trying to flush the data pages, it will be limited by the committed log sequence, so that some data pages cannot be flushed. As a result, the standby database cannot allocate new data pages and cannot continue to repeat, resulting in The library is abnormal and cannot provide read-only services to the outside world.

Images