Skip to main content

April Product Updates

In April, we continued to strengthen data replication stability and compatibility, expand slow query analysis coverage, and enhance AI-powered SQL optimization. These updates help teams work more efficiently across database migration and synchronization, performance troubleshooting, and day-to-day development and operations.

Highlights​

Data Replication: Stronger Prechecks, Conflict Handling, and Cross-Database Compatibility​

This month’s data replication updates focused on improving task creation, precheck accuracy, bidirectional startup logic, and compatibility for more database object types.

  • The workflow for creating a new replication task has been adjusted to purchase first, then start, making the creation path clearer.
  • In prechecks, data existence validation now prioritizes select 1 from table limit 1. If that times out, the system falls back to metadata queries, providing a more realistic view of source table status when metadata is inaccurate.
  • Object configuration conflict detection has been enhanced to identify loop configurations in unfinished replication tasks and cases where multiple tasks replicate the same table.
  • Loop detection and the bidirectional replication startup mechanism have been optimized. Starting the forward task no longer depends on the reverse task being started first, reducing startup blocking across the link.
  • Conflict handling policies are now more granular, with separate options for schema replication, full replication, and incremental replication, making structure and data conflict handling clearer.
  • Redis full replication performance has been optimized to improve execution efficiency for large-volume scenarios.
  • GaussDB incremental replication now supports DDL replication for non-table objects such as procedures, functions, and sequences.
  • PostgreSQL incremental replication now supports parsing and replication for COMMENT ON CONSTRAINT syntax, and foreign key dependency handling in schema replication has also been improved.
  • Improved schema replication for MySQL-compatible types to DB2 varchar, as well as replication logic for the openGauss blob type.

Database DevOps: Slow Query Analysis Now Supports TiDB and DWS​

Slow query analysis coverage expanded again in April with new support for:

  • TiDB
  • DWS

This further strengthens slow log collection and analysis for cloud-native and data warehouse scenarios, helping teams investigate slow SQL and manage performance across more database types in one unified platform.

AI Agent / Database DevOps: Expanded SQL Optimization Coverage​

This month, SQL intelligent optimization adds support for:

  • TiDB
  • DWS
  • Improved capabilities for PostgreSQL-like data sources

These enhancements improve AI-powered SQL analysis and optimization across multi-database environments, giving development and operations teams a more consistent optimization experience in heterogeneous setups.

Improvements​

Database DevOps: Better SQL Task and ChatDBA Experience​

  • Enhanced backup capabilities for Oracle SQL tasks.
  • Enhanced backup capabilities for PostgreSQL SQL tasks.
  • ChatDBA now has improved streaming file parsing, delivering a better experience when processing large files.

Data Replication: Stability Fixes​

  • Fixed an issue in MySQL data replication where field information was not sorted by ORDINAL_POSITION when retrieved.
  • Fixed an issue in incremental replication where a DDL statement beginning with a comment could trigger nested comments after additional comment insertion, resulting in a syntax error.