This topic outlines how to add an OceanBase for MySQL data source in DataV, including detailed explanations of related parameter configurations. OceanBase offers strong data consistency, high availability, high performance, online expansion, high SQL standards compatibility, and cost-effectiveness.
Prerequisites
The OceanBase for MySQL data source to be added must be prepared.
You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.
Limits
Supports only Enterprise Edition or higher.
Add data source through private network
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
-
From the Type list, select OceanBase for MySQL.
-
Choose Private Network and select the region where the OceanBase instance is located.
-
Enter the database information.
Parameter
Description
Name
The name of the data source. You can specify a custom name.
VPC ID
The ID of the VPC-connected instance. This VPC is where your OceanBase instance is located. You can obtain it from the OceanBase console on the Tenant Details page in the topology graph's proxy address information. For example, if you want to access through the primary endpoint's private IP, fill in the primary endpoint's VPC ID, as shown in the primary endpoint card in the figure below: "VPC Network: vpc-bp1******".
Instance ID
The ID of the database instance under the VPC. The method to view it is the same as for the VPC ID field. If you want to access through the primary endpoint's private IP, fill in the instance ID of the primary endpoint's private IP, as shown in the primary endpoint card in the figure above: "Private IP is t61j1******1c.cn-hangzhou.oceanbase.aliyuncs.com".
Domain Name
The private network address for connecting to the database.
ImportantThis address is the domain name or IP address that the DataV server can access your database through the public network or the internal network of some Alibaba Cloud regions.
For example, when using Alibaba Cloud OceanBase for MySQL in a private network environment, the domain name example is: xxxxxxxx.oceanbase.aliyuncs.com. You can add the DataV VPC private network address to the whitelist on the OceanBase console on the Tenant Details page. Once the private network address takes effect, it can be used.
Port
The port set for the database. The default is 3306.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
insecureAuth
If your MySQL version is lower, you need to turn on the switch to configure and use MySQL.
-
After entering the database information, the system will automatically test the connection to ensure it is functioning properly.
-
Once the connection test succeeds, click OK to finalize the data source addition.
The new data source will be listed automatically in the data source list.
Add data source through public network
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
-
From the Type list, select OceanBase for MySQL.
-
Choose Public Network from the list.
-
Provide the necessary information for the OceanBase for MySQL data source.
Parameter
Description
Name
The name of the data source. You can specify a custom name.
Domain Name
The public network address for connecting to the database.
ImportantThis address is the domain name or IP address that the DataV server can access your database through the public network or the internal network of some Alibaba Cloud regions.
For example, when using Alibaba Cloud OceanBase for MySQL in a public network environment, the domain name example is: xxxxxxxx.oceanbase.aliyuncs.com. You can apply for a public network address and add the DataV public network to the whitelist on the OceanBase console on the Tenant Details page. Once the public network address takes effect, it can be used.
Port
The port set for the database. The default port is 3306.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
insecureAuth
If your MySQL version is lower, you need to turn on the switch to configure and use MySQL.
-
After entering the information, click OK to add the data source.
The new data source will appear automatically in the data source list.
What to do next
Once you have the raw data, you can consult datasource config for widget data adaptation.
FAQ
For additional questions, consult the FAQ about datasource config.