Multi-copy storage method and multi-copy storage system for distributed database system

Abstract

The invention discloses a multi-copy storage method and a multi-copy storage system for a distributed database system, and belongs to the field of computer software. The multi-copy storage system comprises a main Master node, a standby Master node, a plurality of storage nodes and a connection network. The multi-copy storage method includes steps of 1, storing data in different data pieces; 2, only allowing a user to operate the data in a primary version, and enabling the multi-copy storage system to synchronize change of the data to various copies in real time and guarantee the atomicity; 3, enabling the multi-copy storage system to detect survival conditions of the nodes via synchronous heartbeat detection, and enabling a main Master host to instantly select an available copy to replace the primary version when a certain storage node of the data in the primary version dies; 4, enabling the multi-copy storage system to carry out detection and repair operation for the storage copies regularly, and migrating the data pieces with excessively low quantities of copies to other available storage nodes by means of local storage migration. A main storage model and a standby storage model are adopted for each data piece, and the copies are of completely identical logical structures and are distributed on different physical storage nodes. The multi-copy storage method and the multi-copy storage system have the advantages that the integrity and the availability of the data are protected against the death of optional nodes of the system.

Description

technical field [0001] The invention relates to a multi-copy storage method and system for a distributed database system, belonging to the technical field of computers. Background technique [0002] When storing data in a database, you will encounter various problems: such as disk damage; disasters leading to system crashes, power outages, etc., which make data inevitably encounter problems such as missing errors and unavailability. [0003] Although the current mainstream databases provide methods such as regular backup and selecting appropriate version recovery according to needs, when the above problems occur, the service must be shut down for maintenance, which will affect data users, and some of the impact will be fatal. Based on this, we invented a multi-copy storage method and system for a distributed database system to solve the problem of server downtime and disk damage leading to unavailable data on the server. [0004] Myfox's distributed MySQL cluster middleware...

AI Technical Summary

Problems solved by technology

[0002] When storing data in a database, you will encounter various problems: such as disk damage; system crashes caused by disasters, power outages, etc., which make data inevitably encounter problems such as missing errors and unavailability

[0003] Although the current mainstream databases provide methods such as regular backup and selecting an appropriate version recovery according to needs, when the above problems occur, the service must be shut down for maintenance, which will affect data users, and some of the impacts will be fatal.

Based on this, we invented a multi-copy storage method and system for a distributed database system to solve the problem of server downtime and disk damage leading to unavailable data on the server

Images