Bug 980658 - As a sysadmin I want uploaded files to be stored outside the database so that database performance is not negatively impacted
As a sysadmin I want uploaded files to be stored outside the database so that...
Status: CLOSED CURRENTRELEASE
Product: Zanata
Classification: Community
Component: Component-Persistence (Show other bugs)
3.0
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: David Mason
Damian Jansen
:
Depends On:
Blocks: 901401
  Show dependency treegraph
 
Reported: 2013-07-02 20:50 EDT by David Mason
Modified: 2013-11-26 22:31 EST (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2013-11-26 22:31:38 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description David Mason 2013-07-02 20:50:10 EDT
Description of problem:
Zanata currently stores uploaded files (for any type except .po, .pot, .properties, .xliff) in the main database as blobs. This bloats the database and can affect performance and greatly increase backup time. The file system or a separate document-based database would be more appropriate document file storage locations.

Actual results:
Uploaded plain-text, LibreOffice and InDesign documents are stored in the main Zanata database.

Expected results:
Uploaded plain-text, LibreOffice and InDesign documents are stored on the file system.
Comment 1 David Mason 2013-07-26 01:55:52 EDT
Moved storage for raw documents to file system in configured location.

For config, see https://github.com/zanata/zanata-server/wiki/3.1-Database-Update

Note: for multiple-part uploads, parts are still stored in the database and are removed when the upload is complete. This should be migrated to the file system separately.
Comment 2 David Mason 2013-08-06 19:12:29 EDT
(In reply to David Mason from comment #1)
> For config, see
> https://github.com/zanata/zanata-server/wiki/3.1-Database-Update

This page is obsolete. Instead, find information on config at https://github.com/zanata/zanata-server/wiki/Document-Storage-Directory
Comment 3 Damian Jansen 2013-08-07 02:20:44 EDT
Verified at 5bf0f1eadda3c43c780c06cdbdb9746bae49215d
Comment 4 Sean Flanigan 2013-11-26 22:31:38 EST
Closing VERIFIED bugs which predate Zanata 3.1.2.

Note You need to log in before you can comment on or make changes to this bug.