Scaling Mysql CLuster stuck updating

Question

After apply a recommendation of advisor my sql cluster stay updating, its appear to be an issue with Azure, but i dont want to pay support for an issue on azure platform

Answer 1

If a MySQL cluster is stuck updating, it could be caused by a number of issues. Here are a few possible causes and potential solutions:

1. Insufficient resources: If the cluster is running out of memory or CPU, it may not be able to perform updates efficiently. Try adding more resources to the cluster, such as more memory or CPU.
2. Network congestion: If the network connection between the cluster nodes is overloaded, it may cause delays in updates. Try optimizing the network by increasing bandwidth or reducing the number of connections.
3. Incompatible configurations: If the cluster nodes have different configurations, it can cause issues with updates. Make sure that all nodes have the same configuration settings.
4. Inconsistent data: If the data in the cluster is inconsistent, it can cause issues when updating. Try to identify and fix the inconsistencies.
5. Corrupted data: If the data on a cluster is corrupted it can cause stuck updates. Try to identify the corrupted data and restore it.
6. Locks: If a particular table is locked it can cause stuck updates. You could try to identify the table and release it manually.
7. Deadlocks: If a deadlock is present it can cause stuck updates. You could try to identify the deadlock and release it manually.

It is recommended to take a look at the logs and identify the root cause of the issue and then take the appropriate action. If you are not able to identify the root cause.