Unlock instant, AI-driven research and patent intelligence for your innovation.

Relational database processing system, client, server and method

A processing system and processing method technology, which is applied in the field of digital relational database processing systems, and can solve the problems that the database processing scheme cannot achieve high availability, and no solution has been proposed.

Pending Publication Date: 2020-07-28
CHINA CONSTRUCTION BANK
View PDF7 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, since MySQL is a stateful service, issues such as high data availability must be considered after running on multiple nodes.
However, current database processing solutions cannot achieve true high availability
[0003] For the above problems, no effective solution has been proposed

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
  • Relational database processing system, client, server and method
  • Relational database processing system, client, server and method
  • Relational database processing system, client, server and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0052] The inventor found that the existing database processing scheme and the technical problems therein:

[0053] 1. MHA solution: Open source MySQL high-availability program, regularly monitors the main library, when the main library fails, it will save binary log events (binlog) from the crashed main library, and switch the latest slave library to a new one master, and redirect other slaves to this new master. The advantage of this solution ...

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 relational database processing system, a client, a server and a relational database processing method. Data synchronization is carried out between master and slave databases and between the master database and a switchable master and slave database, wherein each database is provided with a client for monitoring the state of the current database; a deployment server in eachservice master control unit receives the current database states of all databases; when it is judged that the database breaks down according to the current database state, a database switching command is sent to the change controller; the scheduling controller sends the fault repair command to a change controller; the change controller executes database switching operation according to the switching command and executes fault repairing operation according to the fault repairing command; after completion, the updated current database states of all the databases are fed back to each service master control unit; and the proxy unit switches the access to the available database according to the current database state when receiving the access of the external application to the database. According to the technical scheme, high availability of the database service is realized.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a numerical relational database processing system, client, server and method. Background technique [0002] Relational databases such as MySQL, as a popular open source database today, can be flexibly expanded after being deployed on the cloud platform as a service, supporting greater business throughput when necessary. In addition, it can also save a large number of developers from installation, maintenance, backup, etc., which can greatly improve development efficiency. However, since MySQL is a stateful service, issues such as high data availability must be considered after running on multiple nodes. However, current database processing solutions cannot achieve high availability in the true sense. [0003] For the above problems, no effective solution has been proposed yet. Contents of the invention [0004] An embodiment of the present invention provides a relati...

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): G06F16/27G06F16/28G06F11/07G06F11/30
CPCG06F16/275G06F16/284G06F11/0709G06F11/0793G06F11/3006G06F11/3055G06F2201/80G06F2201/805
Inventor 毛颖
Owner CHINA CONSTRUCTION BANK