Connection time out issue after selecting recommended drive option

Sharad Gawade 20 Reputation points
2024-08-27T09:48:32.7766667+00:00

Hi Team,

Currently I can see below notification in Azure data factory portal.

Your pipeline is currently utilizing legacy drivers. To avoid any unexpected behavior, please migrate to the latest driver version at your earliest convenience. Click

I have opened one of the impacted link services and there I can see two options for Driver Version

  1. Recommended
  2. Legacy after selection Recommended option and performing test connection getting below error but it's working with Legacy driver. Error: Failed to connect to the mysql source, errorMsg: Connect Timeout expired.. Connect Timeout expired. Couldn't connect to server Expected to read 4 header bytes but only received 0. Please let me know the if you have any solution on this.
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
812 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,566 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Smaran Thoomu 14,870 Reputation points Microsoft Vendor
    2024-08-27T15:10:36.1966667+00:00

    Hi @Sharad Gawade
    Thanks for the question and using MS Q&A platform.
    The notification you're seeing is a reminder to upgrade to the latest driver version to avoid potential issues. The legacy drivers will eventually be deprecated, so it's a good idea to migrate to the recommended driver version.

    As you mentioned that the legacy driver version is working fine, but the recommended driver version is not, suggests that there might be some compatibility issues or differences in the way the drivers handle the connection.

    Here are some potential reasons why the legacy driver version might be working, but the recommended driver version is not:

    1. Driver version compatibility: The legacy driver version might be using an older version of the MySQL connector that is compatible with your MySQL server version. The recommended driver version might be using a newer version of the connector that is not compatible with your MySQL server version.
    2. Connection protocol differences: The legacy driver version might be using an older connection protocol (e.g., MySQL protocol 3.23) that is still supported by your MySQL server. The recommended driver version might be using a newer connection protocol (e.g., MySQL protocol 4.1) that is not supported by your MySQL server.
    3. SSL/TLS encryption differences: The legacy driver version might be using a different SSL/TLS encryption configuration that is compatible with your MySQL server. The recommended driver version might be using a different SSL/TLS encryption configuration that is not compatible with your MySQL server.
    4. Authentication mechanism differences: The legacy driver version might be using an older authentication mechanism (e.g., MySQL native password authentication) that is still supported by your MySQL server. The recommended driver version might be using a newer authentication mechanism (e.g., MySQL caching_sha2_password authentication) that is not supported by your MySQL server.

    For more information: Copy data from MySQL using Azure Data Factory or Synapse Analytics

    I hope this helps! Let me know if you have any further questions.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.