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
[email protected]
On Thu, Sep 17, 2009 at 12:33 PM, Aaron Guise <[email protected]>
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
[email protected]
On Thu, Sep 17, 2009 at 11:00 AM, Tom Lahti <[email protected]>
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: [email protected]
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
[email protected]
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
