MySQL Flexible server has bad ping

Question

So, since upon a three days MySQL Flexible Server has a pure ping, like this listing show:

And sometimes I got timeout connection for all requests.
Does somebody has the same problem and what is the resolution?

Answer 1

Hi Андрей Чефонов •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are getting connection timeouts in Azure Database for MySQL Flexible Server.

Could you please check below pointers and let us know the result:

• Refer to encrypted connectivity using Transport Layer Security (TLS 1.2) in Azure Database for MySQL - Flexible Server --> to learn more about encrypted connections.
• If you are using Public access (allowed IP addresses), then set up firewall rules to allow the client IP address. For temporary testing purposes only, set up a firewall rule using 0.0.0.0 as the starting IP address and using 255.255.255.255 as the ending IP address. This will open the server to all IP addresses. If this resolves your connectivity issue, remove this rule and create a firewall rule for an appropriately limited IP address or address range.
• On all firewalls between the client and the internet, make sure that port 3306 is open for outbound connections.
• Verify your connection string and other connection settings. Refer to the pre-defined connection strings in the Connection Strings page available for your server in the Azure portal for common languages.

Reference document link: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues

Hope this helps. If not, please let us know so that we can further investigate.

Thank you.

Answer 2

Hi Андрей,

When I look at your issue, It looks like you're experiencing intermittent connectivity issues with your MySQL Flexible Server, where sometimes you get a response, and other times you encounter timeout errors. This could be due to various reasons, and troubleshooting such issues can involve several steps. Here are some common reasons and potential solutions to consider:

1. Network Issues:

• Check if there are any network connectivity problems between the client and the server. It's possible that there could be intermittent network disruptions causing the timeouts.
• Check if there are any firewalls, security groups, or network policies that might be blocking the connection attempts intermittently.

Server Load and Resource Issues:

• High server load or insufficient resources (CPU, memory) on the server could lead to slow responses or timeouts. Monitor the server's resource utilization during peak times to ensure it's not overwhelmed.

Query Optimization:

• If the server is experiencing high load due to complex or poorly optimized queries, it might lead to slow responses or timeouts. Make sure your queries are well-optimized and indexes are used appropriately.

Connection Pooling:

• If you're using connection pooling, ensure that connections are being managed effectively. Connection leaks can cause issues over time.

Server Logs:

• Check the MySQL error logs for any error messages or warnings that might shed light on the issue. These logs can provide valuable insights into what's going wrong.

Latency:

• If the MySQL Flexible Server is located in a different geographical region from the client, latency could contribute to intermittent timeouts. Consider using a MySQL server that's physically closer to the client location.

MySQL Server Configuration:

• Review the MySQL server configuration to ensure it's optimized for your workload. You might need to adjust settings related to connection limits, timeouts, and other relevant parameters.

Upgrade and Patches:

• Ensure that both the client and server MySQL versions are up to date with the latest patches. Sometimes, known bugs causing connectivity issues can be fixed in newer releases.

Network Stability:

• Verify the stability of the network itself. Ensure that there are no frequent drops in the connection due to network hardware issues.

Third-Party Services:

• If you're using any third-party services or applications in conjunction with MySQL, they might be causing connectivity disruptions. Ensure that they are functioning correctly.

1. Load Balancing:
   • If you're using a load balancer in front of your MySQL server, make sure it's configured properly and not causing any connection issues.

Since the issue seems intermittent, it might require some careful observation and testing to pinpoint the exact cause. Just be aware to make changes cautiously and document everything you try, so you can roll back changes if necessary.

I hope this helps?