什么是在数据库上存储媒体文件的最佳方式？ [英] What is the best way to store media files on a database?

问题描述

我想在数据库中存储大量的声音文件，但我不知道这是否是一个好的做法。我想知道这样做的优点和缺点。

I want to store a large number of sound files in a database, but I don't know if it is a good practice. I would like to know the pros and cons of doing it in this way.

我也考虑过可能有链接这些文件，但也许这将携带更多的问题比解决方案。欢迎任何这方面的经验：）

I also thought on the possibility to have "links" to those files, but maybe this will carry more problems than solutions. Any experience in this direction will be welcome :)

注意：数据库将是MySQL。

Note: The database will be MySQL.

推荐答案

我知道存储大量大文件的每个系统都将它们外部存储到数据库。将文件的所有可查询数据（标题，艺术家，长度等）存储在数据库中，以及文件的部分路径。当需要检索文件时，您需要解压缩文件的路径，然后将一些文件根（或URL）添加到其中，然后返回。

Every system I know of that stores large numbers of big files stores them externally to the database. You store all of the queryable data for the file (title, artist, length, etc) in the database, along with a partial path to the file. When it's time to retrieve the file, you extract the file's path, prepend some file root (or URL) to it, and return that.

一个位置列，其中包含部分路径，例如a / b / c / 1000，然后映射到：
http：//myserver/files/a/b/c/1000.mp3

So, you'd have a "location" column, with a partial path in it, like "a/b/c/1000", which you then map to: "http://myserver/files/a/b/c/1000.mp3"

确保您有一个简单的方法将媒体数据库指向不同的服务器/目录，以防您需要进行数据恢复。此外，您可能需要一个例程，将数据库与文件归档的内容重新同步。

Make sure that you have an easy way to point the media database at a different server/directory, in case you need that for data recovery. Also, you might need a routine that re-syncs the database with the contents of the file archive.

此外，如果您将有成千上万的媒体文件，不要将它们全部存储在一个巨大的目录 - 这是一些文件系统的性能瓶颈。相反，将它们分成多个平衡的子树。

Also, if you're going to have thousands of media files, don't store them all in one giant directory - that's a performance bottleneck on some file systems. Instead,break them up into multiple balanced sub-trees.

这篇关于什么是在数据库上存储媒体文件的最佳方式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！