Connect an ECS-based self-managed database to DAS

Access methods

You can use one of the following methods to connect the database to DAS:

• Use the username and password of the database. You use the username and password of the account that is used to access the database to connect the database to DAS. If you use this method, you do not need to deploy a DAS gateway. You must specify one or more security groups for the ECS instances on which the database nodes are deployed. This method is suitable for scenarios in which a small number of ECS instances are used to deploy database nodes.
• Use DAS gateways that are deployed on ECS instances. You must deploy at least one DAS gateway on an ECS instance on which a node of the database is deployed. We recommend that you deploy DAS gateways on two or more ECS instances for disaster recovery. DAS can detect databases based on the CIDR block of the ECS instances on which the database nodes are deployed. This method is suitable for scenarios in which the ECS instances are deployed in a virtual private cloud (VPC). If the ECS instances are deployed in the classic network, we recommend that you do not use this method.
• Use DAS gateways that are deployed on hosts of database nodes. You deploy a DAS gateway on the host of each database node. DAS gateways can automatically detect the database nodes. If a database is connected to DAS in this method, the database supports all features that are provided by DAS, such as full SQL analysis, slow query log analysis, and security audit. For more information, see Feature comparison.

Feature comparison

The following table describes the DAS features that are supported by databases that are connected to DAS by using different methods. In this example, the features that DAS provides for databases that run the MySQL database engine are listed.

Use the username and password of the database

1. Log on to the DAS console.
2. In the Recommended Features section of the Overview page, click Access Instance.
3. On the page that appears, click DB Instance on ECS.
4. Click Method 1: Direct Access.
5. Select the region where the ECS instances are deployed.
6. Find the security groups to which you want to add the ECS instances, select Private Network in the Add DAS access rules column, and then click Save.
7. Select the ECS instances on which the database nodes are deployed and click Next.
   Note You must select one or more security groups for the ECS instances.
8. Configure the parameters that are described in the following table to connect the database to DAS.

   Parameter	Description
   Select Engine	The engine that the database runs. Valid values: MySQL, PostgreSQL, MongoDB, and Redis.
   Port	The port that is used to access the database.
   Database Account	The username of the account that is used to access the database.
   Password	The password of the account that is used to access the database.

   Note

   • If an account that is granted the required permissions on the database is already created, you can enter the username and password of the account and then click Authorize.
   • If no accounts that are granted the required permissions on the database exist, you can enter a username and a password, and then click Generate Authorization Command. The system generates commands that can be used to create an account. Copy the commands and run them on the database to create the account. Then, click Authorize on this page.
9. Click Authorize. After you click Authorize, the connection result is displayed. The Accessed state indicates that the database is connected to DAS. The following states indicate that errors occurred:
   • Unauthorized: You do not have permissions to access the database that corresponds to the specified username and password.
   • Connection Failed: The database is not connected to DAS due to errors such as network connection failures or ECS instance breakdown.
   • Authentication Failed: The username or password that you specified is incorrect.
   • Insufficient Permissions: The database is connected to DAS, but the account that you use is not granted sufficient permissions. For more information, see Permissions.
10. Click Complete.

Use DAS gateways that are deployed on ECS instances

1. Log on to the DAS console.
2. In the Recommended Features section of the Overview page, click Access Instance.
3. On the page that appears, click DB Instance on ECS.
4. Click Method 2: DBGateway in Centralized Mode.
5. Select an access method:
   • If no DAS gateways are deployed in the VPC in which the ECS instances are deployed, select Deploy New DAS Gateway (DBGateway) to Scan Instances.
     1. Select the region where the ECS instances are deployed, select an ECS instance on which you want to deploy a DAS gateway, and then click Generate Deployment Command.
     2. Copy the command that DAS generates for gateway deployment and then run the command on the ECS instance on which you want to deploy a DAS gateway.

        If successful is returned in the command line window, the DAS gateway is deployed. If the DAS gateway is not deployed, you can submit a ticket to contact Alibaba Cloud Technical Support.

     3. DAS can automatically detect the deployed gateway. If the DAS gateway is in the Normal state, click Next.
   • If DAS gateways are deployed in the VPC in which the ECS instances are deployed, select Use Existing DAS Gateway (DBGateway) to Scan New Instances.
     1. On the Select DBGateway page, select the DAS gateway.
     2. Click Discover Instance.
