This topic describes the application scenarios and operation process of the compatibility assessment and performance assessment features of the migration assessment service.
Compatibility assessment
The compatibility assessment feature of the migration assessment service systematically analyzes your database objects and SQL statements and provides automatic conversion solutions based on the best practices of migration to OceanBase Database, to significantly lower the technical barrier and reconstruction costs in migration to the cloud.
The migration assessment service assesses the compatibility of objects and SQL or PL/SQL statements of databases, and supports database profiling.
Capability | Description |
Database object assessment |
|
Assessment of SQL or PL/SQL statements |
|
Database profiling |
|
Three types of compatibility assessments are supported: online assessment, offline assessment, and incremental DDL assessment. Their procedures are as follows.
Online assessment and offline assessment
Collect database objects.
You can manually collect database object definitions or use the migration assessment collector, which automatically collects database objects. For more information, see Collect database objects by using the migration assessment collector.
Online assessment requires connecting to the target database and collecting source database information such as database objects, SQL statements, and database load.
Offline assessment requires uploading SQL, MyBatis, or iBatis files, or files collected by the migration assessment service.
Execute an online assessment or offline assessment task.
Execute assessment and generate a report.
After the online or offline assessment task starts, the migration assessment service generates an assessment report based on the assessment type you selected.
View and download the assessment report.
After the assessment report is generated, you can view and download it. For more information, see View and download a compatibility assessment report.
Incremental DDL assessment
Enter the DDL statements for assessment.
Submit an incremental DDL assessment task.
In the Incremental DDL Assessment dialog box, view information in the Assessment Result and Assessment Details sections.
For more information, see Execute incremental DDL assessment.
Performance assessment
In compatibility assessment, the migration assessment service performs feasibility analysis and provides intelligent conversion solutions for smooth migration of objects and SQL statements from a heterogeneous database. Before you switch your business applications to OceanBase Database, the migration assessment service also performs a thorough performance assessment.
The performance assessment procedure is as follows:
Obtain the traffic file of the RDS_MySQL instance or PolarDB-X instance and upload it to an Object Storage Service (OSS) bucket. For more information, see Obtain the traffic files of an instance.
Create a performance assessment task in the migration assessment console.
Three types of performance assessment tasks are supported: Full Assessment, SQL File Parsing, and SQL File Replay. You can select an assessment task type as needed. For more information, see Create a performance assessment task.
Start the performance assessment task.
After the performance assessment task is completed, a load replay report is generated.
Scenarios
The migration assessment service is applicable before you migrate data from your database system to OceanBase Database. You can use the migration assessment service to create a profile of the source database so that you can understand the current database topology, application topology, and overall database load and thereby develop proper migration strategies.
In addition, the migration assessment service is capable of compatibility assessment for source database objects and SQL statements. This enables you to understand and handle the incompatibilities of the source database with OceanBase Database before migration, so as to ensure smooth data migration.
You can also assess the performance of OceanBase Database in the following scenarios:
When you replay application workloads of migration from heterogeneous databases such as RDS for MySQL and PolarDB-X to OceanBase Database
When you perform a stress test on business changes or performance bottlenecks of a quasi-production cluster or a production cluster during off-peak hours.