Register a database instance in a third-party cloud by using a database gateway -

Data Management Service (DMS) allows you to register a database instance in a third-party cloud by using a database gateway. When you register the database instance, no public endpoints are required and the database instance can be connected by using SSL connections.

Prerequisites

Database Gateway is activated and a data gateway is created. For more information, see Create a database gateway.
Note
When you create a database gateway, download the gateway program to the server on which the database instance is to be connected through the third-party internal network.
The database instance is added to the created gateway. For more information, see Add databases.
DMS is activated. For more information, see https://dms.aliyun.com.
You are a DMS administrator or a database administrator (DBA) in DMS.

Background information

Enterprises and individual users who use a hybrid cloud may face the following challenges in database management:

If an Express Connect circuit is used to connect a database instance in a third-party cloud to a virtual private cloud (VPC), high costs are generated. This method is not suitable for small enterprises and individual users.
If the public endpoint of the database instance is used for registration, the public endpoint is exposed to the Internet and the database instance may be attacked. This poses high risks if the database instance is in the production environment.
Users need to forward service requests on their own. This makes the service less secure, less applicable, and not easy to use.

Procedure

Log on to the DMS console V5.0.
On the Home page of the DMS console, click the icon in the upper-right corner of the left-side instance list.
Note
You can also choose Data Assets > Instances in the top navigation pane. On the Instance List tab of the Instances page, click New.
In the Data Source step, click Local/other cloud database and select the type of the database instance.
Note
In this example, MySQL is selected. If you select other types of database instances, the operation is similar.

In the Basic Information/Advanced Information step, set the parameters described in the following table.

Basic Information	Data Source	The source of the database instance. In this example, Local/other cloud database is selected.
	Database Type	The type of the database instance.
	Instance Region	The region in which the database gateway is deployed.
	Gateway ID	The ID of the database gateway that you created. If you have not created a database gateway, click Click here to add a database gateway. For more information, see Create a database gateway.
	Database address	The internal endpoint of the database instance.
	Database Account	The username that you use to log on to the database instance.
	Database password	The password that you use to log on to the database instance.
	Control Mode	The control mode that you use to manage the database instance in DMS. 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 environment in which the database instance is deployed.
	Instance Name	The name that you specify for the database instance.
	Open DBLink	Specifies whether to enable the database link feature for the database instance. For more information, see Query data across multiple database instances.
	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 instance. If the SSL encryption feature is enabled, DMS connects to the database instance by using SSL connections. Otherwise, DMS connects to the database instance without encryption. Open: DMS connects to the database instance by using SSL connections. This value is invalid if the SSL encryption feature is disabled for the database instance. Close: DMS does not connect to the database instance by using SSL connections. Note This parameter is available only if you set the Database Type parameter to MySQL.
	DBA	The 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 lasts longer than the specified timeout period, 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 lasts longer than the specified timeout period, 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 connection test fails, modify the parameters as prompted and try again.

Click Submit.
After the preceding steps are complete, the database instance is registered with DMS. Then, you can view and manage your database instance in the instance list in the DMS console.