[racktables-users] Re: Uploaded files just 1 MB after download
- From: Denis Ovsienko <pilot@xxxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Mon, 8 Jun 2009 14:49:26 +0400
[...]
> Maybe a (optional) file based solution would be the best cause you could
> separate the files from the database maybe to put them on a encrypted disk
> or somewhat.
Hello, all.
Well, Aaron considered storing files on the filesystem, when this
feature was developed. I had insisted on putting everything into
database that time, and still stick with the same opinion. The only
problem by far are "large" files, and I think, experienced MySQL users
can suggest a proper configuration for these (I personally use smaller
files). There are benefits, which pay for that inconvenience.
A single mysqldump run includes all important data. Single RackCode
setup controls normal access to all files (this isn't yet so for file
previews, TBH). Encrypted media can be used on the MySQL server and/or
SSL can be enabled for client-server connections. Once this is
done, the administrator doesn't have to remember "the other" part of
important data to protect.
There may be some "filesystem" file storage later, when all internal
bits are justified for secure and reliable implementation of such.
Until that happens we are likely to consider the size of an "essential"
file as something, that can be easily achieved with MySQL (16
megabytes?).
--
Denis Ovsienko
Other related posts: