Share via

Azure MySQL Flexible stop responding after resizing.

Amjad Nagori 296 Reputation points
2022-08-04T05:41:31.987+00:00

We have deployed our database into Azure MySQL Flexible Server and it was working fine. We were facing some slowness in application so thought to resize the server from D4ds to D8ds (General Purpose) and after resizing server stopped responding and we start getting below issues-

  1. Not able to connect through mysql command, getting below error- 227972-image.png
  2. Not even able to telnet host with port 3306 from VM of same network.
  3. We were able to connect using the same methods before resizing.
  4. While opening database section in portal, getting below error- 227880-image.png

Tried below troubleshooting steps but still not able to connect the server-

  1. Tried with restarting the server.
  2. Tried with stop and start.
  3. Changed size back to D4ds
  4. Tried with creating new database which is also not working and getting below error- 227944-image.png

This is what I am getting on Monitoring-

227918-image.png

Resource health showing Available-

227955-image.png

P.S. This server is configured with Virtual network and DNS integration option to keep it private.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
993 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.