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

Adding a Self-Built Database

Add self-built database assets.

Prerequisites

  • DSC has been allowed to access the database assets. For details, see Allowing or Disallowing Access to Cloud Assets.
  • The self-built database engine, version, and database server address have been obtained. There are available IP addresses in the corresponding subnet.

Constraints

Database types and versions supported by DSC can be added. For details, see Table 1.

Table 1 Supported database types and versions

Database Type

Version

MySQL

5.6, 5.7, 5.8, and 8.0

SQL Server

  • 2017_SE, 2017_EE, and 2017_WEB
  • 2016_SE, 2016_EE, and 2016_WEB
  • 2014_SE and 2014_EE
  • 2012_SE, 2012_EE, and 2012_WEB
  • 2008_R2_EE and 2008_R2_WEB

PostGreSQL

11, 10, 9.6, 9.5, 9.4, and 9.1

Oracle

10 and 12

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select a region or project.
  3. In the navigation pane on the left, click and choose Security > Data Security Center.
  4. In the navigation pane, choose Assets and select the Database tab and then the Unauthorized tab.

    Figure 1 Unauthorized database assets

  5. In the upper left corner of unauthorized database assets, click Add Self-Built Database.
  6. In the displayed dialog box, set database parameters. For details, see Table 2.

    Figure 2 Adding a self-built database
    Table 2 Parameters for adding a self-built database

    Parameter

    Description

    Example Value

    Asset

    Database name

    N/A

    Region

    Region where the account is used for login

    N/A

    ECS

    Select an ECS instance created in ECS from the drop-down list.

    N/A

    Security Group

    Name of the security group to which the ECS instance belongs

    default

    Database Engine

    Database engine

    Value options: MySQL, PostgreSQL, SQLServer, and Oracle

    MySQL

    Version

    Version number corresponding to the database engine

    5.6

    Database Server Address

    IP address of the database server

    N/A

    Port

    Port number of the database server

    N/A

    Database

    Self-built database name

    N/A

    Username

    Username for logging in to the database server

    N/A

    Password

    Password for logging in to the database server

    N/A

  7. Click OK.

    Figure 3 Connectivity test
    DSC will check the connectivity of the added database, and the connectivity status of the added database is Checking.
    • If DSC can access the added database, the connectivity status is Succeeded.
    • If the DSC cannot access the added database, the connectivity status Failed. Click Cause to view the failure cause.