Database management method and database system

A management method and database technology, applied in relational databases, database models, electronic digital data processing, etc., can solve problems such as system data confusion, data loss, and low data stability, and achieve data double-writing, data loss prevention, The effect of improving stability

Inactive Publication Date: 2017-11-21
SUNING COM CO LTD
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the data is not written to the Slave node after degrading to asynchronous replication, it is easy to cause this data loss, resulting in data confusion in the system
Moreover, when the Master node fails, the corresponding Slave node needs to be upgraded to the Master node. However, due to inaccurate fault judgment or false positives by the system, after the Slave node is upgraded to a new Master node, the original Master node remains In the operation situation, writing data at this time will cause the "double writing" problem of data writing to two Master nodes, which further aggravates the data confusion in the system, resulting in low data stability

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to enable those skilled in the art to better understand the technical solutions of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Hereinafter, embodiments of the present invention will be described in detail, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention. Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the description of the present invention refe...

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

Embodiments of the invention disclose a database management method and a database system, and relate to the technical field of databases. The stability of data reading / writing in the system can be improved. The method comprises the steps of receiving to-be-written data sent by user equipment, and writing the to-be-written data into a Master node in a cluster; transmitting the to-be-written data to at least two Slave nodes corresponding to the Master node and located in a partition where the Master node is located from the Master node, and detecting whether the Master node receives a response message sent by at least one Slave node, wherein the response message is sent by the Slave node successfully written with received data; and if the Master node receives the response message sent by the at least one Slave node, sending a notification message to the user equipment, wherein the notification message is used for representing a database successfully written with the to-be-written data. The method is suitable for data reading / writing management of a relational database.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database management method and a database system. Background technique [0002] Relational database is a type of database widely used at present. In the construction of relational database, it usually needs to be clustered by multiple data servers. MySQL (a relational database management system) is currently a commonly used relational database management system and is used to manage clusters. [0003] In the current cluster solution based on MySQL design, it is necessary to configure the nodes to assume the role of Master and Slave respectively. The data submitted by the user device will be written to the Master node and the Slave node in the form of semi-synchronous replication, thereby improving the data writing process. security. [0004] In the actual operation of the system, many problems such as network congestion, data writing errors, and equipment failures will also...

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/30
CPCG06F16/284G06F16/21
Inventor 陈华军
Owner SUNING COM CO LTD
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