Hi I was wondering the best way to setup my current application. Here is the general rundown.
I have a phone application that uploads and downloads photos from a vps that will store the files statically on it.
The phone application does a webrequest to a script which queries a local database for a photo filepath which then gets returned which then after the phone makes another request back to the same server for photo.
This server is also used to house the website.
I was wondering what is the best way of splitting off the functionality. From what I understand I should get another server which just houses the database and have scripts on the vps which query the database server. Should I store the photos on the database server as well or should that be on the server that houses the database?
Also would I be needing a ec2 server or would a general vps like thrust work for something like this?