6. In the Discover Instance step, configure the DAS gateway to scan for databases.

   1. You can configure one of the following methods for the DAS gateway to scan for databases:

      • Select Automatic Scan (Search by IP Range and Port).
        1. Enter a CIDR block in the Scanned Address field. The DAS gateway can scan for databases based on the specified CIDR block.
        2. Enter a range of ports in the Port Range field. The DAS gateway can scan for databases based on the specified port range.
        3. Click Scan.
      • Select Enter Instances.
        1. Specify the database that you want the DAS gateway to scan. The value must be in the IP address:Port number format.
        2. Click Scan.
   2. After the information of the database that you want to connect to DAS is displayed in the Scan Results section, click Next.
7. Configure the parameters that are described in the following table to connect the database to DAS.

   Parameter	Description
   Select Engine	The engine that the database runs. Valid values: MySQL, PostgreSQL, MongoDB, and Redis.
   Database Account	The username of the account that is used to access the database.
   Password	The password of the account that is used to access the database.
   IP Address	The IP address of the database.

   Note

   • If an account that is granted the required permissions on the database is already created, you can enter the username and password of the account and then click Authorize.
   • If no accounts that are granted the required permissions on the database exist, you can enter a username and a password, and then click Generate Authorization Command. The system generates commands that can be used to create an account. Copy the commands and run them on the database to create the account. Then, click Authorize on this page.
8. Click Authorize. After you click Authorize, the connection result is displayed. The Accessed state indicates that the database is connected to DAS. The following states indicate that errors occurred:
   • Unauthorized: You do not have permissions to access the database that corresponds to the specified username and password.
   • Connection Failed: The database is not connected to DAS due to errors such as network connection failures or ECS instance breakdown.
   • Authentication Failed: The username or password that you specified is incorrect.
   • Insufficient Permissions: The database is connected to DAS, but the account that you use is not granted sufficient permissions. For more information, see Permissions.
9. Click Complete.

Use DAS gateways that are deployed on hosts of database nodes

1. Log on to the DAS console.
2. In the Recommended Features section of the Overview page, click Access Instance.
3. On the page that appears, click DB Instance on ECS.
4. Click Method 3: DBGateway in Host Mode.
5. Select the region where the ECS instances are deployed, select an ECS instance on which you want to deploy a DAS gateway, and then click Generate Deployment Command.
6. Copy the command that DAS generates for gateway deployment and then run the command on the ECS instance on which you want to deploy the DAS gateway.

   If successful is returned in the command line window, the DAS gateway is deployed. If the DAS gateway is not deployed, you can submit a ticket to contact Alibaba Cloud Technical Support.

7. DAS can automatically detect the deployed gateway. If the DAS gateway is in the Normal state, click Next.
8. Configure the parameters that are described in the following table to connect the database to DAS.

   Parameter	Description
   Select Engine	The engine that the database runs. Valid values: MySQL, PostgreSQL, MongoDB, and Redis.
   Database Account	The username of the account that is used to access the database.
   Password	The password of the account that is used to access the database.
   IP Address	The IP address of the database.

   Note

   • If an account that is granted the required permissions on the database is already created, you can enter the username and password of the account and then click Authorize.
   • If no accounts that are granted the required permissions on the database exist, you can enter a username and a password, and then click Generate Authorization Command. The system generates commands that can be used to create an account. Copy the commands and run them on the database to create the account. Then, click Authorize on this page.
9. Click Authorize. After you click Authorize, the connection result is displayed. The Accessed state indicates that the database is connected to DAS. The following states indicate that errors occurred:
   • Unauthorized: You do not have permissions to access the database that corresponds to the specified username and password.
   • Connection Failed: The database is not connected to DAS due to errors such as network connection failures or ECS instance breakdown.
   • Authentication Failed: The username or password that you specified is incorrect.
   • Insufficient Permissions: The database is connected to DAS, but the account that you use is not granted sufficient permissions. For more information, see Permissions.
10. Click Complete.