To develop and manage AnalyticDB for MySQL 3.0 tasks in DataWorks, you must first attach your AnalyticDB for MySQL 3.0 cluster as an AnalyticDB for MySQL (V3.0) computing resource. After the resource is attached, you can use it in various DataWorks modules to connect to your cluster for data synchronization, development, and analysis.
Prerequisites
You have created an AnalyticDB for MySQL 3.0 cluster.
NoteWhen you purchase an AnalyticDB for MySQL 3.0 cluster, select the same Region as your DataWorks workspace. If the regions do not match, you cannot attach the cluster as a computing resource to the workspace.
A workspace is created in DataWorks. The Resource Access Management (RAM) user who performs the operation must be added to the workspace and assigned the Workspace Administrator role. For more information, see Create a workspace.
A resource group is attached to the workspace, and network connectivity is established.
If you use a Serverless resource group, ensure that the AnalyticDB for MySQL (V3.0) computing resource can connect to the Serverless resource group.
If you use a legacy exclusive resource group, ensure that the AnalyticDB for MySQL (V3.0) computing resource can connect to the exclusive resource group for scheduling for your scenario.
The resource group must be attached to the same VPC as the AnalyticDB for MySQL 3.0 cluster. You must also add the IP addresses of the resource group to the whitelist of the AnalyticDB for MySQL 3.0 cluster.
Limits
Region limitations: China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), and Indonesia (Jakarta).
Permission requirements:
User
Required permissions
Alibaba Cloud account
No extra permissions are required.
RAM user or RAM role
Only workspace members with the O&M or Workspace Administrator role, or members with the
AliyunDataWorksFullAccesspermission, can attach computing resources. For more information about authorization, see Grant a user the Workspace Administrator permissions.
Attach an AnalyticDB for MySQL (V3.0) computing resource in the new Data Development
Attach an AnalyticDB for MySQL (V3.0) computing resource to a DataStudio (New Version) Public Preview workspace.
Go to the Computing resources page
Log on to the DataWorks console and select the destination region. In the navigation pane on the left, click . Select your workspace from the drop-down list and click Go To Management Center.
In the navigation pane on the left, click Computing Resources to open the Computing Resources page.
Attach the AnalyticDB for MySQL (V3.0) computing resource
On the Computing resources page, configure the AnalyticDB for MySQL (V3.0) computing resource.
Select the computing resource type.
Click Attach Computing Resource to go to the Attach Computing Resource page.
On the Attach Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). The Attach AnalyticDB For MySQL (V3.0) Computing Resource configuration page appears.
Configure the AnalyticDB for MySQL (V3.0) computing resource.
On the Attach AnalyticDB For MySQL (V3.0) Computing Resource configuration page, set the parameters as described in the following table.
Parameter
Description
Configuration pattern
Only the Alibaba Cloud instance pattern is supported.
Alibaba Cloud account
Only the current Alibaba Cloud account is supported.
Instance
Select the AnalyticDB for MySQL 3.0 cluster that you want to attach. You can also click Create in the drop-down list to create an AnalyticDB for MySQL 3.0 cluster.
Database name
Enter the name of a database that is already created in the AnalyticDB for MySQL 3.0 cluster.
Username and Password
The account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account.
Computing resource instance name
A custom name for the computing resource. At runtime, you can select the computing resource for a task based on this name.
Test the connectivity.
In the connection configuration section, select the resource group that DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Then, click Test Connectivity to verify that the resource group can access your AnalyticDB for MySQL (V3.0) cluster. For more information, see Network connection solutions.
Click Confirm to complete the configuration of the AnalyticDB for MySQL (V3.0) computing resource.
NoteWhen you attach an AnalyticDB for MySQL (V3.0) computing resource, the system automatically creates an AnalyticDB for MySQL (V3.0) data source with the same name in the Data Source module of the current workspace.
Attach an AnalyticDB for MySQL (V3.0) computing resource in the legacy Data Development
Attach an AnalyticDB for MySQL (V3.0) computing resource to a workspace that has not participated in the Data Development (DataStudio) (New Version) Public Preview.
Go to the Computing resources page
Go to the DataStudio page.
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.
In the navigation pane on the left, click the
icon to go to the Computing Resources page.
Attach the AnalyticDB for MySQL (V3.0) computing resource
On the Computing Resources page, configure the AnalyticDB for MySQL (V3.0) computing resource.
Select the computing resource type.
Click Create Computing Resource to go to the Create Computing Resource page.
On the Create Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). The Create Computing Resource configuration page appears.
Configure the AnalyticDB for MySQL (V3.0) computing resource.
On the Create Computing Resource configuration page, set the parameters as described in the following table.
Parameter
Description
Data source name
A custom name for the computing resource. At runtime, you can select the computing resource for a task based on this name.
Configuration pattern
Select Alibaba Cloud Instance Pattern.
NoteA computing resource attached in Connection String Pattern cannot be attached to the current workspace. It can only be created as a data source.
Alibaba Cloud account
You can select Current Alibaba Cloud Account or Other Alibaba Cloud Account.
NoteIf you select Other Alibaba Cloud Account, enter the parameter information for the other account as prompted on the page.
Region
The region where your workspace resides.
Instance
Select the AnalyticDB for MySQL 3.0 cluster that you want to attach in the current region.
Database name
Enter the name of a database that is already created in the AnalyticDB for MySQL 3.0 cluster.
Username and password
The account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account.
Test the connectivity.
In the connection configuration section, select the resource group that DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Then, click Test Connectivity to verify that the resource group can access your AnalyticDB for MySQL 3.0 cluster. For more information, see Network connection solutions.
Click Create Computing Resource And Attach To Data Development to complete the configuration of the AnalyticDB for MySQL (V3.0) computing resource.
NoteWhen you attach an AnalyticDB for MySQL (V3.0) computing resource, the system automatically creates an AnalyticDB for MySQL (V3.0) data source with the same name in the Data Source module of the current workspace.
Appendix
The Connection String Pattern option does not support attaching a computing resource. It only supports creating a data source. You can use the Connection String Pattern option to configure an AnalyticDB for MySQL 3.0 data source.
Parameter | Description |
JDBC URL | Format: jdbc:mysql://ServerIP:Port/Database. Note
|
Username and password | The account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account. |
What to do next
New Data Development: After you configure the AnalyticDB for MySQL (V3.0) computing resource, you can use an offline sync node for data synchronization and an ADB for MySQL node for data development.
Legacy Data Development: After you configure the AnalyticDB for MySQL (V3.0) computing resource, you can use a node for data synchronization and an AnalyticDB for MySQL node for data development.