TiDB database maintenance method and device, computer equipment and storage medium

A maintenance device and database technology, applied in the field of data processing, can solve problems such as low database maintenance efficiency, weak archive tape IO transmission capacity, long data backup and restoration time, etc., and achieve the effect of improving efficiency

Pending Publication Date: 2020-07-31
PING AN TECH (SHENZHEN) CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] When the database performs transaction processing, data backup is required so that in the event of a failure, data recovery and restoration can be performed based on the backup files. The existing TiDB database uses archive tapes for data backup, and the IO transmission capacity of archive tapes is weak, while the TiDB database Often the amount of data is large, which makes data backup and restoration time longer, resulting in lower efficiency of database maintenance

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
  • TiDB database maintenance method and device, computer equipment and storage medium
  • TiDB database maintenance method and device, computer equipment and storage medium
  • TiDB database maintenance method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the technical field of the application; the terms used herein in the description of the application are only to describe specific embodiments The purpose is not to limit the present application; the terms "comprising" and "having" and any variations thereof in the specification and claims of the present application and the description of the above drawings are intended to cover non-exclusive inclusion. The terms "first", "second" and the like in the description and claims of the present application or the above drawings are used to distinguish different objects, rather than to describe a specific order.

[0057] Reference herein to an "embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the present application. The occurrenc...

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 TiDB database maintenance method and device, computer equipment and a storage medium. The method comprises the following steps of: acquiring data in a TiDB production librarythrough a TiDB-Binlog cluster component; obtaining a binlog file corresponding to the data in the TiDB production library; synchronizing the binlog file to a TiDB city-wide disaster recovery database; then, a preset timed backup script is adopted; synchronizing the binlog file in the TiDB city-wide disaster recovery database to a flash memory NAS device; when monitoring that the TiDB production library is abnormal, carrying out data recovery processing on the TiDB production library based on the binlog file stored in the flash memory NAS equipment, so that the problem of low backup and recovery speed due to the fact that data in the production library is directly stored in an archiving magnetic tape in a traditional mode is solved, and the maintenance efficiency of the TiDB database is improved.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a TiDB database maintenance method, device, computer equipment and storage medium. Background technique [0002] With the rapid development of the economy, more and more enterprises have expanded their business scope and expanded their user groups. Many enterprises have begun to use distributed databases for data storage in order to improve business processing capabilities. TiDB is a An open source distributed relational database with high security, compatible with MySQL protocol and ecology, easy to migrate, and extremely low operation and maintenance costs, has become a relatively popular distributed database. [0003] When the database performs transaction processing, data backup is required so that in the event of a failure, data recovery and restoration can be performed based on the backup files. The existing TiDB database uses archive tapes for data backup, and the IO...

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): G06F11/14G06F16/23G06F16/27
CPCG06F11/1448G06F11/1469G06F16/23G06F16/27
Inventor 汤盛华
Owner PING AN TECH (SHENZHEN) 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