NineData Community Edition Release Note

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

Module	Feature	Release Notes
Service Deployment	Image Optimization	Feature Optimization Optimized image size, reducing it by approximately 1GB, significantly improving deployment efficiency.
Product Features	Database DevOps	New 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 Features	In-App Notifications	New Features Expanded Webhook Subscription Channels: Added support for integration with popular collaboration platforms like Slack to enhance message delivery capabilities.
Product Features	Data Replication	New 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 Features	Database Comparison	New 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 Deployment	Containerized Deployment Upgrade	New 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 Feature	Database DevOps	New 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 Feature	Data Replication	New 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 Feature	Database Comparison	New 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 Feature	Interaction Upgrade	Feature 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 Feature	Basic Services	New 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)