Database switching method and database switching system

A database and table data technology, applied in the database field, can solve problems such as time-consuming database data recovery, unavailable business systems, high costs, etc., and achieve the effects of saving storage costs and server resources, saving backup space, and improving switching efficiency

Active Publication Date: 2019-06-07
CHINA CONSTRUCTION BANK
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the dual-machine storage redundancy solution requires at least double the investment in the storage environment, and the cost is high
In addition, in order to solve the logic failure of the database (for example, necessary files are deleted by human error, etc.), the existing technology generally recovers through the existing full backup of the database, and then restores to the nearest backup node through incremental backup, which leads to the data loss of the database Recovery takes a long time, making the business system unavailable for a long time

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 switching method and database switching system
  • Database switching method and database switching system
  • Database switching method and database switching system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings.

[0037] First, explain some of the vocabulary involved or possibly involved in the present invention:

[0038] Dual-machine: The two servers in the high-availability system ensure data integrity and continuity based on shared storage, and use dedicated software to manage the logical switching of resources between the two servers.

[0039] Production database: The main database that provides services to the business in the production environment.

[0040] Production library server: the host with the production library installed.

[0041] Emergency database: A database used to take over production operations when the production database is unavailable.

[0042] Emergency database server: the host computer with emergency database installed.

[0043] figure 1 is a schematic flowchart of a database switching me...

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 switching method and a database switching system. The method comprises the following steps: installing a production library server of a production library to periodically export the table structural information of the production library and the table data of a specified table; mounting an emergency library server of an emergency library to periodically obtain the table structural information of the production library and the table data of the specified table, and reconstructing a database containing the table data in the emergency library with the same database nickname as the production library; when the emergency library server needs to be switched to, adopting a database communication configuration file of the emergency library server to replace a database communication configuration file of the production library by an application server, or breaking off the network connection of the production library server, and correcting the original network configuration of the emergency server according to the network configuration of the production library server to replace the production library server by the emergency library server. The adoption of the method and the system shortens business interruption time and improves switching efficiency under the condition of saving backup space.

Description

technical field [0001] The present invention relates to the field of databases, and more specifically, to a database switching method and a database switching system. Background technique [0002] In the prior art, a dual-machine storage redundancy solution is adopted to solve the problem of easy data loss and interruption of data services of the business system in a single point of storage. However, the dual-machine storage redundancy solution requires at least double the investment in the storage environment, and the cost is high. In addition, in order to solve the logic failure of the database (for example, necessary files are deleted by mistake, etc.), the existing technology generally recovers through the existing full backup of the database, and then restores to the nearest backup node through the incremental backup, which leads to the data loss of the database Recovery takes a long time, making the business system unavailable for a long time. Contents of the invent...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F11/14
CPCG06F16/2282G06F16/27
Inventor 李世宁马楠赵子健
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap