<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Brice,<br>
<br>
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.<br>
<br>
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.<br>
<br>
Bon courage,<br>
<br>
Marcus.<br>
<br>
<br>
Brice Leroy wrote:<br>
<blockquote cite="mid:B7BADBEA-804F-4160-8966-2A9AB3E67E1B@gmail.com"
type="cite">
<div>Marcus, </div>
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.
<div><br>
</div>
<div>All the best,</div>
<div><br>
</div>
<div>- Brice<br>
<div><br>
<div>
<div>On Mar 24, 2009, at 11:49 AM, Marcus Clyne wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div bgcolor="#ffffff" text="#000000"> Brice,<br>
<br>
If you haven't done so already, have a look at Primebase Media
Streaming (<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="http://www.blobstreaming.org">www.blobstreaming.org</a>).<br>
<br>
It's a MySQL plugin that has a lightweight HTTP server on the front of
it to serve blobs out of a database.<br>
<br>
I've done some tests on it (up to 2M objects), and the speed was
comparable in many cases to serving content statically.<br>
<br>
As part of the system, it allows you to provide an alias for your
blobs, so as to hide any database information.<br>
<br>
Cheers,<br>
<br>
Marcus.<br>
<br>
<br>
Jean-Philippe Moal wrote:
<blockquote cite="mid:49C9287F.40700@skateinmars.net" type="cite">
<pre wrap="">Brice Leroy a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Hello,
I'm interrested in NGINX to serve static files according to his
performance :p. But I will have to serve big static file (video content
in hd) and to protect the access I would like to use a dynamic url with
a key inside like:
- <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://static/qwertyuiopasdfghjkl">http://static/qwertyuiopasdfghjkl</a> which will return the content of
file.mov where the key(qwertyuiopasdfghjkl) is associated with the file
in the DB. The user received the content not the file.
So a user can share an URL with his contact and stop sharing it when he
want (by removing the record in the DB). I will have to serve thousand
of files at the same time and I want to minimize my server farm. Do you
have any idea ?
Thank you :)
</pre>
</blockquote>
<pre wrap=""><!---->You can use X-Accel-Redirect: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.nginx.org/NginxXSendfile">http://wiki.nginx.org/NginxXSendfile</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>