This article discusses it briefly: http://php.dreamwerx.net/forums/viewtopic.php?t=6
I am using this type of design/technology for quite a few clients. Some storing gigs and gigs of data (images, documents, pdf, anything) over multiple servers. The scalability and performance of a well designed system I think are very close to standard filesystem storage. I have currently written http and ftp gateways to access data stored in mysql dataservers(databases). Quite easy and fast... I have yet to do much with searching and indexing of files (not required) but I would imagine you could have very fast searching features. On Wed, 7 Jan 2004, Steve Folly wrote: > Hi, > > (disclaimer - this thread could easily go off topic; I'm interested > only in the MySQL aspects of what follows...) > > At work we are currently investigating ways of filing all our > electronic documents. > > There is commercial software that will do this I know, but I was > wondering whether MySQL would be suitable for this type of thing. > > The 'documents' could be literally any binary file. My idea would be to > create a table with a blob column for the document itself, and document > title, reference number, keywords, other meta-data. And a web-based > front-end to search and serve documents. > > Although the documents could be any file, the majority would be textual > documents (Word documents, PDF, etc). How would one go about indexing > such data, since full text searches operate on textual columns? > > How to cope with columns exceeding the max packet length? Why is there > a max_packet_length setting; surely this is low-level stuff that > shouldn't affect query and result sizes? > > Is storing the actual documents in the database such a good idea > anyway? Perhaps store the file in a file system somwhere and just store > the filename? > > > If anyone has experience in doing (or been dissuaded from doing) this > kind of application your thoughts and comments would be appreciated. > (If only to tell me "don't be so stupid, it'll never work" :) > > Thanks. > > -- > Regards, > Steve. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
