Database management method and device, server and storage medium

A management method and database technology, applied in special data processing applications, database design/maintenance, database distribution/replication, etc., can solve problems such as difficult recovery of faulty databases, data disorder and data corruption in data protection systems
CN110471909AActive Publication Date: 2019-11-19SHANGHAI DAMENG DATABASE
7 Cites 2 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Patent Type
Applications(China)
Current Assignee / Owner
SHANGHAI DAMENG DATABASE
Publication Date
2019-11-19

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a database management method and device, a server and a storage medium. The method comprises the steps of obtaining opening records in system tables corresponding to at least two databases; compairing opening records in all the system tables according to preset fields, wherein the preset fields comprise a first identifier and a first sequence value, the first identifier isan identifier corresponding to the fact that the target database currently enters the opening state, and the first sequence value is a current log sequence value of the target database; and determining attributes of each database according to a comparison result of the opening records, wherein the attributes comprise at least one of a main database, a standby database and a split brain database. According to the technical scheme, the system table is used for recording the opening record of the main library; the standby database synchronizes the content of the main database system table by replaying the Redo log, and whether the data of each database is consistent or not is compared by comparing the opening records of the system table, so as to determine the attributes of the database, thereby accurately determining the main database, the standby database and the split brain database, and improving the stability of database operation.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The embodiments of the present invention relate to the technical field of databases, in particular to a database management method, device, server and storage medium. Background technique

[0002] In the era of big data, a data protection system can be formed by using the active-standby architecture of the database. The data guard system consists of a main database and several standby databases. Among them, the main database provides data reading and modification services, and the standby database only provides read-only services. When the main database fails, the standby database will take over as the main database to continue to provide external services , so as to meet the user's demand for high availability of database services. The main database uses the redo (Redo) log to record the modification operations performed on the data. Each time the data is modified to generate a Redo log, a log sequence value LSN (Log Sequence Number) will be used to ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More