Skip to main content

Create a GoldenDB Data Source

Add a GoldenDB data source to NineData for Database DevOps, backup and restore, data replication, database comparison, and other supported features. This guide covers connection mode, architecture type, endpoint settings, encrypted transmission, environment settings, and the connection test.

Before you begin

  • 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 check your remaining quota in the NineData Console header.check_quota

Procedure

  1. Sign in to the NineData Console.

  2. Go to Datasource > Datasource.

  3. Click the Datasource tab, and then click Create Datasource. In the data source type dialog, choose Self-Managed Database > Relational Database > GoldenDB. On the Create Datasource page, configure the parameters 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. Use a meaningful name to find and manage it later.
    ConnectionSelect how NineData connects to the data source. The console 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, 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.
    EncryptionChoose whether to enable encrypted transmission. This option is enabled by default in the console. After expanding it, choose Prefer or Require, and configure SSL Cipher, server certificate validation, server identity validation, and client certificates when needed.
  5. After you configure all parameters, click Connection Test next to Create Datasource to test connectivity. When Connection Successfully is displayed, click Create Datasource to create the data source. Otherwise, review the connection settings and run the test again.

Result

After the connection test succeeds and the data source is created, it appears in the data source list and is available to NineData features that support GoldenDB.