OceanBase Migration Assessment (OMA) is a database compatibility assessment tool provided by OceanBase Migration Service (OMS). This topic describes the application scenarios of OMA.
OMA manages the entire lifecycle of data migration from your database system to OceanBase Database. OMA is applied in the following scenarios at different phases of the entire lifecycle:
Before OMS data migration
OMA can generate a profile of the source database and identify required application modifications based on the compatibility assessment. This helps you better understand the database topology, application topology, and overall database load, which helps you prepare the migration strategy accordingly.
During OMS data migration
During full or incremental data migration by using OMS, OMA captures SQL statements in the source database or workload capture replay (WCR) files of the database to replay the SQL statements in the destination OceanBase database to verify the correctness and performance of the SQL statements. This helps OceanBase Database identify and resolve compatibility and performance issues.
After OMS data migration and before business switchover
After full data migration is completed, OMS continuously performs incremental data migration. During this process, OMA simulates the real traffic of OceanBase Database or multiple times the traffic to perform stress testing by using the data replay and accelerated replay features. In this way, OMA assesses the stress testing performance of OceanBase Database and provides reports to facilitate your decision-making and reduce migration risks.
Before an OceanBase database is upgraded or changed
OMA can perform a data replay to test the performance of the new version of your OceanBase database and generate a test report to minimize the risk caused by the upgrade or change.