2024
April
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 04-24 | Basic Service | Dashboard | The NineData dashboard displays an overview of all tasks under the current account, as well as a summary of tickets (pending approval, pending execution, submitted by me). Modules involved include SQL tasks, data import/export, data archiving, data tracking, data replication, data backup and recovery, database comparison, data sources, etc. | Dashboard Introduction |
| 04-24 | Basic Service | Adding Alert Rules | When creating alert rules, two conditions and are added to the alert conditions of data replication tasks, allowing you to configure alerts more flexibly. | Configure Alert Policies |
| 04-24 | Data Replication | Periodic Full Replication Throttling | During periodic full replication, support for throttling the rate of full replication is added to reduce the performance impact on the business database caused by excessive read traffic during full-speed replication. | Periodic Full Replication |
| 04-24 | Database DevOps | Task List | The database DevOps adds a task list feature, which summarizes all database DevOps tasks related to oneself in the current organization. You can quickly filter by task type, task relationships, task status, and also support searching and locating target tasks by data source name, database name, creation time, submitter, task name, or ID. | N/A |
| 04-24 | Database DevOps | Sensitive Data Management (TiDB) | The sensitive data management feature now supports configuring sensitive columns for TiDB data sources. | Manage Sensitive Data |
| 04-24 | Database DevOps | Permission Application (TiDB) | Added permission control for TiDB data sources, allowing users in your organization to apply for read/write permissions for TiDB data sources at the data source level, database level, or sensitive column level. | Permission Application and Approval |
| 04-24 | Database DevOps | SQL Review (TiDB) | NineData SQL Review now supports TiDB data sources. | SQL Review |
| 04-24 | Database DevOps | SQL Task (TiDB) | The SQL task feature now supports TiDB data sources, allowing change requests to TiDB data sources to be initiated via SQL tasks, supporting immediate or scheduled execution. | SQL Task |
| 04-24 | Database DevOps | SQL Console (TiDB) | SQL Console adds support for TiDB data sources, allowing you to manage your TiDB data sources through the SQL Console. | SQL Console |
| 04-18 | Database DevOps | New SQL Development Rule | Added “” rule for configuring the limit of Binlog file size in data tracking tasks. If the Binlog file size exceeds the configured threshold, it will be intercepted during the pre-check phase, and submission of data tracking tasks will not be allowed. | Database DevOps Rules Overview |
| 04-18 | Database DevOps | SQL Review | NineData SQL Review now supports OceanBase Oracle data sources. | SQL Audit |
| 04-18 | Database DevOps | Data Tracking | NineData data tracking feature added the rollback SQL download function. | Data Tracking |
| 04-18 | Basic Services | New Data Source Support | Added support for adding OceanBase for MySQL data sources to NineData. | Creating Data Sources |
| 04-18 | Data Replication | Refresh Metadata | During the Mapping Configuration phase of creating a replication task, if there are changes in the source and target data sources, you can click the button on the page to re-read the data from the source and target data sources. | Data Replication |
| 04-11 | Data Replication | Periodic Full Data Replication | The NineData data replication feature supports periodic full replication between two data sources, automatically transferring the source data in full to the target end based on preconfigured intervals. | Periodic Full Replication |
| 04-11 | Data Replication | Addition of Replication Links | Dozens of replication links have been added, covering mainstream data sources in the market. Please click on the link provided for the supported list. | Data Replication |
| 04-11 | Database DevOps | Data Tracking | The NineData data tracking feature is used to track developers' changes or deletions of data or object structures in the database, ensuring data integrity for the business. | Data Tracking |
| 04-11 | Database DevOps | SQL Console | When managing PostgreSQL data sources in the SQL Console, support has been added to obtain the execution plan of the target SQL statement. | SQL Console |
| 04-11 | Database DevOps | SQL Console | When managing PostgreSQL data sources in the SQL Console, you can right-click on the target object in the left navigation tree and select to automatically generate the creation script for that object. | SQL Console |
| 04-11 | Database DevOps | SQL Review | The NineData SQL review feature now supports PostgreSQL data sources. | SQL Review |
| 04-11 | Database DevOps | Slow Query Analysis | The NineData slow query analysis feature now supports PostgreSQL data sources. | Slow Query Analysis |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing TiDB data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing Sybase data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Addition of Data Source Support | Added support for bringing Hive data sources into NineData. | Create Data Source |
| 04-11 | Basic Services | Data Source Entry Optimization | When entering Redis clusters via gateway or private network connection, only one link address needs to be filled in. The system will automatically traverse all link addresses of the cluster and add them without the need for manual operation by the user. | Create Data Source |
| 04-02 | Database DevOps | Data Export | The data export feature has been integrated with table-level permission control, allowing users to export only the tables they have permission to in the data export module. | Data Export |
| 04-02 | Database DevOps | SQL Console | The SQL Console feature has been integrated with table-level permission control, allowing users to perform operations such as querying and modifying only on tables they have permission to in the SQL Console module. | SQL Console |
| 04-02 | Basic Services | New Architecture Support for Data Sources | Added support for two deployment architectures of MySQL data sources: disaster recovery and read-write splitting. | Create Data Source |
| 04-02 | Basic Services | New Architecture Support for Data Sources | Added support for two deployment architectures of MongoDB data sources: replica set and sharded cluster. Also added the preference setting for read traffic distribution under replica set architecture (Read Preference). | Create Data Source |
March
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 03-27 | Database DevOps | Product Upgrade | NineData's SQL Development initially focused on providing SQL Console (IDE) functionality. After nearly two years of refinement, the product has added numerous enterprise-level features. As of today, it has served tens of thousands of developers, covering functionalities throughout the lifecycle of database design, development, testing, and changes. In order to better convey the product's value to enterprise-level clients, NineData has officially upgraded SQL Development to Database DevOps starting from March 27th, providing customers with a leading global database DevOps solution. | N/A |
| 03-27 | Basic Services | Audit Log | Two optimizations have been added to the audit log functionality:
| Audit Log |
| 03-27 | Database DevOps | SQL Task | The automatic backup feature for SQL tasks now supports PostgreSQL data sources. | SQL Task |
| 03-27 | Database DevOps | Data Archiving | Data archiving functionality now supports PostgreSQL data sources. | Data Archiving |
| 03-27 | Database DevOps | Sensitive Data Management | Sensitive data management functionality now supports configuring sensitive columns for PostgreSQL data sources. | Manage Sensitive Data |
| 03-27 | Database DevOps | Table-Level Permission Request | NineData permission control has added table-level granularity, allowing users to apply for permissions only for individual or multiple tables in the data source without granting larger-grained permissions at the database or data source level. | Permission Request and Approval |
| 03-27 | Database DevOps | Development Pipeline | The development pipeline functionality enables multi-environment development process management, facilitating smooth progress in each environment to ensure that all necessary validation, changes, and approvals are completed before code is released to the production environment. | Development Pipeline |
| 03-13 | Database DevOps | Add sensitive data in views (VIEW) | The upgrade of the sensitive column addition function now includes support for adding sensitive columns based on views, in addition to the existing capability of adding sensitive columns based on tables. This update currently applies to MySQL and DB2 data source types. | Manage Sensitive Data |
| 03-13 | Database DevOps | Permanent Free Version of Database DevOps Professional Edition | NineData released the permanent free version of Database DevOps Professional Edition on March 13, 2024. This version allows a maximum of 10 data source instances to be added and provides unlimited access to all advanced features of Database DevOps Professional Edition. Existing free organizations will be automatically upgraded to this version; new registered users and new organizations will directly access this version. | Introduction to Database DevOps Professional Edition |
February
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 02-28 | Database DevOps | SQL Console | Added a switch in the query result set of relational databases to toggle between row and column modes, allowing users to switch from the default column mode to row mode for displaying the result set. | SQL Console (RDBMS) |
| 02-28 | Basic Services | No Specify Approver | Added a switch in the approval process. When enabled, users no longer need to specify an approver in all processes that require one (such as SQL tasks, permission requests, data archiving, data import/export, SQL audits, etc.). All personnel with approval privileges will receive approval notifications and be able to approve the work order. | Approval Process |
| 02-28 | Basic Services | Added Support for New Data Sources | Added support for Tencent Cloud TDSQL PostgreSQL instances. | Create Data Source |
| 02-28 | Basic Services | Added Support for New Data Sources | Added support for Tencent Cloud TDSQL MySQL instances. | Create Data Source |
| 02-22 | Basic Services | Automatically Create Organization for New Registered Users | For new registered NineData users, the system will automatically create an organization with the same name as the user's username, and upon logging into the console, the user will be automatically switched to that organization. | Manage Organization |
| 02-22 | Data Comparison | Data Comparison between MySQL and PostgreSQL | Added support for data comparison between MySQL and PostgreSQL data sources. | Data Comparison |
| 02-22 | Data Replication | Structure Replication from MySQL to Greenplum | Added structure replication on top of existing replication from MySQL to Greenplum, eliminating the need to manually create table structures on Greenplum. | MySQL Replication to Greenplum |
| 02-22 | Data Replication | MySQL to PostgreSQL Replication | Added support for data replication from MySQL to PostgreSQL, supporting structure, full, and incremental data replication. | MySQL Replication to PostgreSQL |
| 02-05 | Data Replication | Oracle to PostgreSQL | Data replication from Oracle to PostgreSQL is now supported. It includes support for structural, full, and incremental data replication. | Oracle to PostgreSQL Replication |
| 02-05 | Database DevOps | Administrator Mode for Task Tickets | SQL tasks, import, export, data archiving, SQL audit, and other task tickets support administrator mode. System administrators can directly approve, execute, pause, restart, and perform other operations on these task tickets. | N/A |
| 02-05 | Database DevOps | Full-Featured Database DevOps | Full range of SQL development features now support Baidu Cloud GaiaDB as a data source. This includes SQL Console, SQL tasks, data import, data export, SQL auditing, batch database changes, slow query analysis, DSQL, data archiving, etc. | Database DevOps |
| 02-05 | Basic Services | Added Data Source Support | Added support for Baidu Cloud GaiaDB as a data source. | Create Data Source |
| 02-05 | Basic Services | Configure Session Timeout | System administrators can now configure the expiration time for user sessions after logging into the console. After expiration, users need to log in to the console again. | Manage Organization |
January
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 01-31 | Basic Service | Permission Application (Redis SQL Task Permissions) | Support applying for Redis SQL task permissions. | Permission Application and Approval |
| 01-31 | Database DevOps | SQL Console Optimization | The SQL Console style has been optimized as follows:
| SQL Console (RDBMS) |
| 01-31 | Data Replication | Structural Conversion | NineData's structural conversion functionality now supports downloading converted SQL scripts, which can be batch executed in the target database. | Structural Conversion |
| 01-31 | Data Replication | MySQL to StarRocks | NineData data replication supports synchronization of structure, full data, and incremental data from MySQL to StarRocks data sources. | Replication to StarRocks |
| 01-31 | Data Replication | Kafka to Kafka | Kafka to Kafka data replication functionality is now supported. | Kafka to Kafka Replication |
| 01-24 | Data Replication | Structural Transformation | NineData now supports structural transformation between heterogeneous data sources, allowing you to perform table structure conversion operations in the target data source after the transformation is completed. | Structural Transformation |
| 01-24 | Basic Services | Addition of Data Source Support | Addition of DocumentDB compatibility support. You can now select the MongoDB type when creating a data source and enter the connection address information through the DocumentDB data source. | Create Data Source |
| 01-24 | Database DevOps | Data Archiving | NineData supports data archiving functionality. You can archive unused data to another database for backup to free up storage space in the business database and optimize performance. Supports one-time execution and periodic automatic execution. | Data Archiving |
| 01-24 | Database DevOps | SQL Review | Major update to SQL review functionality! Supports auditing SQL statements based on slow query logs and full query logs in the database. In addition, a new incremental audit function has been added, which combines the latest historical SQL review results that have been approved to compare the SQL statements submitted currently, helping you quickly obtain differential results between the two audits. | SQL Review |
| 01-24 | Database DevOps | Data Export (ClickHouse) | Data export functionality now supports ClickHouse data sources and can be exported using SQL query statements. | Data Export |
| 01-16 | Database DevOps | OnlineDDL Optimization | Added the "Mandatory use of NineData OnlineDDL" option, supporting direct and lock-free structural changes to tables through NineData OnlineDDL. | Use NineData OnlineDDL for Lock-Free Structural Changes to Tables |
| 01-16 | Database DevOps | Database DevOps Standards Update | Added the "" rule to control the execution of NoSQL commands in SQL tasks. | Overview of SQL Development Rules |
| 01-16 | Basic Services | Encryption for Redis Data Source | When adding a Redis data source to NineData, now supports enabling encryption for transmission, further ensuring the security of the accessed data source. | Create Data Source |
| 01-10 | Data Comparison | Data Comparison between Oracle and SingleStore | Data comparison functionality between Oracle and SingleStore has been supported. | Data Comparison |
| 01-10 | Data Replication | Oracle to MySQL | Data replication from Oracle to MySQL is now supported, covering structural, full, and incremental data replication. | Oracle to MySQL Replication |
| 01-10 | Data Replication | Oracle to SingleStore | Data replication from Oracle to SingleStore is now supported. It allows analyzing data through SingleStore, while Oracle focuses on the workload of transactional operations, distributing server pressure, and maximizing the value of business data. | Oracle to SingleStore Replication |
| 01-10 | Database DevOps | Addition of SQL Development Rules | Addition of the "" rule for setting the concurrency of SQL tasks. | Overview of SQL Development Rules |
| 01-10 | Database DevOps | OnlineDML | NineData's SQL tasks support the OnlineDML feature, which automatically splits large-scale data changes into multiple statements for batch execution. This helps avoid table blocking caused by extensive data modifications, preventing disruptions to business operations. | Executing Large-scale Data Changes in Batches using NineData OnlineDML |
| 01-10 | Basic Services | Monitoring Alerts Support Email Service | Support for manually configuring email services. After configuration, the system will use the email server you configured to send alerts and subscription information to recipients. | Configure Alert Reception |
| 01-03 | Data Replication | MongoDB Replication Optimization | After MongoDB replication failure, supports users to repair SQL statement execution from the console, and optimizes the performance of MongoDB pre-checking the existence of target data. | MongoDB Replication to MongoDB |
| 01-03 | Data Replication | Redis Replication Optimization | During the full replication phase of Redis, supports automatic retries in case of network issues, optimizes the logic of saving disconnecting resumption points, and supports users to repair and skip incremental commands in case of Redis cluster replication failure. | Redis Replication to Redis |
| 01-03 | Data Replication | MySQL Replication Optimization | Optimizes the performance of reading large transactions in MySQL incremental replication, reduces CPU consumption, and decreases latency. | MySQL Replication to MySQL |
| 01-03 | Database DevOps | Batch Database Changes | Supports initiating batch structural and data changes to the target database through SQL tasks, supports automatic SQL review based on SQL development specifications, and also supports multi-level approval in the approval process configuration. | Batch Database Changes |
) above the left navigation tree).