Skip to main content

Create GoldenDB Data Source

NineData supports adding data sources of different types and environments to the console for centralized management. After a data source is added, you can use features such as Database DevOps, Backup and Restore, Data Replication, and Data Comparison. This topic describes how to add a GoldenDB data source to NineData.

Prerequisites

  • The server IP address of NineData has been added to the data source allowlist. The server IP address can be viewed by selecting the target region in Access Region on the Create Datasource page.

    server_ip_address

  • Make sure you have available data source quota; otherwise, the data source cannot be added. You can quickly check your remaining quota at the top-right corner of the NineData console.check_quota

Procedure

  1. Log in to the NineData Console.

  2. In the left-side navigation pane, choose Datasource > Datasource.

  3. On the Datasource tab, click Create Datasource. In the data source type dialog box, choose Self-Managed Database > Relational Database > GoldenDB, and then configure the parameters on the Create Datasource page using the table.

    tip

    If you select the wrong type, click the arrow_down icon at the top of the Create Datasource page to reselect the data source type.

  4. Configure the data source parameters:

    Parameter
    Description
    NameEnter a data source name.
    ConnectionSelect the connection method. The console currently supports IP Address, Gateway, and SSH Tunnel.
    Architecture TypeSelect the GoldenDB deployment architecture. The console currently supports Single, Disaster Recovery, and Read/Write Splitting. When Disaster Recovery or Read/Write Splitting is selected, follow the page prompts to enter the corresponding node addresses and ports.
    Configuration for IP AddressHost: Enter the public address and port of the GoldenDB instance. The default port shown in the console is 3306.
    Configuration for Gateway
    • Gateway: Select an onboarded data source gateway.
    • Host: Enter the GoldenDB address and port in the gateway network. If the database is deployed on the gateway host itself, you can enter localhost.
    Configuration for SSH TunnelEnter the public address, port, authentication method, login username, and password or private key file for the tunnel host first. After the tunnel is ready, enter the target GoldenDB address and port.
    DB AccountEnter the database login username.
    DB PasswordEnter the database login password.
    Access RegionSelect the access region nearest to the database instance.
    EnvironmentSelect the environment tag for the data source, such as Production or Development.
    EncryptionSpecifies whether to enable encrypted transmission. This option is enabled by default in the console. After expanding it, you can choose Prefer or Require, and configure SSL Cipher, server certificate validation, server identity validation, and client certificates when needed.
  5. After all parameters are configured, click Connection Test on the right of Create Datasource to test connectivity. When Connection Successfully is displayed, click Create Datasource to finish creating the data source.

Result

After the connection test succeeds and you create the data source, it appears in the data source list. You can use it in NineData features that support this data source type.