Database management method and device, server and storage medium

A management method and database technology, applied in database update, special data processing application, database distribution/replication, etc., can solve problems such as data corruption, data inconsistency, and data disorder in data guarding systems
CN110109934AActive Publication Date: 2019-08-09SHANGHAI DAMENG DATABASE
5 Cites 2 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Current Assignee / Owner
SHANGHAI DAMENG DATABASE
Publication Date
2019-08-09

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 transition records in control files corresponding to at least two databases; comparing the transition records in the control files; and determining the attribute of each database according to the comparison result of the transition records, wherein the attribute comprises at least one of a main library, a standby library and a split brain library. According to the technical scheme, the control file is used for recording the transition records of all the databases, whether the data of all the databases are consistent or not can be compared by comparing the transition records, the attributes of the databases are determined based on the transition records, the purpose of accurately determining the main database, the standby database and the schizophrenia database is achieved, and the database operation stability is improved.
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