What Version and Parameters Should I Select?
Currently, you cannot connect to DDM using JDBC driver 5.1.46.
JDBC driver download address: https://dev.mysql.com/doc/index-connectors.html
Table 1 describes the recommended parameters for the JDBC URL.
Parameter |
Description |
Recommended Value |
---|---|---|
ip:port |
Indicates the connection address and port number for connecting to the DDM instance. |
Query the connection address on the DDM instance details page. |
db_name |
Indicates the name of a schema. |
Query the schema name on the Schemas page of the DDM instance details page. |
loadBalanceAutoCommitStatementThreshold |
Indicates the number of statements executed before a reconnection.
When automatic submission is disabled (autocommit is set to false), the system waits for the transaction to complete and then determines whether to initiate a reconnection. |
5 |
loadBalanceHostRemovalGracePeriod |
Sets the grace period for removing a host from the load balancing connection. |
15000 |
loadBalanceBlacklistTimeout |
Sets the time for retaining a service in the global blacklist. |
60000 |
loadBalancePingTimeout |
Indicates the time (unit: ms) for waiting for the ping response of each load balancing connection. |
5000 |
retriesAllDown |
Indicates the maximum number of polling retries when all connection addresses fail. If the threshold for retries has been reached but no valid address can be obtained, "SQLException" will be displayed. |
10 |
connectTimeout |
Specifies the timeout interval for establishing a socket connection with a database server. Unit: ms. A value of 0 indicates that connection establishment never times out. This parameter setting is used for JDK 1.4 or later versions. |
10000 |
socketTimeout |
Specifies the timeout interval for a socket operation (read and write). Unit: ms. A value of 0 indicates that a socket operation never times out. |
Set this parameter based on your service requirements. |
DDM Usage FAQs
- How Does DDM Perform Sharding?
- What Do I Do If I Fail to Connect to a DDM Instance Using the JDBC Driver?
- What Version and Parameters Should I Select?
- Why It Takes So Long Time to Export Data from MySQL Using mysqldump?
- What Do I Do If a Duplicate Primary Key Error Occurs When Data Is Imported into DDM?
- What Should I Do If an Error Message Is Returned When I Specify an Auto-Increment Primary Key During Migration?
- What Do I Do If an Error Is Reported When Parameter Configuration Does Not Time Out?
- Which Should I Delete First, a Schema or its Associated RDS Instances?
- Can I Manually Delete Databases and Accounts Remained in Data Nodes After a Schema Is Deleted?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore