MySQL database replication method based on ISER protocol

A replication method and database technology, applied in the database field, can solve problems such as host asynchrony and data loss, and achieve the effect of zero data loss

Inactive Publication Date: 2017-11-07
JIANGSU SECURITIES
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention aims at the existing MySQL master-slave replication process, if a disaster occurs in the main machine (for example, the main machine is down), the data of the standby machine may be out of sync with the main machine, thereby causing the defect of data loss, and provides an improved data recovery method that can realize data loss. Zero Loss MySQL Database Replication Method

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
  • MySQL database replication method based on ISER protocol
  • MySQL database replication method based on ISER protocol
  • MySQL database replication method based on ISER protocol

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The present invention will be further described below in combination with specific embodiments and accompanying drawings.

[0031] figure 1 It is a schematic diagram of MySQL database replication method. figure 2 It is a flowchart of MySQL database replication. image 3 It is a flow chart of processing when a disaster occurs on the host.

[0032] Hardware environment:

[0033] (1) Two X86 PC servers are connected through a common Ethernet LAN,

[0034] (2) At least two or more disks for each X86 PC server,

[0035] (3) Two X86 PC servers are connected through an InfiniBand (each PC server needs an HCA card).

[0036] Implementation steps:

[0037] Step 1. Install the MySQL database on the two PC servers normally (the process is omitted).

[0038] Step 2. First build master-slave replication.

[0039] Step 2.1: Log in to the mysql of the master server, query the status of the master, and record it;

[0040] Step 2.2 Configure the slave server as the master_host...

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 MySQL database replication method based on the ISER protocol. A host computer and a standby computer are subjected to disaster recovery protection through a master-slave replication technology, at the same time, the ISER protocol is used, a magnetic disk of the standby computer is mapped to the host computer for use, and the host computer stores its binlog on the mapped magnetic disk of the standby computer; if the host computer fails, a system conducts displacement comparison on host computer transmission binlog on the standby computer and binlog located on the mapped magnetic disk, and if there is a deviation, a part of extra binlogs located on the mapped magnetic disk are re-executed. According the method, it can be ensured that after the host computer fails, data of the standby computer is consistent with that of the host computer, and a set of high-availability MySQL solutions is provided for the financial field and other fields which have high requirements for data consistency.

Description

technical field [0001] The invention belongs to database technology, and in particular relates to an improved method of MySQL database master-slave replication technology. Background technique [0002] At present, MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, especially the open source feature, many small and medium-sized websites choose MySQL as the website database in order to reduce the total cost of ownership of the website. Even in the telecommunications industry, MySQL is increasingly used in telecommunications products due to its superior performance, stability, and complete functions. [0003] The existing mainstream MYSQL master-slave replication scheme is realized by copying the data operation records of the Mysql master node to the standby nodes (slaves), and re-executing the data operation records. During the replication process, the master node writes the data operation ...

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/14H04L29/06H04L29/08
CPCG06F11/1464G06F16/275H04L67/1095H04L69/26
Inventor 管文琦王成瑞樊建王玲
Owner JIANGSU SECURITIES
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