NineData Community Edition Release Note

Official Github

Version: 4.5.0 (Official Release on 2025.09.12)

Module	Feature	Release Details
Product Features	Database DevOps	New Features New Data Source Types: Added support for AWS RDS SQLServer, AWS RDS PostgreSQL, AWS RDS Oracle, AWS RDS MariaDB, AWS Aurora PostgreSQL, PolarDB (Oracle-compatible), and PolarDB PostgreSQL. These can now be used across SQL Console, tasks, sensitive data management, and other features. Sensitive Data Protection (PostgreSQL Enhancement): Added support for automatic recognition, classification, and grading of sensitive data in PostgreSQL. Scheduled tasks can be configured for periodic execution. Stored Procedure Debugging (PostgreSQL): The SQL Console’s debugging feature now supports PostgreSQL stored procedures and functions, including setting breakpoints, step-by-step execution, and viewing/modifying variables. Data Import/Export (MongoDB): Added support for MongoDB data sources with JSON file import and export capabilities. Enhancements OnlineDDL: Enhanced the instant algorithm to support lock wait timeout control, with real-time display of replay logs, delay, binlog positions, and latency during execution. Data Archiving & Cleanup: For MySQL and PostgreSQL, when selected time fields are CHAR, VARCHAR, INT, or BIGINT, they can now be initialized as timestamps with precision options for seconds, milliseconds, and microseconds.
Product Features	Data Replication & Comparison	New Features MySQL → Greenplum: Supports schema replication, full replication, incremental replication, and consistency comparison (full/fast/scheduled/inconsistency check). Enhancements Support for enabling or disabling DDL replication at the global level. PostgreSQL Homogeneous Replication: Performance Improvement: Introduced batch replication logic for DML statements related to tables, improving replication performance. Compatibility Improvement: Replication now supports timestamp field values of +infinity or -infinity. MySQL Homogeneous Replication: Binlog Read Throttling: During incremental replication, users can configure rate limiting under the incremental replication tab to control NineData’s binlog read speed, reducing source database load. Binlog Table Object Filtering: When the replication target is not the entire database, NineData automatically filters out unrelated tables, significantly improving log parsing speed. latin1 Encoding Fix for enum/set: Added support for correctly handling enum/set values stored in latin1 encoding. MongoDB Homogeneous Replication: Added support for replicating the drop index statement.
Product Features	Basic Services	Enhancements Task Management Permissions: The module now supports fine-grained, data source–level permission control. Only authorized users can manage tasks associated with specific data sources. Operations Center Module Permissions: Permissions for accessing the Operations Center can now be granted under > . Only authorized users can access the Operations Center to manage NineData tasks.
Service Deployment	Image Optimization	New Feature Container Compatibility: NineData images now include detection of the host system’s cgroup v2 support, improving runtime environment compatibility.

Version: 4.4.0 (Official Release on 2025.08.13)

Module	Feature	Release Details
Product Features	Database DevOps	New Features Database Version Management: Added database version management. For MySQL databases with version management enabled, the system automatically collects DDL changes for the database and saves them as a version. Change scripts and rollback scripts can be generated between different versions. Stored Procedure Debugging (Oracle): Added support in the SQL Console for compiling and debugging stored procedures, functions, and package objects in Oracle databases. For objects with compilation errors, detailed error information is provided. Supports setting breakpoints, step-by-step execution, and procedure-by-procedure debugging. Data Export (MongoDB): Added support for exporting MongoDB data. JSON files can be exported via SQL statements. MySQL Lock Wait Management: Added SQL execution lock wait configuration rules, allowing you to set lock wait timeouts and retry counts to avoid lock contention caused by task changes, ensuring database change safety. OpenAPI Extensions: Added 11 new OpenAPI endpoints, covering account management, user management, role management, operation auditing, and data source permissions. Enhancements OnlineDDL Non-locking Changes: Added lock wait timeout and retry management for the instant algorithm in OnlineDDL non-locking table structure changes. During changes, you can now view replayed incremental log counts, replay delays, binlog positions, and response delays.
Product Features	Data Replication & Comparison	New Features PostgreSQL > StarRocks: Supports schema replication, full replication, and incremental replication; supports full/fast/periodic/inconsistency recheck comparisons. OpenGauss Oracle Homogeneous Replication: Supports schema replication, full replication, and incremental replication; supports full/fast/periodic/inconsistency recheck comparisons. OpenGauss PostgreSQL Homogeneous Replication: Supports schema replication, full replication, and incremental replication; supports full/fast/periodic/inconsistency recheck comparisons. OpenGauss MySQL Homogeneous Replication: Supports schema replication, full replication, and incremental replication; supports full/fast/periodic/inconsistency recheck comparisons. Enhancements Optimized MySQL high-performance synchronization by improving foreign key dependency parsing, preventing write failures caused by different foreign key write orders. PostgreSQL incremental replication now supports syncing CREATE TABLE LIKE DDL, and allows specifying which DDL types to replicate. MySQL data replication now supports the latin1 character set. PostgreSQL incremental replication improved support for copying data from the postgis plugin. Enhanced object name handling in schema replication tasks, including converting names to uppercase or lowercase.
Product Features	Basic Services	New Features Task Management: Added an Operations Center providing task management capabilities, allowing you to view task lists, scheduling logs, and other detailed information. Enhancements Fixed metadata database initialization timeout issues.

Version: 4.3.0 (Officially released on July 10, 2025)

Module	Feature	Release Details
Product Features	Database DevOps	New Features MariaDB Support: Full support for SQL Console, Data Import/Export, SQL Tasks, Sensitive Data Management, and SQL Review features with MariaDB. GaussDB Support: Full support for SQL Console, Data Import/Export, SQL Tasks, Sensitive Data Management, and SQL Review features with GaussDB. Mobile Approvals: Support for executing SQL tasks (Execute/Pause/Restart/Terminate) on mobile app. Feature Enhancements Data Tracking & Rollback: Optimized MySQL pre-check logic to support role-based authorization scenarios; enhanced support for read/write splitting and disaster recovery architecture. Online DDL Changes: Enabled DDL execution on MySQL read/write split and disaster recovery instances. Sensitive Data Protection: Optimized rule logic to cover sensitive columns in WHERE clause joins; control switch via security policy. Simplified Operations: Unified entry for sensitive data scanning and report downloads. SQL Parsing Optimization: Improved distinction between SQL syntax errors and parsing failures; refined permission guidance prompts.
Product Features	Data Replication & Comparison	New Features PostgreSQL > Kafka Replication: Supports full migration and incremental real-time sync. MySQL > ClickHouse Replication: Supports table structure replication, full migration, and incremental sync. MySQL > Elasticsearch Replication: Supports table structure replication, full migration, and incremental sync. MySQL↔ClickHouse Comparison: Supports full/fast/periodic data comparison. Feature Enhancements MySQL > Doris Replication: Supports DDL sync for ALTER/RENAME/DROP/TRUNCATE TABLE operations. PostgreSQL > Doris Replication: Supports DDL sync for ALTER/RENAME/DROP/TRUNCATE TABLE operations.

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 (INSERT/REPLACE/DELETE, etc.), DQL syntax (SELECT), 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)