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

Binlog file download method, device, equipment and readable storage medium

A file download and file technology, applied in the database field, can solve problems such as download interruption, abnormal state of download thread, etc.

Active Publication Date: 2021-04-20
HANGZHOU DT DREAM TECH
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] If during the process of downloading the Binlog file, the download is interrupted due to some reason, and when you try to resume the download and re-establish the network stream, the download thread will enter because the read position may exceed the file start position range allowed by the request. Abnormal state

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
  • Binlog file download method, device, equipment and readable storage medium
  • Binlog file download method, device, equipment and readable storage medium
  • Binlog file download method, device, equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] 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, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0059] It should be noted that the existing MySQL master-slave replication technology obtains the Binlogs on the master server through the IO thread started on the slave server. The master server is the server, and the slave server is the client; the COM_BINLOG_DUMP request packet can specify the Binlog file where the network stream transfer data starts and the starting position in the file. The IO thread assembles and sends a COM_BINLOG_DUMP request according to u...

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 Binlog file download method, device, equipment and computer-readable storage medium, comprising: determining the last download location of the Binlog file downloaded by the client; judging whether the last download location is less than the maximum request location; if not, starting from the Find an effective start position smaller than the maximum request position in the start position of each Binlog event downloaded; use the effective start position to send a download request to the server to continue downloading the Binlog event in the Binlog file; it can be seen that in this scheme, After the download is interrupted, check whether the last download position exceeds the maximum request position. If it exceeds the maximum request position, then from the start position of the downloaded Binlog event, find a valid start position that is less than the maximum request position, so that it can be based on the effective The starting position continues to send download requests to avoid download exceptions.

Description

technical field [0001] The present invention relates to the technical field of databases, and more specifically, relates to a MySQL Binlog file download method, device, equipment and computer-readable storage medium. Background technique [0002] MySQL is a relational database management system, and MySQL binary log is a binary log, referred to as Binlogs, which contains events describing changes in the database, such as table creation operations and data changes. Binlogs are stored in Binlog files, which begin with a Binlog file header followed by a series of Binlog events. At present, the MySQL master-slave replication server communicates according to the client / server protocol. The MySQL master and slave replication servers send Binlogs through the network and in the form of Binlog network streams, and transfer the changes that occur on the master server to the slave servers. The establishment process of the Binlog network flow is as follows: the client needs to send a C...

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): H04L29/08
CPCH04L67/06H04L67/34
Inventor 王俊皓褚占峰江峰
Owner HANGZHOU DT DREAM TECH