2 sites, 1 sql...

just thinking,

if we had 2 server, both with Dolphin installs.

1 acts as 'back end', 2 acts as 'front end'

SQL is hosted on 2, 

1 share same SQL

then, modify 2 so that media uploading points to server 1

if this could be done, then we would have a 'beefed up' dolphin install with things like videos, being uploaded to sql server which handles the processing, but video can be viewed on the front end server which would just server up the template and browsing experience.

make sense?

any reason why this wouldn't work? 

I tried running two dolphin sites off of one DB before (long time ago). Please keep in mind following points:

1. Both sites would be identical in regards to what is pulled from the database
2. Any coding which refers to a specific domain would need to be manually over written
3. Any custom php pages would need to be manually created on one site and manually duplicated on other site.
4. Videos, photos, sounds, and files require a lot of manual work - but is possible using symbolic links.

In case you are unfamiliar with them, symbolic links are just shortcuts to other files, but it seems as if it is the actual file. Be careful though. If a person uploads a video (for example) on site one, you will need to create the symbolic link on site two. If something is uploaded on site two you have to create a symbolic link on site one. Depending on how you are handling uploads (in my project, only I was uploading videos, so it was not that bad), it could be more work than you really want to go through.

hope it does.... Let us know how you get on

The objective is to separate video hosting, and video processing onto a separate server to the sites front end.

 Then you only need to run ffmpeg on the other server and is there no need to have two dolphin sites.

For example, change the cron job to, instead of processing the video, to notify the other server that a video needs processing. That server can than do the processing and update the database for your dolphin site.

Of course the 2nd server will need (modify) access  to where the videos are stored and the DB.