PostgreSQL (postgres structured query language) cloud storage filing and scheduling system

Abstract

The invention discloses a postgreSQL (postgres structured query language) cloud storage filing and scheduling system. The postgreSQL cloud storage filing and scheduling system for monitoring multiple nodes together in the cloud storage by a uniform scheduling system is provided. A network monitoring module is respectively connected with a postgreSQL database module of a client, a cloud storage proxy server and a scheduling module, the postgreSQL database module of the client is connected with a fingerprint information unit which is backed up in the data of the client, a cloud node unit is respectively connected with the scheduling module and an information configuration unit, and the scheduling module is respectively connected with the fingerprint information unit with a backed-up database, a cloud storage path unit, a unit of the corresponding relationship between the backed-up database and the path, a filing switch state unit of log files and a priority level unit of the cloud storage path. The postgreSQL cloud storage filing and scheduling system is mainly applied to the postgreSQL cloud storage filing and scheduling technology of the pre-written log files.

Description

technical field [0001] The present invention relates to the technical field of cloud storage archiving scheduling, in particular to a pre-written log file PostgreSQL cloud storage archiving scheduling technology, in particular to a PostgreSQL cloud storage archiving scheduling system. Background technique [0002] PostgreSQL provides a point-in-time recovery (PITR) function. Through PITR, PostgreSQL can be restored to any point in time from the basic backup time to the final state time. The realization of this function depends on the write-ahead log file (WAL) Continuous archiving, and basic backup of the database. Continuous archiving means that no backup of a write-ahead log file can be missed. According to the activeness of the cloud storage PostgreSQL database on the scheduling of write-ahead log files, the frequency of PostgreSQL databases to generate write-ahead log files (WAL) varies, and changes in the business volume carried on the PostgreSQL database will also cau...

AI Technical Summary

Problems solved by technology

[0010] The present invention aims to solve the problem that the existing cloud storage resource scheduling system does not perform unified management and monitoring on multiple nodes in the cloud storage, it is difficult to manage the redundancy of the archive storage, the smooth scalability of the archive storage is poor, the single point of failure cannot be overcome, and the scalability is poor , poor shrinkage, and the lack of reasonable use of the scattered storage space of the Internet data center, we provide a unified scheduling system to meet the unified management and unified monitoring of multiple nodes in cloud storage. The redundant management of archive storage is simple, and archive storage can be used. Smooth scaling management effect is a PostgreSQL cloud storage archiving scheduling system

Images