MySQL in App: The server is not responding

Question

I have an Application hosted in a Windows WebApp with MySQL in APP enabled.
After realize the aplication wasn't responding I could see in the logs errors about MySQL not responding.

So when I try to access the PHPMyAdmin from the console (clicking in the manage button) I got this error:

I already tried to restart my application, and also stop/start but nothing works.
What can I do to solve this?

Answer 1

@Jean Carlos de Almeida ,

Just to clarify, were there any changes made prior to this issue? What App Service Plan (ASP) are you leveraging?

As quick steps to isolate the issue:

1. You may try to scale out to more instances to handle the socket load.
2. You may try to scale up to a higher ASP tier
3. If the Always On setting is off, please enable it from Azure Portal – Your WebApp > Configuration blade (> General settings).

To fetch more details about the issue, you may try these:

4.You may leverage App Service diagnostics from Azure Portal> Navigate to your App Service app in the Azure Portal. (screenshot below)

-- In the left navigation, click on Diagnose and solve problems - Review - “Configuration and Management and “Availability and Performance” options.

5.Navigate through Kudu site on: https://<sitename>.scm.azurewebsites.net/api/logs/ and review the log files + MySQL logs from D:\home\LogFiles\mysql folder