edit-icon download-icon

MySQL data source config

Last Updated: Apr 24, 2018

The MySQL relational database data source provides the ability to read data from and write data to MySQL, and supports configuring the data sync task in both wizard and script modes.

Note:

If you are using MySQL in a VPC environment, and the type is public IP, note that:

  • The connectivity test is not supported, but you can configure synchronization tasks. When creating a data source, click OK.

  • You must use the custom scheduling resource group to run the synchronization task. Make sure the connectivity is maintained between the custom scheduling resource group and the user‑created database. For more information, see Configure VPC environment to achieve data synchronization.

For the MySQL data source created by using RDS: The system automatically selects the network environment, based on the RDS instance information provided by you.

Procedure

  1. Enter the DataWorks console as a developer, and click Enter Project, as shown in the following figure.

    EnterProject

  2. Click Data Integration from the upper menu and navigate to the Data Sources page.

    DataSources

  3. Click New Source.

  4. In the dialog box, select MySQL as the data source type.

    NewSource

  5. Complete the configuration items for the data source.

    • Alibaba Cloud database (RDS)

      10

      • Type: Alibaba Cloud database.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • examples of rds ID: The instance ID of RDS.

      • examples of rds buyers id: Buyers account ID.

      • database name: The name of database.

      • Username/Password: The username and password of the database.

    • Public IP

      PublicIP

      • Type: Public IP.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:mysql://ServerIP:Port/Database.

      • Username/Password: The username and password of the database.

    • No public IP

      NopublicIP

      • Type: No public IP.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • Select resource group: It can be used to perform synchronization tasks, and in general, multiple machines can be bundled when a resource group is added. For more information, see Add scheduling resources.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:mysql://ServerIP:Port/Database.

      • Username/Password: The username and password of the database.

  6. Click Test Connectivity.

  7. When the connectivity test is passed, click Complete.

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the JDBC URL and Username/Password entered are correct.

  • Currently, test of the connectivity to data sources is unavailable in VPC environments and no public IP type.

What to do next

Now you have learned how to configure the MySQL data source. The article explains how to configure MySQL Writer plug‑in later. For more information, see Configure MySQL Writer.

Thank you! We've received your feedback.