Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #114

Re: In need of advise abo

Show all headers | View raw

  To: comp.lang.java.databases


Arne Vajhoj wrote:
> Jeffrey H. Coffield wrote:
>> mebe wrote:
>>> i am working on a project where users are able to submit any ammount
>>> of large binary files.
>>> Currently all data is stored in a MySql database, but i am uncertain
>>> if it would be better/more efficient/faster to store the binary files
>>> on the filesystem. This would certainly save MySql from a lot of work,
>>> but ensuring data integrity could become complicated.
>>> I am uncertain if it is a good idea to move the binary data out of the
>>> database, so i appreciate any information.
>>> Thanks in advance.
>>
>> Aside from direct performance questions, also consider what it would 
>> take to back up and restore the database. If the large blobs don't 
>> change much (archiving documents/images) then storing the data in 
>> files and using an incremental backup scheme could be much more 
>> efficient.
> 
> I think backup is an argument for storing in database.
> 
> To do backup and restore of both database and file system that
> need to match adds complexity to the procedures.
> 
> Arne

True, but when there are close to a terabyte of images that are archived
(write once, read seldom) we do an incremental backup of only what's 
added. If it was in the database, you would have to back up the whole 
thing. If a restore is ever done, the database can be up quickly while 
the old images are restored.

Jeff C

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

In need of advise about s "mebe" <mebe@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "David Harper" <david.harper@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "BoBi" <bobi@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "Thomas Kellerer" <thomas.kellerer@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "RedGrittyBrick" <redgrittybrick@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000

csiph-web