Bug 980658

Summary:	As a sysadmin I want uploaded files to be stored outside the database so that database performance is not negatively impacted
Product:	[Retired] Zanata	Reporter:	David Mason <damason>
Component:	Component-Persistence	Assignee:	David Mason <damason>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Damian Jansen <djansen>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	3.0	CC:	djansen, zanata-bugs
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-11-27 03:31:38 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	901401

Description David Mason 2013-07-03 00:50:10 UTC

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 05:55:52 UTC

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 23:12:29 UTC

(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 06:20:44 UTC

Verified at 5bf0f1eadda3c43c780c06cdbdb9746bae49215d

Comment 4 Sean Flanigan 2013-11-27 03:31:38 UTC

Closing VERIFIED bugs which predate Zanata 3.1.2.