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

Database switching method and database switching system

A database and master database technology, applied in the field of database management, can solve the problems of increased loss and inability to perform rollback operations, etc., and achieve the effect of smooth switching and fast rollback

Active Publication Date: 2017-04-12
ADVANCED NEW TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of this application is to provide a database switching method and a database switching system to solve the problems existing in the prior art, such as the increased loss caused by suspending the business switching database, and the inability to perform rollback operations when a failure occurs during the switching process and the machine is down, etc. questions, among them:

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

[0040] The main idea of ​​this application is to propose the following solutions for the problems existing in the prior art: firstly, keep the service available. When the business is running normally, switch the database through a switch, and add a compatibility state during the process of switching the database, allowing the current data source (hereinafter also referred to as the primary data source) and the data source to be switched (hereinafter also referred to as the backup) Data source) is managed by the application system (that is, the business management system) at the same time, and ensures that the business request in the switching process selects the correct data source through compatibility processing. Moreover, the switch can be used to quickly switch the state. In the event of an abnormality in the system, the switch can be used to quickly roll back to the previous stable state and still provide normal services. After the problem is fixed, the switch state can be...

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 provides a database switching method and a database switching system. The method comprises the steps that a compatible switch of each server is started to start a compatible logic module of the corresponding server, the compatible logic modules execute compatible processing of service compatibility of a main database and a spare database, a data source building logic module makes the main database be built into a main data source and makes the spare database be built into a spare data source on the basis of the switched-off states of data source switches; the data source switch of each server is switched on, so that each server is connected with the spare database rather than being connected with the main database, the compatible logic modules continue to execute compatible processing, and the data source building logic module makes the main database be built into the spare data source and makes the spare database be built into the main data source on the basis of the switched-on states of the data source switches; the compatible switch of each server is switched off after preset time.

Description

technical field [0001] The present application relates to the field of database management, in particular to a database switching method and a database switching system. Background technique [0002] In the application of the database, the switching of the database may include database splitting, failover (failover) and other manners. Among them, database splitting is a way to increase system capacity. By splitting the data processed in one database into multiple databases according to certain rules, the pressure on a single database is reduced and the system capacity is doubled. Database splitting methods are mainly divided into vertical splitting according to business and horizontal splitting for hot tables. Failover means database failover. After the database fails and goes down, it uses its own mechanism to complete the switch from the primary database to the standby database in a short time and continue to provide protection measures for normal services. In other word...

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): G06F17/30
CPCG06F11/1448G06F11/1464G06F16/27
Inventor 李铮
Owner ADVANCED NEW TECH CO LTD
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