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
CN111475334APending Publication Date: 2020-07-31PING AN TECH (SHENZHEN) CO LTD
0 Cites 3 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
PING AN TECH (SHENZHEN) CO LTD
Publication Date
2020-07-31

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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