How do you manage a large video database?

Question

I have tried giving some id and just storing its title, path and the rest in a MySQL database. But This looks simple. Is there any robust way out there to do that. Thanks

"KISS = Keep it simple stupid!" That is the best way to go with — medina, Jul 31 '13 at 13:46

score 1 · Accepted Answer · edited May 23 '17 at 10:31

1

I'm not sure this is what you are looking for. But...

basically there is two way to deal with "binary large objects".

The first one is to store them is a so called BLOB column in your DB.
The second one, is, as you do it now, to store in the DB only "pointers" to the actual data on an external storage solution. Usually as "path" referencing files on your file-system..

Both solutions have pro and cons. Regarding performances, data migration, load balancing, and so on. This has already been discussed elsewhere on SO:

edited May 23 '17 at 10:31

Community

1
1

answered Jul 31 '13 at 13:58

Sylvain Leroux

50,096
7
103
125

thanks that was helpful. But you happen to know what big sites like youtube use? – Jos Jul 31 '13 at 14:04
Probably distributed key-value store – Sylvain Leroux Jul 31 '13 at 14:04
... well in fact not necessary (?) http://highscalability.com/youtube-architecture If I read well "BigTable" is used only for thumbnails. Video seems to be static files served by lighttpd. – Sylvain Leroux Jul 31 '13 at 14:08

How do you manage a large video database?

1 Answers1