A method and device for extending a distributed database

Abstract

The embodiment of the present invention discloses a method and device for extending a distributed database. The method includes: when determining that there are data hosts in the data access service, setting a new data distribution strategy for all data hosts according to the expansion target; determining the After the data corresponding to the new data distribution strategy starts migrating, set the status of the new distribution strategy as migrating; The policy replaces the old data distribution policy.

Description

technical field [0001] The invention relates to database establishment technology, in particular to a distributed database expansion method and device. Background technique [0002] The relational database is responsible for the instantiation of all objects in the system, realizes efficient access to data, and implements a unified Structured Query Language (SQL, Structured Query Language) access interface for data. In a distributed architecture, the processing capability of the distributed database directly determines the overall processing capability of the system to a large extent. [0003] The current distributed technology mainly constructs SQL data access to applications through distributed data access services (DDS, Data Distribution Service) and multiple relational database instances. The application program uses JDBC or related access interfaces to connect to DDS, and DDS internally performs SQL analysis, performs routing judgment according to distribution rules, an...

AI Technical Summary

Problems solved by technology

[0009] The method of suspending business acceptance has the following problems: 1) The expansion may only be part of the table and some database hosts, but it is necessary to suspend all businesses involving table operations, and it is likely to suspend all businesses; 2) The time of business interruption It is related to the amount of data that needs to be migrated. When the number of records in the table is large, the pause time is longer

[0010] Using the method of modifying the distribution strategy to be compatible with the old distribution strategy mainly has the following problems: 1) For irregular primary keys, such as mobile phone numbers, it is difficult to establish a compatible distribution strategy; 2) After multiple expansions, the distribution strategy will become It is very complicated, difficult to maintain and adjust, and further increases the difficulty of compatibility; 3) It is difficult for the new strategy to ensure an even distribution of subsequent business processing loads

Images