Brice,

PBMS was written exactly for the purpose you describe - serving blobs.
The blobs can be anything, text, images, video. If you are streaming
content, then that's different. If you are serving them statically,
then it may well be suitable, though inserting files that big, though,
might have its own difficulties.

Note : the HTTP server does not use MySQL for serving them (i.e. it
doesn't go through MySQL - this would be very slow). The HTTP server
accesses the data directly (Primebase have written their own storage
engine for MySQL, but it can use other storage engines too). It's a
plugin for MySQL to make it easy to add/delete the blobs, but this is
only at the insertion/updating/deletion stage. Using the Alias settings
for it, you wouldn't even need another web server.

Bon courage,

Marcus.


Brice Leroy wrote:
> Marcus,
> Thank you for you advice but I think this solution will not work for
> me. As I wrote on my previous email, I'm going to serve HD video
> content which is going to be more than 1GB.
>
> All the best,
>
> - Brice
>
> On Mar 24, 2009, at 11:49 AM, Marcus Clyne wrote:
>
>> Brice,
>>
>> If you haven't done so already, have a look at Primebase Media
>> Streaming (www.blobstreaming.org).
>>
>> It's a MySQL plugin that has a lightweight HTTP server on the front
>> of it to serve blobs out of a database.
>>
>> I've done some tests on it (up to 2M objects), and the speed was
>> comparable in many cases to serving content statically.
>>
>> As part of the system, it allows you to provide an alias for your
>> blobs, so as to hide any database information.
>>
>> Cheers,
>>
>> Marcus.
>>
>>
>> Jean-Philippe Moal wrote:
>>> Brice Leroy a