我应该为图像，视频和数据使用多个数据库吗？ [英] Should I use Multiple databases for images, videos and data?

问题描述

我正在开发一个大项目，我们将有三个小组，即（1）网站注册用户小组（2）注册小组网站的客户和（3）管理面板。



除了面板我们有一个庞大的潜在客户的数据库，成千上万的图像和视频是通过外面维持。所以我的问题是，我应该为每个面板使用一个单独的数据库，并将它们连接到整个网站，还是只为一个数据库连接所有内容？



或者我应该使用DB1用于流式传输视频的DB2和用于客户端数据的DB3等。这样做的原因是我认为这样我可以分别管理不同数据库中的数据，图像和视频，并且可以控制数据库大小，在我的情况下，每个数据库的数据限制为250 MB。第二种选择，我应该使用分布式数据库系统。



plz。建议。

Hi,

I am developing a big project where we will have Three panels i.e. (1) Panel for Registered Users of the website (2) Panel for Registered clients of the website and (3)Admin Panel.

Apart from the panels we have a bulky potential client''s database,thousands of images and videos which are to be maintained through out. So my question is that should I use a separate DB for each panel and inter connect them for the whole website or just one DB for everything?

Or Should I use DB1 for images DB2 for streaming videos and DB3 for client''s data and so on. The reason for doing this is that I think that way I can manage data, images and videos in a different DBs respectively and which will keep DB size under control which is limited to 250 MB for each database in my case. Second alternative, should I use a distributed database system.

plz. suggest.

推荐答案

首先，你想说你只想保护客户的图像和视频吗？你不关心其他事情吗？其次，如果您仅对选定项目应用安全措施，为什么不将其他数据保存在安全边界？它不会造成任何伤害。第三，在多个数据库上分发数据，然后从不同来源查询单个用户的多个数据库，显然会降低性能。休息是你的愿望。

First, do you want to say that you want to secure only client''s images and videos? You are not concerned about any other things? Second, if you are applying security measures for only selected items, why not to keep other data in the secured boundary as well? It will not cause any harm. Third, distributing data over several databases and then querying multiple databases for a single user from different sources will obviously cost you performance. Rest is your wish.

这篇关于我应该为图像，视频和数据使用多个数据库吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！