[racktables-users] Re: Uploaded files just 1 MB after download

Denis Ovsienko wrote:

[...]


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?).
Is there any way to glue this together with something like rancid that will pull your router/switch config files and commit to cvs or subversion? OpenNMS has a patch that gives rancid a web interface to help with the integration: http://www.opennms.org/index.php/RANCID_RWS and it would be nice to have matching links from the view of the device in racktables. 

--
  Les Mikesell
   lesmikesell@xxxxxxxxx

Other related posts: