Updated on 2023-06-02 GMT+08:00

Creating MySQL Data Connections

Before establishing a data connection to a MySQL database, create a MySQL data connection first.

Prerequisites

  • You have obtained the IP address and port number of the MySQL data source, and the username and password for logging in to the MySQL database. In addition, you must have the SELECT permission on the database to be connected.
  • You have used the CDM cluster as the network proxy or an Internet connection proxy to connect your screen to the MySQL data source network.
    • If you use a CDM cluster, the following requirements must be met:
      • You need to create a CDM cluster on the CDM console. The CDM cluster and DLV must be in the same region. For details about how to create a CDM cluster, see Creating a CDM Cluster.
      • If the MySQL data source is not on Huawei Cloud, the host where the MySQL data source is located must have a public IP address, and the CDM cluster must be bound with an elastic IP address (EIP).
      • If the MySQL data source is on Huawei Cloud, the host where the MySQL data source is located must be in the same region, AZ, and VPC as the CDM cluster.
      • If the firewall is enabled on the host where the MySQL data source is located, the inbound and outbound rules of the firewall must allow the access of the MySQL database port and the CDM cluster address.
      • The inbound and outbound rules of the security group to which the CDM cluster belongs must allow the access of the IP address and port of the MySQL database.
    • If you use the Internet to connect to the data source, an EIP must be bound to the ECS where your MySQL database is deployed. The ECS and DLV must be in the same region and VPC, and can communicate with each other.

Creating a MySQL Data Connection

  1. Log in to the DLV console.
  2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.

    Figure 1 Creating a data connection

  3. In the New Data Connection dialog box, set Data Source Type to MySQL and set the related parameters.

    Figure 2 Creating a MySQL data connection

    Table 1 describes the MySQL data connection parameters.

    Table 1 MySQL data connection parameters

    Parameter

    Description

    Name

    Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).

    Domain Name

    IP address of the database. Private zones are not supported.

    Port

    Port of the database.

    Username

    Username of the database. The database user must have permission to access data tables and metadata.

    Password

    Password of the database user.

    Agent

    Select an available connection agent, such as VPC connection, CDM proxy, or Internet.

    NOTE:

    MySQL is not a fully managed service and thus cannot be directly connected to fully managed DLV. A CDM cluster serves as an agent that enables communication between them.

    Database

    You can select a database from the Database drop-down list.

  4. Click OK.

Using MySQL Data Sources

You can configure and use the MySQL data source by referring to the instructions in Using DWS Data Sources.