This document describes TDSQL-C for MySQL connection methods, their application scenarios, and troubleshooting methods.
Note:
Public network connections are susceptible to network issues. If you have high network requirements, it is recommended to use private network connections or Cloud Connect Network (CCN) connections.
Connection Methods
|
| Without Cloud Virtual Machine (CVM), directly log in through the TDSQL-C for MySQL console to the Database Management Center (DMC) console for database management. For specific scenario descriptions, refer to Scenario 1. | Free of charge currently. | |
| The CVM is Linux CVM that can be connected using a private or public network address. For specific scenario descriptions, refer to Scenario 2. | Free of charge currently. | |
| The CVM is Windows CVM that can be connected using a private or public network address. For specific scenario descriptions, refer to Scenario 3. | Free of charge currently. | |
| CVM and TDSQL-C for MySQL are in different Virtual Private Cloud (VPC) networks, or Lighthouse is used to connect to TDSQL-C for MySQL. For specific scenario descriptions, refer to Scenario 4. | | |
Application Scenario Description
Scenario 1: Using the DMC to Connect to a Cluster
Without CVM, log in to the TDSQL-C for MySQL console using your Tencent Cloud account, find the target cluster, and click Log In on the cluster management page. Then, you are redirected to the DMC console for database management. DMC can provide a variety of services, including database/table-level operations, real-time monitoring, instance session management, SQL window, and data management. Scenario 2: Connecting to a Cluster via a Private or Public Network Address from Linux CVM
Private network connections
The CVM is Linux CVM that is under the same Tencent Cloud root account as TDSQL-C for MySQL. Both CVM and TDSQL-C for MySQL are in the same region, use the VPC network type, and are within the same VPC.
For example:
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL is in subnet B in VPC 1 in Guangzhou.
Public network connections
The CVM is Linux CVM. In scenarios where private network connections are not available, you can connect via the public network if TDSQL-C for MySQL has enabled public network access. For example:
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL with public network access enabled is in Guangzhou.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL with public network access enabled is in Beijing.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and under account 2, TDSQL-C for MySQL with public network access enabled is in Beijing.
Scenario 3: Connecting to a Cluster via a Private or Public Network Address from Windows CVM
Private network connections
The CVM is Windows CVM that is under the same Tencent Cloud root account as TDSQL-C for MySQL. Both CVM and TDSQL-C for MySQL are in the same region, use the VPC network type, and are within the same VPC.
For example:
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL is in subnet B in VPC 1 in Guangzhou.
Public network connections
The CVM is Windows CVM. In scenarios where private network connections are not available, you can connect via the public network if TDSQL-C for MySQL has enabled public network access. For example:
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL with public network access enabled is in Guangzhou.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL with public network access enabled is in Beijing.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and under account 2, TDSQL-C for MySQL with public network access enabled is in Beijing.
Scenario 4: Connecting Through CCN
1. CVM and TDSQL-C for MySQL are in different VPCs (including the same account/different accounts and the same region/different regions).
2. Under the same Tencent Cloud account, if you have purchased Lighthouse and want to connect to TDSQL-C for MySQL, you need to connect through CCN. For example:
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL is in subnet B in VPC 2 in Guangzhou.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL is in subnet B in VPC 2 in Beijing.
Under account 1, CVM is in subnet A in VPC 1 in Guangzhou, and under account 2, TDSQL-C for MySQL is in subnet B in VPC 2 in Beijing.
Under account 1, Lighthouse is in subnet A in VPC 1 in Guangzhou, and TDSQL-C for MySQL is in subnet B in VPC 2 in Guangzhou.
Connection Troubleshooting