The MySQL Data Synchronization component synchronizes data from a MySQL database to a MaxCompute project.

Machine Learning Studio allows you to configure the MySQL Data Synchronization component only in the Machine Learning Platform for AI (PAI) console. The following table describes the parameters that are used to configure the component.
Parameter Description
Instance Name The name of your ApsaraDB RDS for MySQL instance. To obtain the name of your ApsaraDB RDS for MySQL instance, perform the following steps:
  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Instances.
  3. On the Basic Information tab of the Instances page, view the name of your ApsaraDB RDS for MySQL instance in the Instance ID/Name column.
Database The name of your ApsaraDB RDS for MySQL database. To obtain the name of your ApsaraDB RDS for MySQL database, perform the following steps:
  1. Configure a whitelist. For more information, see Configure an IP address whitelist for an ApsaraDB RDS for MySQL instance.
  2. Connect to the database. For more information, see Use DMS to log on to an ApsaraDB RDS for MySQL instance.
  3. View the name, table, and table schema of the database.
Data Table The table that contains the data you want to synchronize.
Username The username that is used to log on to your ApsaraDB RDS for MySQL database. To obtain the username of your ApsaraDB RDS for MySQL database, perform the following steps:
  1. On the Basic Information tab of the Instances page, find your ApsaraDB RDS for MySQL instance and click its name in the Instance ID/Name column.
  2. In the left-side navigation pane of the instance details page that appears, click Accounts.
  3. On the Accounts tab, view the username of your ApsaraDB RDS for MySQL database.
Password The password that is used to log on to your ApsaraDB RDS for MySQL database.
Synchronization Fields By default, all columns in the database are synchronized.
Stale Data Threshold The maximum number of dirty data records that are allowed. Default value: 0.
Data Synchronization Bandwidth Default value: 1. Unit: MB/s.