Connection time out issue after selecting recommended drive option

Question

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.

Answer 1

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.