PolarDB:Upgrade Assessment

Supported regions

The following regions support the upgrade assessment feature:

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

Upgrade assessment does not affect your business operations.

Create an upgrade assessment task

1. Log on to the PolarDB console.

2. Create an upgrade assessment task. PolarDB offers four ways to create an assessment task:

   • Create from the Clusters page: In the upper-left corner of the Clusters page, click the Migrate/Upgrade Assessment button.

     In the Migrate/Upgrade Assessment panel that appears on the right, set Creation Method (for example, Migrate from RDS), Source RDS Version (for example, MySQL 5.6), Source RDS Instance, Target Database Engine, and Edition. Then click Next.

   • Create from the Migrate/Upgrade page: In the upper-left corner of the Migrate/Upgrade page, click the Create Migration/Upgrade Assessment button.

   • On the PolarDB purchase page, perform a one-click upgrade. After selecting Upgrade from PolarDB as the creation method, specifying the Source PolarDB Version and Source PolarDB Cluster, and choosing the target Database Engine and Edition, click the Migration Assessment button.

3. Enter the parameters for the upgrade assessment task.

   Parameter name	Parameter description
   Creation method	Select Upgrade from PolarDB. If you create the upgrade assessment task from the PolarDB purchase page, this option is automatically selected.
   Source PolarDB version	Select the database engine version of the source PolarDB cluster.
   Source PolarDB instance	Select a specific cluster from the drop-down list as the source instance.
   Target database engine	Select the database engine version for the target PolarDB for MySQL cluster.
   Edition	Select the edition for the target PolarDB for MySQL cluster. Only Enterprise Edition is supported.

   Then click Next.

4. PolarDB runs a precheck and assessment from four aspects: Basic Information Validation, Migration Task Dependency Validation, Critical Information Validation, and Other Validations. Address any issues based on the assessment results.

   PolarDB provides common issues encountered during upgrade assessments and their solutions. For details, see FAQ and solutions.

   After all checks show Success, click Go to Purchase to proceed. If any check fails, click the expand icon to view details, follow the instructions to resolve the issue, and then click Reassess.

5. Click Continue Purchase or Go to Purchase to go to the PolarDB purchase page for the next steps. For details, see Upgrade steps.

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 and solutions

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");