Shulou(Shulou.com)06/03 Report--

Next, let's take a look at how to migrate MySQL. DMS can migrate far more than SQL Server, MySQL, Mongo, Oracle, and even heterogeneous migration. Let's take a look at how to migrate from Azure's MySQL RDS to Azure's PaaS MySQL.

The overall migration of MySQL can be divided into the following three major steps

1. Configure AWS RDS parameter groups to prepare for migration environment

two。 Migrate database schema

3. Migrate data

First of all, AWS RDS, we need to configure some parameter groups and set some parameters of Binlog

Create a new parameter group with the following configuration:

Binlog_format = row

Binlog_checksum = NONE

Change the relevant configuration in the parameter group

Then we need to associate the parameter group we just created in RDS

These steps are relatively simple, and then you need to restart MySQL.

Otherwise, what you will see will always be pending reboot. In addition, you need to set up security group, so we will not repeat these steps.

Then we can start migrating the schema of the database, and we can use mysqldump to export the schema

Use the following command to connect to mysql,mysqldump.exe-h mxyrds.c4u9uhbque93.rds.cn-north-1.amazonaws.com.cn-p-- database test-- no-date > d:\ test.sql

After that, you can see that the script that creates the schema is exported to a file, and then the data is imported into the database using the mysql program.

Mysql.exe-h mxymysql.mysql.database.chinacloudapi.cn-u mengxiyuan@mxymysql-p test

Enter the source and destination information here, and pay attention to setting the firewall rules in advance

Here you can select the source library and the corresponding target library to be migrated

Then you can begin to prepare for the migration.

This migration can also be incremental, so I won't demonstrate it here.

The process used is actually very similar to the migration from SQL RDS to Azure SQL, except that the method of migrating schema is different.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.