Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

Active Publication Date: 2019-08-09
SHANGHAI DAMENG DATABASE
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the LSN itself does not have a clear logical meaning. The same LSN does not mean that the corresponding modification content is also the same. It is impossible to judge whether the fault database is completely consistent with the data of the current main database based on the LSN, and it is impossible to accurately identify the attributes of the database. If the database Errors in the identification of attributes will lead to data inconsistency and data corruption between databases. If the split-brain database is further used to switch between active and standby, the data in the entire data protection system will be confused. The faulty database is difficult to recover, and the database cannot run normally and stably.

Method used

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
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database management method and device, server and storage medium
  • Database management method and device, server and storage medium
  • Database management method and device, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] figure 1 It is a flow chart of database management provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation where the primary database, standby database, and split-brain database are managed in the data protection system. Specifically, the database management method can be executed by a database management device, and the database management device can be realized by means of software and / or hardware, and integrated into a server. Further, the server includes but not limited to: industrial integration server, system background server and cloud server.

[0041] refer to figure 1 , the method specifically includes the following steps:

[0042] S110. Obtain transition records in the control files corresponding to at least two databases.

[0043] Specifically, in the data guardian system, the primary database and the standby database will each deploy a daemon process locally, and the daemon process will communicate with the local ...

Embodiment 2

[0058] figure 2 It is a flow chart of a database management method provided by Embodiment 2 of the present invention. This embodiment is optimized on the basis of the above embodiments, and further explains the determination of the attributes of each database according to the comparison results of transition records. It should be noted that for technical details not exhaustively described in this embodiment, reference may be made to any of the foregoing embodiments.

[0059] Specifically, refer to figure 2 , the method specifically includes the following steps:

[0060] S201. Acquire transition records in control files corresponding to at least two databases.

[0061] Further, the change records in the control files of each database are regularly obtained, so as to regularly update the database attributes and identify the split-brain database in time.

[0062] S202. Compare transition records in each of the control files.

[0063] S203. Whether the content of each transi...

Embodiment 3

[0104] image 3 It is a schematic structural diagram of a database management device provided by Embodiment 3 of the present invention. The database management device provided in this embodiment includes:

[0105] An acquisition module 310, configured to acquire transition records in control files corresponding to at least two databases;

[0106] A comparison module 320, configured to compare transition records in each of the control files;

[0107] The management module 330 is configured to determine the attribute of each database according to the comparison result of the transition record, and the attribute includes at least one of the main database, the standby database and the split-brain database.

[0108] In the database management device provided by Embodiment 3 of the present invention, the acquisition module acquires the transition records in the control files corresponding to at least two databases, and the comparison module compares the transition records in each ...

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

PUM

No PUM Login to View More

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.

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

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/23G06F16/27
CPCG06F16/2358G06F16/27
Inventor 王蒙蒙
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com