In Data Management (DMS), you can register a self-managed database deployed in a data center by using Database Gateway. This way, you can access the database without the need to expose the database to the Internet, and data can be transmitted in an encrypted and secure manner.

Prerequisites

  • Database Gateway is activated, and a database gateway is created. For more information about how to create a database gateway, see Create a database gateway.
  • The on-premises database that you want to register with DMS is added to the database gateway. For more information, see Add databases.
  • You are a DMS administrator or a database administrator (DBA) in DMS. For more information about how to view your role, see View system roles.

Background information

Enterprises and individual users that use a hybrid cloud architecture often face the following pain points in database management:

  • If an Express Connect circuit is used to connect an on-premises database to a virtual private cloud (VPC), high costs are generated. This does not suit small-sized enterprises or individual users.
  • If the public endpoint of an on-premises database is used to register the database with DMS, the public endpoint is exposed to the Internet and the database may be attacked. This is not acceptable in a production environment.
  • Users need to forward service requests themselves. This does not ensure service stability, demands extensive technical expertise, and has poor applicability.

Procedure

  1. Log on to the DMS console V5.0.
  2. On the Home tab of the DMS console, click the add icon in the upper-right corner of the left-side instance list.
    Note Alternatively, in the top navigation bar, choose Data Assets > Instances. Click Instances in the left-side navigation pane. On the Instances page, click +New.
  3. Click the Local/other cloud database tab and select a database type.
    Note The following table describes the configuration parameters for a MySQL database. The parameters for other database types may differ. For example, if you set the database type to PostgreSQL, the DATABASE parameter appears.
  4. In the Add Instance dialog box, configure the parameters described in the following table.
    Basic Information Data Source The source of the database instance. In this example, select Local/other cloud database.
    Database Type The type of the database instance.
    Instance Region The region in which the database gateway resides.
    Gateway ID The ID of the gateway. If you have not created a database gateway, click Click here to add a database gateway to create a database gateway.
    Database address The private network address of the database.
    Database Account The account that is used to connect to the database.
    Database password The password of the account that is used to connect to the database.
    Control Mode The control mode of the database instance. For more information, see Control modes.
    Sensitive Data Protection Specifies whether to enable the sensitive data protection feature based on your business requirements. This feature allows you to control and mask sensitive data. For more information, see Overview.
    Advanced Information Environment type The type of environment in which the database is deployed.
    Instance Name The name you specify for the database instance.
    Lock-free Schema Change Specifies whether to enable the lock-free schema change feature for the database instance. For more information, see Perform lock-free DDL operations.
    Enable SSL Specifies whether to allow DMS to connect to the database instance by using SSL connections. After this feature is enabled, DMS can connect to the database instance by using SSL connections. Valid values:
    • Default (DMS automatically checks whether self-negotiation is enabled for the database instance.): DMS automatically checks whether the SSL encryption feature is enabled for the database. If the SSL encryption feature is enabled, DMS connects to the database by using SSL connections. Otherwise, DMS connects to the database without encryption.
    • Open: DMS connects to the database by using SSL connections. This value is invalid if you disable the SSL encryption feature for the database.
    • Close: DMS does not connect to the database by using SSL connections.
    Note This parameter is displayed only if the Database Type parameter is set to MySQL.
    DBA The database administrator (DBA) of the database instance. The DBA can grant permissions to users.
    query timeout(s) The timeout period for the execution of an SQL query statement. If the execution of an SQL query statement does not finish before the specified timeout period elapses, the execution is terminated to protect the database instance.
    export timeout(s) The timeout period for the execution of an SQL export statement. If the execution of an SQL export statement does not finish before the specified timeout period elapses, the execution is terminated to protect the database instance.
    Note After you set the parameters in the Basic Information section, click Test connection in the lower part of the dialog box. If the connectivity test fails, modify the parameters based on the error message and try again.
  5. Click Submit.
    After the preceding steps are complete, the third-party database is registered with DMS. Then, you can view and manage your database instance in the instance list in the DMS console.