Amazon RDS
DB update appear to be stuck in the modifying state when attempting to increase allocated storage.
Last week, bulk import following a content migration effort from Sharepoint to alfresco landed us in filling up of Alfresco DB metadata table aggressively and left us with no option but increase the allocated story for our MySQL DB.
This caused an enormous amount of delay in updating RDS DB instance update to increase an allocated storage of 200GB to 2000 from 30 mins to 1.35 hours. It is advisable to have this planned for off hours to have lower business impacts.
Options leveraged :
1. AWS Console
2. CLI command:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.MySQL.html
3. Bamboo Deployment