The Problem: I want to host lots of digital photos from a website. More than the host has disk space.
The background: I have a vps which hosts a website, the machine has tons of bandwidth but not much disk space (50gb or so). I also have a server on a slower internet line with lots of disk space.
My solution: I was thinking, would it be feasible to store the images on the machine with the slow link, mount it onto the web host (with something like sshfs, or whatever), then create symbolic links for all the images and serve up those symbolic links from apache. Then create a script which scans the apache logs looking for the most popular X number of files, and copy those files to be local to the webserver (and therefore faster).
After a while I realised that this sounded like a late night type idea, and decided to sleep on it. This morning it's still sounding a little dodgy, but there must be some sort of apache caching module which works on disk->disk caching, right ? (all the ones i know of are disk->memory, moving important files to ram rather than moving to a local disk from a slower wan link or slower local disk).
TL;DR: Is this actually a dumb idea ?