MPP parallel database instance-level copy balancing method

• Main Authors: ZHOU YONGLIANG, LIU YAO, SANG GUOBIAO, JIANG XU, JIA ZONGXIU, ZHANG XINYAO, WU SONG, LE CHENGYU, ZHU YANAN, LIU YONGSHENG, ZHAO DONGWEI, LI XIAOPENG, JI TAOTAO
• Format: Patent
• Language: Chinese; English
• Published: 08.11.2022
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention relates to an MPP parallel database instance-level copy balancing method, which is technically characterized in that a balancing strategy for storing IO configures an independent storage hard disk for each WAL log, and configures a shared large-capacity storage hard disk for business data; the balancing strategy of the physical memory adopts a dynamic data page buffer area distribution mode; the balancing strategy of the computing resources adopts a self-adaptive working mode; the original main instance back-switching strategy comprises a smooth mode rebalance and a speed mode rebalance so as to meet different scene requirements. According to the method, the characteristics of parallel computing, batch data loading and one-time writing and multiple queries in the MPP parallel database are fully considered, and instance-level copy balancing is carried out from the four aspects of storage IO, physical memory, computing resources and original main instance back-cutting; finally, the computing servi