Fault database switching method and system used for distributive database cluster

A technology for switching systems and databases, applied in the field of fault database switching methods and systems of distributed database clusters, can solve problems such as data loss and adverse cluster effects, and achieve the effects of reducing load, improving accuracy, and ensuring normal work.

Active Publication Date: 2016-11-16
上海优玩网络科技有限公司
View PDF3 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, using the MySQL cluster method will have the following disadvantages: if a single MySQL fails during use, it will have a very large adverse impact on the entire cluster, and if the database is switched at this time, some data will be lost

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
  • Fault database switching method and system used for distributive database cluster
  • Fault database switching method and system used for distributive database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention will be described in further detail below in conjunction with the accompanying drawings and embodiments.

[0025] see figure 1 As shown, the distributed database cluster in the embodiment of the present invention includes at least one server carrying a master database (the number of master databases increases according to the amount of data traffic in practical applications), and each master database corresponds to a shard route ; Each server carrying the master database corresponds to a server carrying the slave database (the slave database is used to back up the log information of the master database). Each server is set with a physical IP, and the physical IP of the server carrying the main database is associated with the virtual IP of the fragment routing.

[0026] On this basis, see figure 2 As shown, the faulty database switching method for distributed database clusters in the embodiment of the present invention includes the following step...

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 fault database switching method and system used for a distributive database cluster, relating to the fault switching field for distributive databases of back-end internet. The method comprises following steps: monitoring all primary databases in the database cluster, and determining the current primary database as a fault database when the primary database with false faults are monitored and instance ports of databases of the current primary database work abnormally; if a fault sever does not go down and the fault database instances go down, backing up log information before the fault databases are switched; and directly switching fault databases if the fault databases go down. The fault database switching method and system used for the distributive database cluster have following beneficial effects: if databases of the distributive database cluster fail, fault databases are rapidly switched and data is not lost to the maximum extent; meanwhile, high precision is obtained for survey of fault databases and load for work is small.

Description

technical field [0001] The invention relates to the field of failover of Internet back-end distributed databases, in particular to a failover database switching method and system for distributed database clusters. Background technique [0002] With the expansion of the scale of Internet services, the number of users using Internet services has increased significantly, which in turn has caused a sharp increase in the network data of the Internet. On this basis, the traditional architecture relying on a single server to carry the database can no longer provide complete services for a large number of network data services. In order to ensure the service quality of a large number of network data services, the database must be expanded. [0003] At present, a common way to expand the database in the Internet field is to split the data horizontally, so that the MySQL (relational database) cluster method that relies on shard routing is increasingly used by more and more Internet co...

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 Applications(China)
IPC IPC(8): G06F17/30G06F11/07
CPCG06F11/0709G06F16/21
Inventor 赵闪
Owner 上海优玩网络科技有限公司
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