2023
December
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 12-27 | Data Comparison | Data Comparison between PostgreSQL and Doris | Supports structure and data comparison between PostgreSQL and Doris data sources. | Data Comparison Structure Comparison |
| 12-27 | Data Replication | PostgreSQL to Doris | Supports data replication from PostgreSQL to Doris, enabling efficient management and analysis of large-scale data. | PostgreSQL to Doris Replication |
| 12-27 | Data Replication | Kafka to MySQL | Supports data replication from Kafka to MySQL, enabling real-time data synchronization and persistent storage. | Kafka to MySQL Replication |
| 12-27 | Database DevOps | SQL Tasks (DWS, GaussDB, openGauss) | SQL task functionality now supports DWS, GaussDB, and openGauss data sources. You can initiate change requests to these data sources through SQL tasks, supporting immediate or scheduled execution. | SQL Tasks |
| 12-27 | Database DevOps | SQL Console (DWS, GaussDB, openGauss, SingleStore, StarRocks) | SQL Console functionality now supports DWS, GaussDB, openGauss, SingleStore, and StarRocks data sources. You can perform CRUD operations on these data sources through the SQL Console. | SQL Console |
| 12-27 | Database DevOps | Data Export (DWS, GaussDB, openGauss) | Data export functionality now supports DWS, GaussDB, and openGauss data sources. You can export data to files for storage using SQL queries. | Data Export |
| 12-27 | Database DevOps | Data Import (DaMeng) | Data import functionality now supports DaMeng data sources. You can import SQL, CSV, and EXCEL files containing data into the target database. | Data Import |
| 12-27 | Basic Services | Permission Request (DWS, GaussDB, openGauss) | Supports applying for various permissions for DWS, GaussDB, and openGauss data sources. | Permission Application and Approval |
| 12-27 | Basic Services | Added Support for New Data Sources | Added support for five new data sources: SingleStore, StarRocks, DWS, GaussDB, and openGauss. | Create Data Source |
| 12-20 | Database DevOps | New SQL Development Rules | Added the "" rule to limit the duration of data export tasks that exceed the preset threshold. | SQL Development Rules Overview |
| 12-20 | Database DevOps | SQL Task Backup for OceanBase Oracle | The backup function for SQL tasks now supports OceanBase Oracle data source. It automatically backs up data modification objects of SQL tasks, and the backup can be downloaded locally after completion. | SQL Tasks |
| 12-20 | Database DevOps | Data Export (Dameng) | Data export functionality now supports Dameng data source. You can export data through SQL queries or directly select databases and tables for export. | Data Export |
| 12-20 | Database DevOps | SQL Tasks (Klustron) | SQL task functionality now supports Klustron data source. You can initiate change requests for this data source through SQL tasks, supporting immediate or scheduled execution. | SQL Tasks |
| 12-20 | Database DevOps | SQL Console (Klustron) | SQL Console functionality now supports Klustron data source. You can perform CRUD operations on these data sources through the SQL Console. | SQL Console |
| 12-20 | Database DevOps | SQL Console Administrator Mode | Added Administrator Mode. Users with the system administrator role can enable Administrator Mode, where all changes in the SQL Console are not subject to SQL standards and can be executed directly. | SQL Console |
| 12-20 | Database DevOps | SQL Console Session View | Added session overview to MySQL's session view feature. It provides statistics on total sessions, active sessions, all accessing users, access source information, and relevant statistics for databases. | SQL Console |
| 12-20 | Basic Services | Added Data Source Support | Added Klustron data source support. | Create Data Source |
| 12-13 | Database DevOps | SQL Console (DAMENG, KingBase) | SQL Console functionality now supports DAMENG and KingBase data sources, allowing you to perform CRUD operations on these data sources through the SQL Console. | SQL Console |
| 12-13 | Database DevOps | SQL Task (DAMENG, KingBase) | SQL Task functionality now supports DAMENG and KingBase data sources. You can initiate change requests for these data sources through SQL Task, supporting both immediate and scheduled execution. | SQL Task |
| 12-13 | Basic Services | Addition of Data Source Support | Added support for KingBase data source. | Create Data Source |
| 12-13 | Basic Services | Addition of Data Source Support | Added support for DAMENG data source. | Create Data Source |
| 12-06 | Database DevOps | Non-Table Object Management | Now, in the SQL console, you can visually create, edit, copy, rename, and delete non-table objects for MySQL data sources, including views, procedures, triggers, events, and functions. | Creating Non-Table Objects in MySQL Visually |
| 12-06 | Database DevOps | SQL Tasks (MongoDB) | SQL task functionality now supports MongoDB data sources, allowing you to initiate change requests for MongoDB through SQL tasks, supporting immediate or scheduled execution. | SQL Tasks |
| 12-06 | Basic Services | Data Source Overview Page | The data source page now includes an overview page, providing a clear display of the total number of current data sources, availability, and the number of associated tasks. | - |
November
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 11-29 | Database DevOps | Slow Query Analysis | In the report detailing slow query details, examples of SQL statements for SQL templates have been added. | Slow Query Analysis |
| 11-29 | Database DevOps | Data Import (DB2) | The data import feature now supports DB2 data sources, allowing you to import SQL, CSV, and EXCEL files containing data into the target database. | Data Import |
| 11-29 | Database DevOps | Data Export (DB2) | The data export feature now supports DB2 data sources. You can export data using SQL query statements or by selecting specific tables from the database. | Data Export |
| 11-29 | Database DevOps | MySQL Autocomplete Enhancement | Significantly improved autocomplete functionality for MySQL data sources in the SQL console. Feel free to explore the enhancements. | SQL Console |
| 11-22 | Basic Services | Data Source Tags | Introducing the new Data Source Tags feature for grouping and quickly locating data sources in the Slow Query Analysis functionality. | Create Tag |
| 11-22 | Database DevOps | Slow Query Analysis (Batch Index Recommendations) | Newly added support for batch SQL index recommendations, aiding you in efficiently optimizing database performance in scenarios involving a large number of SQL queries. | Slow Query Analysis |
| 11-22 | Database DevOps | Slow Query Analysis (Oracle Support) | Slow Query Analysis functionality now supports Oracle data sources, providing users of Oracle databases with more comprehensive and accurate tools for slow query analysis, further enhancing efficiency and quality of database management. | Slow Query Analysis |
| 11-22 | Database DevOps | Slow Query Analysis (Report Download) | Introducing the new feature for downloading slow query reports, allowing you to download reports as files for easier sharing and archiving of slow query data. | Slow Query Analysis |
| 11-22 | Database DevOps | Slow Query Analysis (Data Source Favorites) | Added support for favoriting data sources in slow query collection, allowing you to conveniently bookmark commonly used or critical data sources for quick identification and monitoring of slow query issues. | Slow Query Analysis |
| 11-22 | Database DevOps | Slow Query Analysis (Top 100 List) | Newly added functionality for Top 100 Slow Query Lists, enabling you to quickly identify the queries that most impact system performance. | Slow Query Analysis |
| 11-22 | Database DevOps | Slow Query Analysis (Data Dashboard) | Introducing the Data Dashboard feature, designed to provide clearer insights into the trends of slow queries, enabling timely actions to address issues and further enhance system stability and performance. | Slow Query Analysis |
| 11-22 | Database DevOps | SQL Review | NineData SQL Review is used for security and efficiency reviews of SQL statements before application code is released. It ensures that the released SQL statements comply with standards and recommends appropriate indexes for SQL statements without indexes, improving the efficiency and accuracy of code releases. | SQL Review |
| 11-22 | Data Replication | New Link Favorites | In the data replication task list, you can now bookmark target replication links. Later, you can quickly filter out favorited replication links using the button. | Data Replication |
| 11-15 | Data Replication | Addition of Replication Links | Addition of structure, full, and incremental replication between Oracle databases. | Data Replication Between Oracle Databases |
| 11-01 | Database DevOps | Slow Query Analysis | NineData's slow query analysis feature is used to locate slow SQL queries and optimize databases, helping developers and database administrators identify abnormal queries that affect database performance and providing optimization recommendations. It mainly includes slow log collection, diagnosis, and optimization. | Slow Query Analysis |
| 11-01 | Database DevOps | Sensitive Data Management | Sensitive columns have been configured for DB2 data sources. | Configure Sensitive Columns |
| 11-01 | Database DevOps | Execution Plans | Execution plan support is now available for DB2 data sources in the SQL Console. | SQL Console (RDBMS) |
| 11-01 | AIGC | ChatDBA Knowledge Base Management | ChatDBA supports users in custom database management, allowing users to enter custom terms to influence ChatDBA's responses. | Intelligent Question-Answering Bot ChatDBA |
| 11-01 | Basic Services | DB2 Permission Request Support | DB2 data sources now support permission control, allowing users to request permissions for DB2 data sources, databases, and sensitive columns through the NineData console. | Permission Request and Approval |
October
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 10-25 | Data Comparison | Optimization of PostgreSQL Data Comparison Functionality | Added trigger and stored procedure comparison in the structure comparison scenario between PostgreSQL data sources. | Structure Comparison |
| 10-25 | Data Replication | Kafka Replication to ClickHouse | Supported data replication from Kafka to ClickHouse for effective processing and analysis of real-time data. | Kafka Replication to ClickHouse |
| 10-25 | Basic Services | Addition of Data Source Support | Added support for Greenplum data sources. | Create Data Source |
| 10-18 | Database DevOps | View Sessions (PostgreSQL, Oracle, OceanBase Oracle) | Display information about all active connections on the current PostgreSQL, Oracle, and OceanBase Oracle database servers, as well as the queries being executed by these connections. | SQL Tasks (RDBMS) |
| 10-18 | Database DevOps | Data Import (Oracle, OceanBase Oracle) | Data import functionality now supports Oracle and OceanBase Oracle data sources, allowing you to import SQL, CSV, and EXCEL files containing data into the target database. | Data Import |
| 10-18 | Database DevOps | Database DevOps Guidelines Support for DB2 | Database DevOps guidelines now support configuring rules for DB2 data sources, with 20 structural rules currently supported for DB2. | Database DevOps Policy Overview |
| 10-18 | Database DevOps | SQL Task (DB2) | The SQL task functionality now supports DB2 data sources, allowing you to initiate change requests for DB2 through SQL tasks. It supports immediate or scheduled execution. | SQL Tasks (RDBMS) |
| 10-18 | Basic Services | Upgraded Data Source Creation Page | To enhance the user experience, NineData's data source creation page has undergone a major overhaul. It consolidates the diverse data source types and major cloud vendor instance types into separate modules, presenting a clean and intuitive creation page for you to smoothly add data sources. | Create Data Source |
| 10-11 | AIGC | ChatDBA Major Model Upgrade | Upgrade of DBCopilot major model, adding knowledge base retrieval for databases to enhance the quality of database-related Q&A. | Intelligent Q&A Bot ChatDBA |
| 10-11 | AIGC | ChatDBA Questioning Limit in Unlogged State | The number of questionings in ChatDBA for unregistered or unlogged-in users has been increased from 3 to 10. | Intelligent Q&A Bot ChatDBA |
| 10-11 | Database DevOps | Addition of New Rule in Database DevOps Guidelines | Added the rule "" to restrict the occurrence of duplicate index names within a single table. | SQL Development Rules Overview |
| 10-11 | Database DevOps | DSQL | NineData DSQL now supports querying and aggregating data from various types of data sources to generate global query results. | DSQL |
| 10-11 | Database DevOps | SQL Console (DB2) | SQL Console functionality now supports DB2 data sources, allowing for CRUD operations on DB2 data sources via SQL Console. | SQL Console |
| 10-11 | Basic Services | Addition of Data Source Support | Added support for DB2 data sources. | Create Data Source |
September
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 09-21 | Basic Service | User Access Management | Added a configuration entry for managing user access limits, limiting the total number of queries per day and the total number of rows per day for each user within the organization. Supports global and specific user configurations. | Manage Users |
| 09-21 | Basic Service | Quick Start | Provides 5 sets of beginner-friendly tasks to guide new users through a complete experience of all NineData features from 5 dimensions, helping users who have never used NineData get started quickly. | - |
| 09-21 | Database DevOps | Sensitive Data Management | Now supports configuring sensitive columns for Oracle and OceanBase Oracle data sources. | Configure Sensitive Columns |
| 09-21 | Database DevOps | Data Import (SQL Server) | Data import functionality now supports SQL Server data sources, allowing import of SQL, CSV, and EXCEL files containing data into the target SQL Server database. | Data Import |
| 09-14 | AIGC | ChatDBA | The large model DBCopilot V1.0 developed by Nine Chapters is now online. This model has undergone targeted training in the database domain, and it boasts a smaller parameter model compared to GPT models. It is equipped with domestically deployed GPU devices, resulting in faster content generation speed than both GPT 3.5 and GPT 4.0, while maintaining content generation quality on par with GPT 3.5. | Intelligent Q&A Robot ChatDBA |
| 09-14 | Basic Services | Multi-cloud Private Network Connectivity Support | NineData now supports private network connectivity for Tencent Cloud, Huawei Cloud, AWS, and Baidu Cloud. | Create a private network connection |
| 09-14 | Database DevOps | SQL Console | Oracle and OceanBase Oracle data sources now support the following features:
| SQL Console (RDBMS) |
| 09-14 | Data Replication | MySQL Replication to Amazon Redshift | Full replication and incremental replication from MySQL to Amazon Redshift are now supported. | MySQL Replication to Redshift |
| 09-07 | Data Comparison | Oracle Data Comparison Support | Data comparison functionality now supports Oracle to Oracle and Oracle to OceanBase Oracle data source comparisons. | Data Comparison |
| 09-07 | Data Replication | MySQL Replication Enhancement | MySQL to MySQL data replication tasks have overcome the limitation of not being able to replicate from higher versions to lower versions. | MySQL Replication to MySQL |
| 09-07 | Database DevOps | Session View (Redis) | Display information on all active connections and the queries they are executing on the current Redis database server. | SQL Console (Redis) |
| 09-07 | Database DevOps | Data Export (OceanBase Oracle) | Data export functionality now supports OceanBase Oracle data source, allowing data export via SQL query or direct selection of tables. | Data Export |
| 09-07 | Database DevOps | SQL Task (OceanBase Oracle) | SQL task functionality now supports OceanBase Oracle data source, allowing the initiation of change requests to OceanBase Oracle via SQL tasks. | SQL Task |
| 09-07 | Database DevOps | SQL Console (OceanBase Oracle) | SQL Console functionality now supports OceanBase Oracle data source, allowing CRUD operations on OceanBase Oracle data source via SQL Console. | SQL Console |
| 09-07 | Basic Services | Permission Request and Approval (OceanBase Oracle) | Support for permission requests for SQL Console, SQL task, data export, and more for OceanBase Oracle data source. | Permission Request and Approval |
| 09-07 | Basic Services | MongoDB Adds Multiple Security Rules | MongoDB now supports the following rules: | SQL Development Rules Overview |
| 09-07 | Basic Services | New Data Source Support | Added support for OceanBase Oracle data source. | Create Data Source |
August
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 08-31 | ChatDBA | ChatDBA Beta Version | ChatDBA is an intelligent question-and-answer chatbot developed based on AIGC technology. It can engage in interactive conversations, assist in content creation, and answer everyday questions. | Intelligent Q&A Chatbot ChatDBA |
| 08-24 | Basic Services | Refinement of Sensitive Column Permissions | The refinement of sensitive column permissions includes two types of permissions: accessing sensitive columns in SQL Console and export ing sensitive columns in data. | Permission Application and Approval |
| 08-24 | Database DevOps | SQL Server Schema Export | The data export feature now supports schema export for SQL Server data sources. | Data Export |
| 08-24 | Database DevOps | Result Set Editing (Doris, SelectDB) | Result set editing is now supported for Doris and SelectDB. It allows editing of result sets for single-table queries with unique key columns in the result. | SQL Console (RDBMS) |
| 08-24 | Database DevOps | View Sessions (SQL Server) | Displays information about all active connections on the current database server, including the queries being executed by these connections. | SQL Console (RDBMS) |
| 08-24 | Database DevOps | Estimated Affected Rows | The SQL task configuration page has added an option for configuring estimated affected rows. If the actual execution rows differ from the estimated value, a reminder will be displayed on the page. | SQL Task |
| 08-24 | Database DevOps | Enhanced OnlineDDL Functionality | Building upon the existing NineData OnlineDDL functionality, this enhancement introduces runtime parameter configuration and provides support for viewing the progress of OnlineDDL execution. | Perform non-locking structure changes to the table using NineData OnlineDDL |
| 08-17 | Data Replication | Enhanced Incremental Replication | For data replication in relational databases, you can now choose specific operations to be included or excluded in incremental synchronization. Unchecked operations will be ignored during incremental synchronization. | Data Replication |
| 08-17 | Database DevOps | SQL Task Backup for Oracle, SQL Server | The backup feature for SQL tasks now supports Oracle and SQL Server data sources. It enables automatic backup of modified objects within SQL tasks, and the backups can be downloaded locally after completion. | SQL Tasks |
| 08-17 | Database DevOps | Session Viewing (MySQL, ClickHouse) | Displays information about all active connections on the current database server, along with the queries being executed by these connections. | SQL Console (RDBMS) |
| 08-10 | Basic Services | Data Watermark | NineData data watermark is a technology used to protect the security of console page content. It embeds a watermark containing the information of the currently logged-in user in the console of the current organization, preventing users from taking unauthorized screenshots or printing the current page information. | Manage Data Watermark |
| 08-10 | Database DevOps | Data Export Supports Oracle, SQL Server | Data export feature now supports Oracle and SQL Server data sources. | Data Export |
| 08-08 | Database DevOps | SQL Console Optimization | Supports the operation on the query result set of the SQL console window, allowing copying of the entire column's contents. | SQL Console (RDBMS) |
| 08-03 | Basic Services | Gateway Disaster Recovery | NineData Gateway now supports disaster recovery, automatically restarting after server reboots or gateway process shutdowns to ensure stable data source connections. | Manage Gateway |
| 08-03 | Basic Services | Permission Application Supports ClickHouse Data Source | Supports applying for SQL console permissions for ClickHouse data sources. | Permission Application and Approval |
| 08-03 | Data Comparison | Data Comparison Support for Doris|SelectDB and Performance Optimization | Data comparison functionality is now available for MySQL to Doris and MySQL to SelectDB data sources, along with performance optimization achieving an RPS of 100,000. | Data Comparison |
| 08-03 | Data Comparison | PostgreSQL Data Comparison | NineData data comparison supports data and structure comparison between PostgreSQL data sources. | Data Comparison Structure Comparison |
| 08-03 | Data Replication | MongoDB Data Replication | NineData data replication supports data synchronization between MongoDB data sources. | Data Replication Between MongoDB |
| 08-03 | Data Replication | PostgreSQL Data Replication | NineData data replication supports data synchronization between PostgreSQL data sources. | Data Replication Between PostgreSQL |
| 08-03 | Data Replication | MySQL Replication to SelectDB | NineData data replication supports full and incremental data synchronization from MySQL to SelectDB data sources. | MySQL Replication to SelectDB |
| 08-03 | Data Replication | MySQL Replication to Doris | NineData data replication supports full and incremental data synchronization from MySQL to Doris data sources. | MySQL Replication to Doris |
| 08-03 | Database DevOps | SQL Console | When hovering the mouse over a tab representing a target result set in the query result set below the SQL console, the corresponding SQL statement for that result set will be displayed. | SQL Console (RDBMS) |
| 08-03 | Database DevOps | SQL Console | When hovering the mouse over a table name, column name, or index name in the left navigation tree of the SQL console, detailed information will be displayed. | SQL Console (RDBMS) |
| 08-03 | Database DevOps | Database DevOps Guidelines for PostgreSQL Data Source | Supports Database DevOps guidelines for PostgreSQL data sources. | Manage Database DevOps Guidelines |
July
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 07-27 | Basic Services | Database DevOps Professional Version | New addition of Database DevOps Professional version. | Introduction to Database DevOps |
| 07-20 | Basic Services | New Data Source Support | Newly added support for Oracle data source. | Create Data Source |
| 07-13 | Data Comparison | Data Comparison for MongoDB | Data comparison functionality is now available for MongoDB data sources. | Data Comparison |
| 07-13 | Basic Services | Mobile Approval | You can view approval tasks on mobile devices (phones, tablets, etc.) via NineData's approval links (WeChat, Feishu, SMS, email, etc.). Supports Approve and Reject operations. Mobile approval supports the SQL Task, Data Export, Data Import, and Permission and Application modules. | N/A |
| 07-13 | Database DevOps | SQL Intelligent Optimization | Improved AI for more accurate information on intelligently optimized SQL statements. | SQL Console (RDBMS) |
| 07-06 | Database DevOps | Database DevOps for SQL Server Data Source | Supports the following for SQL Server data source:
| SQL Task Manage Database DevOps Policies |
June
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 06-29 | Data Comparison | Performance Optimization for International Regions | Optimized data comparison performance for international data sources, achieving performance improvements of several tens of times compared to before. | Data Comparison |
| 06-29 | Data Replication | Support for Spatial Data Types | Replication tasks between MySQL databases now support replication of spatial data types. | Data Replication |
| 06-29 | Data Replication | Performance Optimization for International Regions | Optimized replication performance for data sources in international regions, achieving performance improvements of several tens of times compared to before. | Data Replication |
| 06-27 | Basic Services | Added Cloud Vendor Support | Added support for Alibaba Cloud, Tencent Cloud, and Huawei Cloud MongoDB database instances. | Create Data Source |
| 06-27 | Basic Services | Added Deployment Mode Support for Redis | Supports Redis data sources in cluster mode. | Create Data Source |
| 06-20 | Basic Services | Permission Application Support for MongoDB and SQL Server | Supports applying for various permissions for MongoDB and SQL Server data sources. | Permission Application and Approval |
| 06-15 | Data Replication | Support for Large MySQL Transactions | NineData's data replication feature now supports parsing and replicating super-large transactions (over 4 GB) in MySQL databases. | Data Replication |
| 06-15 | Database DevOps | Enhanced SQL Task | Two new features added to SQL tasks:
| SQL Task |
| 06-15 | Database DevOps | Added Rules for SQL Task and Windows | Added execution time configuration rules for DML, DDL, and DQL, limiting the executable time range of SQL tasks. | Managing Database DevOps Policies |
| 06-15 | Basic Services | User Switch | System administrators can enable or disable functions for target users using the user switch. | Managing Users |
| 06-15 | Basic Services | Allow SSO Accounts to be Automatically Added | When configuring the SSO login function, enabling this option automatically adds SSO members to NineData without manual operations. | Enable SSO Login |
| 06-13 | Database DevOps | Data Export Support for PostgreSQL | The data export feature now supports exporting table data from PostgreSQL to SQL files based on SQL query statements. | Data Export |
| 06-13 | Database DevOps | Enhancements to SQL Tasks | SQL task functionality has been enhanced with features such as automatic data backup before execution, rollback scenario entry window, task pause, and task restart. | SQL Tasks |
| 06-08 | Database DevOps | MongoDB Support in SQL Console | NineData SQL Console now supports managing MongoDB databases. | SQL Console |
| 06-08 | Basic Services | Addition of MongoDB Data Source Support | Added support for MongoDB data sources. | Create Data Source |
| 06-01 | Database DevOps | Database DevOps Enterprise Edition | NineData has released Database DevOps Enterprise Edition, providing a comprehensive set of powerful enterprise-level capabilities, including team collaboration, permission control, audit logs, SSO (Single Sign-On), SQL development standards, approval workflows, and more. | Database DevOps |
May
| Release Date | Module | Feature | Release Details | Related Links |
|---|---|---|---|---|
| 05-25 | Basic Services | Added Cloud Provider Support | Added support for Baidu Cloud's Cloud Database RDS and Cloud Database SCS for Redis. | Create Datasource |
| 05-25 | Basic Services | Permission Request | Added support for requesting permissions for PostgreSQL datasource, database, and schema. | Permission Request and Approval |
| 05-25 | Database DevOps | SQL Task | Added support for SQL tasks on PostgreSQL, Doris, and SelectDB datasources. | SQL Task |
| 05-25 | Database DevOps | SQL Console | NineData SQL Console now supports managing PostgreSQL databases. | SQL Console |
| 05-23 | Basic Services | New Data Source Support | Added support for PostgreSQL data source. | Create Data Source |
| 05-18 | Data Replication | Incremental Replication Logic Enhancement | During the incremental replication process from MySQL to ClickHouse, if a DDL change is executed on the source side, the program will automatically check on the target side if there are objects with identical structures. If such objects exist, the change will be automatically ignored, and the subsequent incremental replication tasks will continue. | Data Replication |
| 05-11 | Basic Services | New Data Source Support | Added support for SelectDB data source. | Create Data Source |
| 05-11 | Basic Services | New Data Source Support | Added support for Doris data source. | Create Data Source |
| 05-11 | Basic Services | Redis Sentinel Mode | Added support for Redis Sentinel Mode deployment architecture when configuring Redis data source. | Create Data Source |
April
| Release Data | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 04-27 | Data Replication | Compatibility with Lower Version MySQL | Compatibility with MySQL versions 5.7 and below, including support for handling unsigned and Binary data types, ensuring data consistency. | Data Replication |
| 04-27 | Database DevOps | SQL Console (Redis) | NineData SQL Console now supports managing Redis databases, allowing users to easily view, edit, and manage Redis data, as well as create, delete, and modify Redis databases. | SQL Console (Redis) |
| 04-20 | Data Replication | Bidirectional MySQL Replication | NineData's data replication feature supports bidirectional synchronization tasks between multiple MySQL data sources, enabling the construction of real-time synchronization chains with three nodes or more. | Data Replication Between Multiple Data Sources |
| 04-20 | Data Replication | Elasticsearch Data Replication | NineData's data replication supports data replication from MySQL to Elasticsearch, supporting both full and incremental replication. | MySQL Replication to Elasticsearch |
| 04-20 | Database DevOps | Data Import | NineData supports data import function, which allows users to import files containing SQL scripts or data content into target databases, supporting files up to 5 GB in size. | Data Import |
| 04-06 | Basic Services | Support for new data sources | NineData now supports Alibaba Cloud AnalyticDB for MySQL data source, as well as Alibaba Cloud, Tencent Cloud, and Huawei Cloud Elasticsearch data sources. | Creating Data Sources |
| 04-06 | Basic Services | Subscription Management - Data Export | The Subscription Management module now supports data export, and allows for configuration of alarm methods for data export tasks. | Subscription Management |
| 04-06 | Data Comparison | Redis Data Comparison | NineData Data Comparison now supports data comparison between Redis data sources. | Data Comparison |
| 04-06 | Data Replication | SQL Server Incremental Replication | Data replication between SQL Server instances now supports incremental replication. | Data Replication between Self-built Databases |
| 04-06 | Data Replication | Redis Data Replication | NineData Data Replication now supports data replication between Redis data sources. | Data Replication between Redis Instances |
| 04-06 | Data Replication | Automatic MySQL Storage Engine Conversion | When replicating from a lower version (5.7) of MySQL to a higher version (8.0), partitioned tables with the MyISAM storage engine are automatically converted to InnoDB, resolving the issue of MyISAM not being supported in versions 8.0 and above. | MySQL Replication to MySQL |
| 04-06 | Database DevOps | OnlineDDL | NineData SQL tasks now support the OnlineDDL feature, which can execute structural changes to a table without blocking normal reads and writes to that table. | Using NineData OnlineDDL to perform non-blocking changes to table structures |
March
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 03-23 | Data Comparison | Data|Structure Comparison for SQL Server | The data comparison feature supports comparing data and structure for SQL Server data sources. | Data Comparison Structure Comparison |
| 03-23 | Database DevOps | AI Help | Right-click on the selected target SQL statement in the SQL console, and click on . AI will analyze the SQL statement and explain its logic. | SQL console |
| 03-23 | Database DevOps | Code Conversion | Support converting target functions and stored procedures to Java, Python, C++, C#, Golang, Rust, and NodeJS code. | SQL console |
| 03-18 | Data Replication | MySQL to Kafka Replication | NineData replication now supports replicating data from MySQL to Kafka, achieving real-time data flow and distribution. | MySQL to Kafka |
| 03-18 | Data Replication | Incremental Replication Performance Optimization | The performance of incremental replication from MySQL to ClickHouse has been improved by 100 times, reaching an RPS of 200,000 and a data throughput of 40 MB/s. | Data Replication |
| 03-16 | Database DevOps | Data Export | Data Export allows data from a data source to be exported as data files in multiple ways (SQL statements, databases and tables), and in multiple formats (SQL, CSV, Excel). Strict access control is available for the data export process, and it must go through an approval process to ensure data security. | Data Export |
| 03-14 | Database DevOps | Intelligent SQL Update | The following features have been added:
| SQL Console Using AI to Manage Data Sources |
| 03-09 | Data Comparison | Data|Structure Comparison Optimization | Supports data and structure comparison for databases with over 100,000 tables. | Data Comparison |
| 03-09 | Basic Services | Permission Management | The system administrator role can manage all permissions for users. | Configure user permissions |
| 03-09 | Basic Services | My Permissions | Displays all the permissions the current account has. | My Permissions |
| 03-09 | Basic Services | Approval Workflow (Data Sources, Databases) | Provides a work order application process for data sources and databases that cannot be viewed without permission in the organization. | Permission Application and Approval |
| 03-09 | Basic Services | Audit Logs | The audit logs mainly record the who, when, object, and operation of what has been done. By viewing the audit logs, system administrators can track the history of operations that have occurred in the console to analyze changes made by users and security events. | View Audit Logs |
| 03-02 | Basic Services | Support for new data sources | Added support for Huawei Cloud RDS SQL Server data source. | Create Data Source |
| 03-02 | Database DevOps | Standard inheritance, process inheritance | Added logic for inheritance of standards and processes, i.e., a data source will inherit the standards and processes configured in its bound environment. You can cancel the inheritance and customize the configuration of standards and processes. |
February
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 02-23 | Data Replication | Blacklist | Added support for adding databases or objects that do not need to be replicated to the blacklist. | Data Replication |
| 02-23 | Data Comparison | Quick Comparison | The data comparison feature between MySQL instances supports fast comparison. Users can specify a sampling ratio to quickly compare data on both ends through sampling. | Data Comparison |
| 02-23 | Database DevOps | Intelligent SQL | Added intelligent SQL feature, which can quickly convert natural language expressions into SQL queries. | Use AI to Manage Data Sources |
| 02-23 | Database DevOps | SQL console standard pre-check | Under organizational modeOrganizational mode supports assigning different roles and resource management permissions to each user under an organization, suitable for multi-user collaborative development within the same organization, while ensuring data security and improving overall production efficiency., the system will check every SQL executed in the SQL console against the Database DevOps Standards configured based on . If the SQL does not comply with the standards, the system will intercept it to ensure database security. After interception, users can modify the SQL according to the standards and resubmit it, or directly submit a SQL task based on the approval process configured based on . | SQL task |
| 02-23 | Database DevOps | SQL Task Revamp | SQL tasks have been revamped with the addition of SQL standard pre-checks and workflow approval functions. | SQL Task |
| 02-23 | Basic Services | Message Subscription | The subscription management feature supports custom notification methods for different subscription types, making it easier for you to manage message delivery and improve operational efficiency. | Subscription Management |
| 02-23 | Basic Services | In-site Message | The in-site messaging feature is used to send internal messages, including approval flows, product updates, and notifications. | In-site Message |
| 02-23 | Basic Services | Single Sign-On SSO | Support for logging into the NineData console via Single Sign-On (SSO) has been added, reducing login time costs and improving efficiency. | Introduction to Single Sign-On SSO |
| 02-23 | Basic Services | SQL Standards and Workflow | SQL development standards and workflow approval functions support rule setting, linkage approval, and execution operations based on table structure definition, data query, and other dimensions. | Introduction to Standards and Workflow |
| 02-09 | Data Replication | Time Zone Conversion | In full replication between MySQL instances and from MySQL to ClickHouse, if there are time-related data, support is provided to automatically convert Timestamp values based on different source and destination time zones. | Data Replication |
| 02-09 | Data Replication | Structural Replication Performance Optimization | Significantly enhance the performance of structural replication, achieving a 1200% performance improvement for replicating the database structure of 100,000 tables. | Data Replication |
| 02-02 | Basic Services | Add Region | Added AWS-US West (Northern California) region. | Create Data Source |
January
| Release Date | Module | Function | Release Details | Related Links |
|---|---|---|---|---|
| 01-17 | Data Comparison | Time Zone Conversion | In comparisons between MySQL instances, as well as from MySQL to ClickHouse, if time-related data is present, there is support for performing time conversions based on time zones before executing the comparison. | Data Comparison |
| 01-10 | All | Internationalization | NineData English version released. | Documentation |
| 01-04 | Data Replication | MySQL Replication to ClickHouse | NineData data replication now supports full data synchronization and incremental data synchronization from MySQL to ClickHouse. | MySQL Replication to ClickHouse |
| 01-04 | Data Replication | Throttling | Full and incremental data replication support throttling to limit the rate at which data is written to the target data source per second. | Data Replication |
| 01-04 | Database DevOps | Smart Tips for SQL Server and ClickHouse | SQL smart tips are now available for SQL Server and ClickHouse data sources in the SQL console. | SQL Console |
| 01-04 | Database DevOps | SQL Console Settings |
| SQL Console |
| 01-04 | Database DevOps | Save and View SQL | Users can now save SQL statements from the SQL console to NineData and view saved SQL statements. | SQL Console |