Feature Introduction

This version is MogDB 2.0.0, released on 2021.05.25. Compared with 1.1.0, this version has the following new features:

• AI

  Supports parameter self-tuning, slow SQL discovery, single query index recommendation, virtual index, workload index recommendation, database metric collection, forecasting, and exception monitoring; compatible with the MADlib ecosystem and supports high-performance AI algorithms in the library.

• Simplified Installation

  The Simplified Installation does not contain cluster management tools, provides binary files of the database kernel, can quickly start the database instance, simple installation and configuration, suitable for individual developers.

• Delayed standby databases

  Delays the time for a standby node to replay XLOG records, compared with the primary node.

• Logical replication of standby nodes

  Supports logical decoding on a standby node,this can reduce host pressure

• Enhanced capacity expansion tool

  Optimizes the scale-out tool to support online scale-out without interrupting services and allows the standby node to be scaled out as a cascaded standby node.

• Gray upgrade

  Optimizes the upgrade tool and support business online upgrade. Currently, only the gray upgrade from version 1.1.0 to 2.0.0 is supported.

• Backup machine IO write amplification optimization

  Optimize the IO of the standby machine, smooth the IO volume of the standby machine checkpoint brushing, and solve the problem that the large amount of standby machine IO affects the query performance.

• WDR diagnostic report adds database operation indicators

  Adds four database running metrics: Effective CPU, WalWrite NoWait, Soft Parse, and Non-Parse CPU.

• Features of the Data Studio client tool

  Data Studio supports multiple features of the MogDB kernel. The details are as follows:

  • The pldebugger debugging function is added.
  • The rollback of the pldebugger debugging function is added. Before using Data Studio for debugging, add an option to ensure that the debugging function is rolled back after data is modified.
  • The XML and serial types are supported. Columns are added to the table. The column type can be XML or serial(big|normal|small).
  • Foreign table objects can be created and displayed in Data Studio.
  • The partial_cluster_key constraint of column-store tables is supported.
  • Global temporary tables support DDL display and export.
  • The LOCAL and GLOBAL flags are supported when a partitioned table is created.
  • The MOT table is displayed.