I’m looking forward to starting the development of a web application project at work in the near future. The application is to be written in Xojo with the backend based on MySQL.
I’ve been tasked with conducting detailed research with regards to the following aspects:
Robust hosting service: I need to get an affordable good hosting service and plan backups so the app can revert back to a working state at a moments notice. I mention affordable as for example I’m very familiar with using AWS which I have utilised to host a SimpleDB database but having done research with hosting a MySQL database it seems quite expensive.
Hence my first question is it affordable to host a MySQL DB on AWS?
Which important decision making parameters/factors need to be at the forefront of my thinking when comparing AWS with another hosting service with a MySQL option?
Backup options: A big risk is that if the app goes down for some reason e.g. hosting has a problem, spam influx, corrupt data a good hosting service and plan backups need to be in place so the application can reverse to a working state at a moments notice.
I’m aware I will have to design the functioning of the app such that for example whenever a user uploads a backup of their recently uploaded data is added to the last made backup but considering we anticipate to have up to 1000 users in a calendar year (based on research from our marketing department in relation to users interested in a potential web app) that might upload data then conducting backups after a user updloads data might not be too efficient (kindly corerect me if I’m wrong).
I’m aware for example I will have to write a background thread or Asynctask like program which will constantly check “all is well with the hosting service” but if the hosting service were to fail then I kindly need advice regarding backup options for a MySQL based DB.
Any advice is really appreciated.