This topic describes how to import data from MyCAT to PolarDB-X 1.0.
Migration process
Step | Description |
---|---|
Step 1: Obtain evaluation suggestions | You can use the evaluation suggestion feature of PolarDB-X 1.0 to analyze your MyCat configuration file. You can use the feature to convert the MyCAT sharding function into a sharding method that matches PolarDB-X 1.0 to the greatest extent possible. You can also use the feature to evaluate the required PolarDB-X 1.0 instance type and the ApsaraDB RDS for MySQL instance type of your database and generate an evaluation suggestion report for your reference based on your submitted business information. |
Step 2: Import data | You can use one of the following methods to import data from MyCat to PolarDB-X 1.0:
|
Step 1: Obtain evaluation suggestions
- Log on to the PolarDB for Xscale console.
- In the top navigation bar, select the region where the target instance is located.
- In the left-side navigation pane, choose .
- In the upper-right corner of the Suggestions page, click Start MyCat assessment.
- On the MyCat information page, enter or upload MyCat configuration files, such as schema.xml, rule.xml, and server.xml, and business information, and click Next. Note All MyCat configuration files are used to only generate DDL statements and evaluate the MyCat data that you want to import.
- On the Task preview page, click Start task when the Precheck Result displays Success. Note Make sure that the database endpoint in your server.xml file can connect to the Internet. Otherwise, the precheck process may fail.
- After the evaluation task is completed, perform the following steps:
- You can click Assessment Report in the Operation column to view evaluation details.
- You can click Start Import in the Operation column to import data.
Step 2: Import data
You can use one of the following methods to import data from MyCat to PolarDB-X 1.0:
- Evaluation-based import
- Log on to the PolarDB for Xscale console.
- In the top navigation bar, select the region where your instance is deployed.
- In the left-side navigation pane, choose .
- On the page that appears, find the task and click Start Import in the Operation column.
- Configure the required parameters to complete data import.
- Custom import
- Log on to the PolarDB for Xscale console.
- In the top navigation bar, select the region where your instance is deployed.
- In the left-side navigation pane, choose .
- On the Import tasks page, click MyCat custom import in the upper-right corner.
- Configure the required parameters to complete custom import.