Skip to main content

NineData Community Edition Release Note

Version: 4.2.0 (Officially released on June 10, 2025)

Module
Feature
Release Notes
Service DeploymentImage OptimizationFeature Optimization
Optimized image size, reducing it by approximately 1GB, significantly improving deployment efficiency.
Product FeaturesDatabase DevOpsNew Features
  • SQL Console (Milvus):
    • Full SQL Operations: Supports DML syntax (SELECT/INSERT/REPLACE/DELETE, etc.) and DDL syntax (CREATE TABLE/INDEX) for managing Milvus database.
    • Vector Processing Capabilities: Supports creating vector indexes, vector data retrieval, and generating vector data via Embedding.
  • SQL Console (Kingbase):
    • Data Source Separation: Explicitly split KingBase into independent data source types KingBase for Oracle and KingBase for PostgreSQL.
    • Enhanced Navigation Tree: Added right-click functionality in the left sidebar for quick table creation, script generation, etc.
Feature Optimization
  • Sensitive Data Scanning: Supports instance-level full database scan configuration.
  • Syntax Parsing: Improved MySQL stored procedure and Oracle Package syntax compatibility.
Product FeaturesIn-App NotificationsNew Features
  • Expanded Webhook Subscription Channels: Added support for integration with popular collaboration platforms like Slack to enhance message delivery capabilities.
Product FeaturesData ReplicationNew Features
  • Added PostgreSQL to MySQL replication chain: Supports full table structure replication, full data migration, and incremental synchronization.
  • Added MySQL to PostgreSQL replication chain: Supports full table structure replication, full data migration, and incremental synchronization.
  • Added MySQL to Kafka replication chain: Supports full historical data import and incremental binlog real-time subscription, and automatically handles MySQL data type to Kafka message format conversion.
Feature Optimization
  • StarRocks Compatibility: Optimized compatibility for special character table names.
  • Doris/StarRocks: Solved issues with the ALTER COLUMN DEFAULT syntax in incremental replication from MySQL or PostgreSQL where native support is not available in the source instance.
  • High Availability Enhancement: In MySQL one-master-two-standby architecture, replication tasks automatically switch to the new master node during master-standby failover.
  • Redis Integration: Added SSH tunnel connection method to enhance access to internal instances.
  • GTID Compatibility: Optimized incremental replication in MySQL 5.5 without GTID support.
  • DDL Optimization: Improved DDL synchronization performance in TDSQL MySQL.
  • Field Protection: Actively blocks DML synchronization when a target table is missing fields.
  • Cloud Compatibility: Fixed incremental replication slot issues in Alibaba Cloud RDS PostgreSQL.
  • Loop Prevention: Added loop protection mechanism in multi-task cascading scenarios.
Product FeaturesDatabase ComparisonNew Features
  • Added PostgreSQL to MySQL comparison chain.
  • Added MySQL to PostgreSQL comparison chain.
  • Cross-engine consistency checks, supporting three comparison modes:
    • Full Comparison: Complete data scan.
    • Fast Comparison: Hash-based sample validation.
    • Periodic Comparison: Timed automatic difference detection.

Version: 4.1.0 (Officially released on May 09, 2025)

Module
Feature
Release Notes
Service DeploymentContainerized Deployment UpgradeNew Features
  • Complete Upgrade Path: Support for smooth upgrade from 4.0.0 to 4.1.0 versions.
  • Password Reset for Administrator: Added support for resetting the password in case the administrator password is forgotten.
  • Enhanced Operations and Maintenance Capabilities: Provide standardized upgrade|backup|rollback operations.
  • Startup Pre-Check Mechanism: Prohibit startup if disk space is less than 20GB, and trigger an alert if less than 50GB.
  • System Resource Forced Verification: Added baseline detection for CPU and memory capacity.
Feature Optimization
  • Legacy CPU Architecture Compatibility: Compatible with x86-64-v1 instruction set.
  • Container Restart Self-Check: Automatically run health check scripts until all services are ready.
  • Log Cleanup Policy: Adjust the task run log retention period to 7 days for automatic cleanup.
  • Network Configuration Upgrade: Adjust the default network plugin mode to resolve service access exceptions in some low-version kernel environments.
  • Metadata Database Decoupling: Support external MySQL 8.0+ as the metadata database through Docker environment variables.
Product FeatureDatabase DevOpsNew Features
  • SQL Console (PegaDB): The SQL Console has added support for Baidu Cloud PegaDB data sources, and you can now manage your PegaDB data sources through the SQL Console.
  • SQL Console (MongoDB): NineData SQL Console has added support for HIDEINDEX and UNHIDEINDEX commands for MongoDB.
  • SQL Console (GoldenDB): The SQL Console has added support for GoldenDB data sources, and you can now manage your GoldenDB data sources through the SQL Console.
  • SQL Task|Schema Design Pre-release (GoldenDB): The SQL task|schema design and release feature has added support for GoldenDB data sources.
  • Data Export (GoldenDB): The data export feature now supports GoldenDB data sources, allowing export through SQL query statements and library table selection.
  • Data Import (GoldenDB): The data import feature now supports GoldenDB data sources, allowing import of SQL, CSV, EXCEL files containing data into the target database.
  • Data Export (KingBase): The data export feature now supports KingBase data sources, allowing export through SQL query statements and library table selection.
  • Data Import (KingBase): The data import feature now supports KingBase data sources, allowing import of SQL, CSV, EXCEL files containing data into the target database.
Feature Optimization
  • SQL Console (Optimization): In the View Sessions, add a search box to support fuzzy filtering of sessions by database name, user name, SQL statement, host name, etc.
  • SQL Console (Optimization): The left navigation tree of the SQL Console now displays the database table space size of PostgreSQL and Db2 data sources.
  • Slow Query Analysis (Optimization): In the data source details page of the Slow Query Analysis module, add filtering of slow queries by Host, User, Database.
  • Sensitive Data Protection (Optimization): Add data content recognition rules for sensitive data types, supporting regular expressions and hit rate percentage adjustment.
  • Sensitive Data Protection (Optimization): For sensitive data scanning tasks in the Pending status, add the Terminate Scan operation, which can be performed under the Task Scan Log tab.
Product FeatureData ReplicationNew Features
  • New data replication link from PostgreSQL to Doris.
  • New data replication link from MySQL to StarRocks.
  • New data replication link from Redis to Redis.
  • New data replication link from MongoDB to MongoDB.
Product FeatureDatabase ComparisonNew Features
  • New data comparison link from PostgreSQL to Doris.
  • New data comparison link from MySQL to StarRocks.
  • New data comparison link from Redis to Redis.
  • New data comparison link from MongoDB to MongoDB.
Product FeatureInteraction UpgradeFeature Optimization
  • Refinement of Data Source Classification: Split Kingbase into two independent types, KingbaseES for Oracle and KingbaseES for PostgreSQL.
  • Table Structure Visualization: Remove the forced verification of the enforced field in table structure editing for MySQL versions above 8.0.
Product FeatureBasic ServicesNew Features
  • Open OpenAPI authentication system for account AccessKey, SecretKey management; the permissions of AccessKey are consistent with the platform account permissions.
  • Expose the data source management interface.
Bug Fixes
  • Permanent License Support: Refactor the license authentication logic to support unlimited authorization mode.
  • Message Formatting: Fix the issue where WeChat Webhook messages do not wrap lines.

Version: 4.0.0 (Officially released of Community Edition on March 25, 2025)