Method, system and equipment for controlling data writing

Abstract

The embodiment of the invention discloses a method, a system and equipment for controlling data writing. The method comprises the following steps of obtaining disc distribution information of dirty data pages of a plurality of database instances; according to the disc distribution information of the dirty data pages, generating data writing strategies for the database instances; and distributing the data writing strategies to the database instances, so as to enable each database instance to write the dirty data pages in a buffer into a disc array according to the distributed data writing strategies. The method, the system and the equipment have the advantages that according to the disc distribution information of the database instances, the control equipment is used for uniformly controlling and coordinating the writing strategies of the dirty data pages of the database instances; and as the control equipment can control the database instances to averagely write the dirty data pages into discs in the disc array at each time according to the writing strategies, the I/O (input/output) efficiency of the disc array is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method, system and equipment for controlling data writing. Background technique [0002] In the shared disk cluster database system, multiple databases are included, each database corresponds to at least one database instance, and each database instance can write the dirty data pages in the buffer to the corresponding disk through the database internal event Checkpoint (checkpoint) In , multiple disks form a disk array for persistent storage of dirty data pages. In the prior art, when writing dirty data pages, each database instance can pre-set the threshold of dirty data pages, and when the number of dirty data pages in the buffer of the database instance reaches the threshold, the checkpoint writing process will be triggered to Dirty data pages are written from the buffer to disk. [0003] The inventor found in the process of researching the prior art that for a clustered...

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a method, system and device for controlling data writing to solve the problem in the prior

Images