This topic describes the application scenarios and operation process of compatibility assessment and performance assessment of the migration assessment feature.
Compatibility assessment
The compatibility assessment capability of migration assessment 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 capability assesses the compatibility of objects and SQL or PL/SQL statements of databases, and supports database profiling.
Capability | Description |
Database object assessment |
|
Assessment of database SQL or PL/SQL statements |
|
Database profiling |
|
The operation process of compatibility 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.
Execute the compatibility assessment task.
The migration assessment feature supports online assessment and offline assessment. For more information, see Execute online assessment and Execute offline assessment.
Execute assessment and generate a report.
After you start an assessment task, the migration assessment feature generates a corresponding assessment report based on the specified assessment type.
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 the assessment report.
Performance assessment
In compatibility assessment, the migration assessment feature 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 feature also performs a thorough performance assessment.
Performance assessment is performed in the following process:
Obtain the traffic file of the RDS_MySQL instance or PolarDB-X instance and upload it to an OSS bucket. For more information, see Prerequisite operations.
Create a performance assessment task in the migration assessment console.
You can select any of the following three modes for the performance assessment task as needed: Full Performance Assessment, SQL File Parsing, and SQL File Replay. For more information, see Create a performance assessment task.
Start the performance assessment task.
After the performance assessment task is completed, a workload replay report is generated.
Application scenarios
Migration assessment is applicable before you migrate data from your database system to OceanBase Database. You can use the migration assessment feature 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 feature is capable of compatibility assessment for source database objects and SQL statements. This enables you to understand and handle the incompatibilities of OceanBase Database with the source 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