Extension method and device for distributed database

Abstract

The embodiment of the invention discloses an extension method and device for a distributed database. The method comprises the steps that when it is determined that a data host has access to a data access service, a new data distribution strategy is set for all data hosts according to an extension target; after it is determined that data corresponding to the new data distribution strategy starts migration, the state of the new distribution strategy is set to be in migration; and after migration of the data corresponding to the new data distribution strategy is completed in a table routing mode,the new data distribution strategy is used to replace an old data distribution strategy.

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