I host it on Dreamhost. No root access, flat file system for the photos, MySQL provided by Dreamhost.
There are some known issues, but this will definitely evolve for the better. That's why I wrote the MySQL and localfs originally, thanks to jmathai clean design.
How are the photos and tags stored on the filesystem layer?