To run AnalyticDB for MySQL 3.0 tasks in DataWorks — including data synchronization, data development, and data analysis — bind your cluster to the workspace as an AnalyticDB for MySQL (V3.0) computing resource. Once bound, DataWorks connects to the cluster through this resource.
Steps at a glance:
-
Check prerequisites and limitations.
-
Go to the computing resources page for your workspace version.
-
Configure and bind the resource with your cluster credentials.
-
Verify connectivity and confirm the binding.
Prerequisites
Before you begin, make sure you have:
-
An AnalyticDB for MySQL 3.0 cluster in the same region as your DataWorks workspace. Clusters in a different region cannot be bound as a computing resource. See Create an AnalyticDB for MySQL 3.0 cluster.
-
A DataWorks workspace with yourself added as a member and assigned the Workspace Administrator role. See Create a workspace.
-
A resource group bound to the workspace, with network connectivity to the cluster confirmed:
-
Serverless resource group: Confirm that the AnalyticDB for MySQL (V3.0) computing resource can connect to the Serverless resource group.
-
Legacy exclusive resource group: Confirm that it can connect to the exclusive resource group for scheduling for your scenario.
-
In both cases, the resource group and the cluster must be in the same Virtual Private Cloud (VPC). Add the IP addresses of the resource group to the whitelist of the cluster.
-
Limitations
Supported regions: China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), and Indonesia (Jakarta).
Required permissions:
| Operator | Required permissions |
|---|---|
| Alibaba Cloud account | No extra permissions required |
| RAM user / RAM role | Must have the O&M or Workspace Administrator role, or the AliyunDataWorksFullAccess permission. See Grant permissions to a workspace administrator. |
Bind the computing resource
Select the procedure that matches your workspace version:
New Data Studio: Bind an AnalyticDB for MySQL (V3.0) computing resource
Use this section if your workspace has Use Data Studio (New Version) enabled.
Go to the computing resources page
-
Log on to the DataWorks console. Switch to the target region. In the left-side navigation pane, click . Select your workspace from the drop-down list and click Go To Management Center.
-
In the left-side navigation pane, click Computing Resources.
Configure and bind the resource
-
Click Bind Computing Resource.
-
On the Bind Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). The Bind AnalyticDB For MySQL (V3.0) Computing Resource configuration page opens.
-
Set the parameters:
Parameter Description Required Configuration Mode Only Alibaba Cloud Instance Mode is supported. Yes Alibaba Cloud Account Only the current Alibaba Cloud account is supported. Yes Instance Select the AnalyticDB for MySQL 3.0 cluster to bind. To create a new cluster, click Create in the drop-down menu. Yes Database Name The name of an existing database in the cluster. Yes Username and Password The database account and password for accessing the cluster. If you don't have an account, create one. Yes Computing Resource Instance Name A custom name for this computing resource. Tasks use this name to identify and select the resource at runtime. Yes -
In the connection settings section, select the resource group that DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Click Test Connectivity to confirm the resource group can reach the cluster. For network troubleshooting, see Overview of network connection solutions.
-
Click Confirm.
When you bind 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 section of the current workspace.
Legacy Data Studio: Bind an AnalyticDB for MySQL (V3.0) computing resource
Use this section if your workspace does not have Use Data Studio (New Version) enabled.
Go to the computing resources page
-
Log on to the DataWorks console. In the top navigation bar, select the target region. In the left-side navigation pane, choose . Select your workspace and click Go to Data Development.
-
In the left-side navigation pane, click the
icon to open the Computing Resources page.
Configure and bind the resource
-
Click Create Computing Resource.
-
On the Create Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). The Create Computing Resource configuration page opens.
-
Set the parameters:
Parameter Description Required Data Source Name A custom name for this computing resource. Tasks use this name to identify and select the resource at runtime. Yes Configuration Mode Select Alibaba Cloud Instance Mode. Connection String Mode does not support binding a computing resource — it only creates a data source. Yes Alibaba Cloud Account Select Current Alibaba Cloud Account or Other Alibaba Cloud Account. If you select Other Alibaba Cloud Account, fill in the additional account parameters as prompted. Yes Region The region where your workspace resides. Yes Instance Select the AnalyticDB for MySQL 3.0 cluster in the current region. Yes Database Name The name of an existing database in the cluster. Yes Username and Password The database account and password for accessing the cluster. If you don't have an account, create one. Yes -
In the connection settings section, select the resource group DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Click Test Connectivity to confirm the resource group can reach the cluster. For network troubleshooting, see Overview of network connection solutions.
-
Click Create Computing Resource And Bind To Data Development.
When you bind 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 section of the current workspace.
Appendix: Connection string mode
Connection String Mode does not support binding a computing resource. It creates a data source only. Use the following parameters to configure an AnalyticDB for MySQL 3.0 data source in Connection String Mode:
| Parameter | Description | Required |
|---|---|---|
| JDBC URL | Format: jdbc:mysql://ServerIP:Port/Database. ServerIP: the Internet or VPC endpoint of the cluster. Port: the VPC port number (default: 3306). Database: the name of an existing database in the cluster. |
Yes |
| Username and Password | The database account and password for accessing the cluster. If you don't have an account, create one. | Yes |
What's next
After binding the computing resource, use it to run tasks in DataWorks:
-
New Data Studio: Use an offline sync node for data synchronization and an ADB for MySQL node for data development.
-
Legacy Data Studio: Use nodes for data synchronization and an AnalyticDB for MySQL node for data development.