PolarDB:Migration evaluation

Supported regions

The migration evaluation feature is available in the following regions:

China (Hangzhou), China (Shanghai), China (Shenzhen), China (Beijing), China (Zhangjiakou), China (Ulanqab), China (Chengdu), China (Hong Kong), Singapore, Indonesia (Jakarta), US (Silicon Valley), and US (Virginia).

Impact

A migration evaluation does not affect your services.

Create a migration evaluation task

1. Log on to the PolarDB console. On the Clusters page, click Migration/Upgrade Evaluation.

2. Create a migration evaluation task. PolarDB provides three ways to create a migration evaluation task:

   • From the Clusters page: In the upper-left corner of the Clusters page, click Migrate/Upgrade Evaluation.

     

   • From the Migration/Upgrade page: In the upper-left corner of the Migration/Upgrade page, click Create Migration/Upgrade Evaluation.

     

   • On the PolarDB buy page for a one-click upgrade: Select Migrate from RDS, the Source RDS Version, the target Database Engine, and the target Database Edition. Then, click Migration Evaluation.

     

3. Configure the parameters for the migration evaluation task.

   Parameter	Description
   Creation method	Select Migrate from RDS. If you create a migration evaluation task from the PolarDB buy page, you do not need to specify this parameter. The system automatically selects Migrate from RDS.
   Source RDS version	Select the engine version of the source RDS instance.
   Source RDS instance	From the drop-down list, select the source RDS instance.
   Target database engine	Select the database engine version of the destination PolarDB for MySQL cluster.
   Database edition	Select the database edition of the destination PolarDB for MySQL cluster.

   Then, click Next.

4. PolarDB prechecks and evaluates your source RDS instance and migration plan based on four categories: Basic information verification, Migration task dependency verification, Key information verification, and Other verification. Resolve any issues found based on the evaluation results.

   PolarDB has compiled a list of common issues that you may encounter during a migration evaluation and their solutions. For more information, see Common issues and solutions.

   

   Note

   DTS cannot synchronize events during migration or upgrade tasks. If the event check result is Existing, you must manually synchronize the events to the destination PolarDB cluster.

5. Click Continue to Buy or Buy to go to the PolarDB buy page and complete the subsequent steps. For more information, see Upgrade procedure.

Manage migration evaluation tasks

To view the details of an existing evaluation task, go to the Migration/Evaluation page. After an evaluation is complete, you can re-evaluate or proceed to purchase.

FAQ

-- View the triggers.
SHOW TRIGGERS;
-- Select and run the statement to delete a trigger.
DROP TRIGGER  trigger_name;

SELECT t1.table_schema, t1.table_name 
FROM information_schema.TABLES t1 LEFT OUTER 
	JOIN information_schema.TABLE_CONSTRAINTS t2 
  ON t1.table_schema = t2.TABLE_SCHEMA AND t1.table_name = t2.TABLE_NAME AND t2.CONSTRAINT_NAME 
  IN ("PRIMARY") 
WHERE t2.table_name IS NULL AND t1.table_type = "BASE TABLE" AND t1.TABLE_SCHEMA NOT IN ("information_schema", "performance_schema", "mysql", "sys");