Migration from VM Percona to JCS for Percona

Here we mainly talk about how to migrate from the self-build Percona in the VM to the JD Cloud’s JCS for Percona. The self-build Percona requires you to do the daily operation, maintenance, monitoring, backup, etc. of the Percona service, while the JD Cloud’s JCS for Percona eliminates these troubles and you only need to focus on the use.

Precautions

*The new Percona instance and the VM need to be in the same VPC. *The capacity space of new Percona instance must not be less than that of the self-build Percona in the VM.

Operation Steps

To create the JCS for Percona, Please refer to Create RDS instances for specific steps.
Creating the database through the console ensures that the name of the database to be exported in the self-build Percona in the VM is also created in the JCS for Percona. For specific steps, please refer to Create databases.
Create database account through the console, which also can be the account used for creating JCS for Percona. Then grant read/write permission for the new database created in the step 2 of operation. Specific creation steps see [Create Account] ](../../../Operation-Guide/Account/Create-Account/Percona-Create-Account.md).
After completing the creation and initialization of the JCS for Percona, start to export the data from the self-build Percona in the VM to the local VM, and execute the command
复制成功
```
 mysqldump -u User name -p Password --single-transaction --set-gtid-purged=OFF -B Database name > /Path/Outputted file name.sql
 
```
Parameter Description
User name: User name of self-built database.
Password: Password of self-built database.
Database name: Fill in database names to be outputted and separate several database names with spaces
After the data is exported from the self-build Percona in the VM to the local, import the data to the JCS for Percona, and execute the command
复制成功
```
 mysql -u User name -p Password -h Cloud database domain name < /Path/Outputted file name.sql
 
```
Parameter Description
User name: User name in the actions of step 3
Password: Corresponding password of the user in actions of step 3
Database domain: Please view domain of Percona Service in the Details page of instance.
If there is no error message, the import is successful. Log in to JCS for Percona for data verification.

Import from Virtual Machine Percona

Products

开始与售前顾问沟通

可直接拨打电话 400-098-8505转1