|
I am working on a project where individual users sign up on a community site and are provided with there own customized web site. Through these individual web sites users will be able to add listings (complete with photos, address, other data fields). What I want to do is have the ability to publish these listings to the master site. I can't decide how I want to manage the data and photos, this is most likely going to stay on a single dedicated server. So when an image is uploaded or database created it is all local, whether I should develop this with multiple servers in mind, I'm not sure.
So on the main page, I'm not sure if I want to have batch copy that exports/imports all the data and photos from the various web site databases, and publishes them on the main page through MySQL scripts and copying files/renaming, or if I just want to reference each database separately and just reference photos by domain. Seems a littel strange to copy photos over from 10 domains to 1 domain when they are all on the same physical server.
I have been playing with a few combination of custom code and Drupal, and have even considered Amazon S3. I'm using PHP/MySQL on a dedicated Fedora server.
Does anyone know how this is usually handled?
Any help is appreciated.
|
