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

[Justin Hayes]

Thanks Aaron for taking the time to dig them out. I'll take a look at  
them (though fingers crossed adding the binary format options to the  
DB dump seems to be working so far).

Justin

On 15 Oct 2009, at 22:09, Aaron Guise wrote:

> Hi Justin,
>
> Sorry it took so long.  I was on leave and then couldn't test that  
> my scripts still worked.  I have found them now and tested it all  
> out.  They are attached here.  If you have any trouble please let me  
> know.
>
> Regards,
> Aaron Guise
>   07 838 7793
> 027 212 6638
> aaron at guise.net.nz
>
>
>
> On Thu, Sep 17, 2009 at 12:33 PM, Aaron Guise <aaron at guise.net.nz>  
> wrote:
> I fully agree Tom,  SQL Servers totally own the filesystem  
> equivalent in this regard.  Our attachments table is huge and it  
> would be rather difficult to keep a track of them all and ensure  
> every last one is backed up without the MySQL storage system :-)
>
>
> Regards,
> Aaron Guise
>   07 838 7793
> 027 212 6638
> aaron at guise.net.nz
>
>
>
>
> On Thu, Sep 17, 2009 at 11:00 AM, Tom Lahti <toml at bitstatement.net>  
> wrote:
> 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/
> -- ============================
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> <GrabAndInsert.zip>


-------------------------------------------------
Justin Hayes
Orbis Support Manager
justin.hayes at orbisuk.com




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091019/afe42fb7/attachment.htm>