[rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

Tom Lahti toml at bitstatement.net
Wed Sep 16 19:00:33 EDT 2009


Justin Hayes wrote:
> Thanks Aaron. I've always wondered why file attachments are stored in
> the db at all. I'd have thought those would have been better placed out
> in the filesystem. 

Egads! What if the storage database is not local to the web server?  How will
you perform comprehensive backups?  What if your RT has a million attachments,
or more?  Not to mention the performance hit of using a filesystem as a
database, especially with high concurrency at the HTTP level.

I have a custom database application designed specifically to store PDFs in
the database.  It has 30 million documents in it, the database storage is over
4TB.  The web-based front-end for it is efficient enough to saturate a
100MBit/sec Internet connection with a single Core-2 duo web server.  When I
tested this against our old filesystem version of the application, it
outperformed the filesystem by more than 100%.  Backup is done by dumping the
database in chunks in a rotating schedule.  Scalability can be accomplished
with simple replication to additional read-only SQL servers and using a SQL
relay to dispatch SQL commands in a load-balancing fashion.

-- 
-- ============================
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- ============================



More information about the rt-users mailing list