GaDaddy is a famous web hosting platform where many people put their websites on its platform. If one has low budget and wanna a shared hosting, you can buy the service at GoDaddy and share some hosting resource with others. In such cases, there would be resource limit based on different plans.
In this post, we will discuss one scenario which caused our application down caused by database usage on shared hosting plan and hope it helps readers who encounter similar issues.
The issue we encountered is that our privileged users associated with the database we created get removed all of a sudden and our application which accesses the database with the users cannot work anymore as they lost the access.
After noticing this, the first thing we did was to check whether there was anything wrong with our application(maybe hacked). But after deep diving, we didn't find anything related to that. Thereafter we tried to add the users back and it started to work and we thought the issue was resolved.
Unfortunately after a few hours we found that the application didn't work again and the users got removed again. Now we are not sure what is wrong and we reached out to GoDaddy support and the help we got was not helpful to be honest, they just told us to do some routine check and didn't really understand our concern(maybe we are not important customer so not deserving it). Meanwhile we added the users back again but unfortunately the issue occurred again after a few hours and it was disrupting our service which was really frustrating.
We reached out to the customer support again but still not able to find out until in the end they said it should be caused by the over usage of the quote for the database after we insisted on further checking, then we realized the database usage now is 9.6 GB which is much higher than the allocated quote(1 GB for each database) for shared hosting.
What GoDaddy would do is they would send an email to the site owner and remove the associated users to prevent further data increase of the database. But in our case, we didn't receive any notice email about this and the users just got removed automatically. To be honest, this kind of service is problematic, you could notify the owner and at least give some notice period to the site owner to take proper action instead of just removing the users suddenly.
Since knowing what's going on, we tried to delete some data from database which we thought could be deleted and then optimized the database and the usage went down below 1 GB and added back the users and it started to work since then.
Hope some GoDaddy users who encounter similar issues can learn a lesson here and try above checks.
