Solved

Where to store multimedia files for a website

Posted on 2007-04-11
5
247 Views
Last Modified: 2010-04-07
I would like learn the most efficient way to store images and videos for a website. Does YouTube store videos under a database? Is it a good idea to store multimedia under database?

Thank you.
0
Comment
Question by:deespky
  • 2
  • 2
5 Comments
 
LVL 3

Assisted Solution

by:biffduncan
biffduncan earned 100 total points
ID: 18890749
This is a fairly religious question. There are plenty of knowledgeable people with good arguments on both sides of the "store binary large objects (BLOBs) in the filesystem versus database" debate.

The short answer is that storing the multimedia objects (images and videos) in the filesystem with only metadata in the database will generally better performance, while storing the objects directly in the database will generally yield a simpler design with easier data management but lower performance.  You might also have an easier time distributing and mirroring the multimedia to other content servers if you keep it in the filesystem.  However, how things turn out greatly depends on the overall design.
0
 

Author Comment

by:deespky
ID: 18891578
Hi,
If I were to keep on the filesystem then I guess I must have some sort of mechanism to backup these files. Instead of taking a whole backup, I should somehow differentiate what's added or deleted on a given day so that I can make a daily backup.  Am I wrong? And also how do you exactly mirror the filesystem to the other content servers?

Thank you very much
0
 
LVL 1

Expert Comment

by:SunKnight0
ID: 18892983
What mind of access (and bandwidth) do you have from your primary server to the other content servers? You can use an FTP script if all you have is FTP access.

As for backup, there are many software solutions but if you are just backing up to another hard drive (external/removable) a simple xcopy /d will only copy newer or edited files. It still does not help with the deleted files. If it is important to remove deleted files from the backup media, a daily incremental backup and a weekly full backup (after delete) would give you a decent solution.
0
 

Author Comment

by:deespky
ID: 18893565
Are there any products to ease this backup? Or should i self try to write a program which backups incrementally? I prefer not write code for this.
0
 
LVL 1

Accepted Solution

by:
SunKnight0 earned 150 total points
ID: 18894025
It depends on what backup method you are using. If you are backing up to any meia accessible through a drive letter or a UNC path, there is no need for a program. Just a text file with a .bat extension and a single xcopy command, that you then add to your scheduled tasks. One more file if you want to delete and restart the backup weekly. But that will not work if you wan tto back up to a CD/DVD or a tape drive. If you are backing up from what Windows can see as one drive/folder to another and you can give me the exact paths of both source and destination folders, I can give you the exact xcopy command to use.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

"I want to put my photos online, but I don't want them stolen.  What settings should I use?" When You Put Photos Online First and foremost, any digital file published on the WWW can be copied, stored, modified, retransmitted, etc.  Remember Naps…
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
The goal of the tutorial is to teach the user how to edit a basic portrait of someone. This tutorial shows how to edit two basic photographs, one of a car and one of a person.
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now