tag:blogger.com,1999:blog-18337119.post6783686817147176556..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: I WILL NOT BLOBUnknownnoreply@blogger.comBlogger13125tag:blogger.com,1999:blog-18337119.post-5690318113345953062010-04-30T15:51:22.617-04:002010-04-30T15:51:22.617-04:00Thank you for the article. I was going to go the D...Thank you for the article. I was going to go the DB route, just because I think is a clean way to go. There should be a mysql data type that just use the file system and keep the reference on the db making completely transparaent the file implementation.testhttps://www.blogger.com/profile/03410045100401727016noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-64173941400292608382009-03-27T17:45:00.000-04:002009-03-27T17:45:00.000-04:00Thanks for your article. How do handle transaction...Thanks for your article. How do handle transactions when you are dealing with a file system.<BR/><BR/>-ManojAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-51803537562111796852009-02-20T06:31:00.000-05:002009-02-20T06:31:00.000-05:00Thank you for posting this.The opinions and advice...Thank you for posting this.<BR/><BR/>The opinions and advice from experts like yourself are very helpful for the less knowledgeable, like myself.<BR/><BR/>Thanks again.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-3141035938646036422008-06-24T14:31:00.000-04:002008-06-24T14:31:00.000-04:00Excellent post, Frank. Made up my mind about BLOBs...Excellent post, Frank. Made up my mind about BLOBs as well. I wonder if Paul and PBXT will be ever able to solve the issues here.Artem Russakovskiihttps://www.blogger.com/profile/15848494241404160186noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-83147630760787071312008-04-23T23:10:00.000-04:002008-04-23T23:10:00.000-04:00With regards to transactions and backups, ensuring...With regards to transactions and backups, ensuring the data is on disk before you commit the pointer in the DB is sufficient for most cases. For backups, if you're inserting as above, then you can always safely dump the DB then the FS. Sure the FS might contain more data than in the DB, but it won't contain less.<BR/><BR/>I guess I'm not seeing the overhead as much of a detraction.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-27519528616921017102008-04-23T01:54:00.000-04:002008-04-23T01:54:00.000-04:00I think your points are valid and frankly, BLOBs s...I think your points are valid and frankly, BLOBs should be stored in a file system. <BR/><BR/>There are some situations that make the decision less clear cut. For example: <BR/><BR/>Synchronizing backups between filesystem and database to ensure recovery would contain matching data.<BR/><BR/>Also, crashes of the filesystem could render some files invalid. DBs tend to handle such matters well with their transaction logs.<BR/><BR/>If you require BLOBs to be inserted/updated in a transaction you will find yourself rolling your own transaction code to work in conjunction with database transactions.<BR/><BR/>...Michael...Michaelhttps://www.blogger.com/profile/09108721777783507215noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-3840592517059301152008-02-29T12:43:00.000-05:002008-02-29T12:43:00.000-05:00thanks for this.I have finally made up my mind on ...thanks for this.I have finally made up my mind on this issue.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-67273669026850812972008-02-12T00:55:00.000-05:002008-02-12T00:55:00.000-05:00Hello Frank,I stand corrected. Flickr stores only ...Hello Frank,<BR/><BR/>I stand corrected. Flickr stores only image refs in the DB, the actual image files are stored on the file system.<BR/><BR/>Thanks for the informative article.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-85642444594648642502008-02-11T20:45:00.001-05:002008-02-11T20:45:00.001-05:00hi brien,thank you for the links.frankhi brien,<BR/><BR/>thank you for the links.<BR/><BR/>frankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-15053057231200613922008-02-11T20:45:00.000-05:002008-02-11T20:45:00.000-05:00Hi anonymous,From comments on http://www.highscal...Hi anonymous,<BR/><BR/>From comments on http://www.highscalability.com/flickr-architecture and http://sheeri.com/archives/39 and this presentation by Cal Henderson (http://www.niallkennedy.com/blog/uploads/flickr_php.pdf), Flickr only stores image reference in db.<BR/><BR/>If you believe otherwise, please update me and provide reference.<BR/><BR/>thanks!Frankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-70858589873679040282008-02-11T17:55:00.000-05:002008-02-11T17:55:00.000-05:00Flickr has a massive image database. They store im...Flickr has a massive image database. They store images in the MySQL database. I have not seen any performance issues with Flickr.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-3318273868707410822008-02-11T17:44:00.000-05:002008-02-11T17:44:00.000-05:00hi there, thanks for this post. There's a dearth o...hi there, thanks for this post. There's a dearth of anecdotal evidence on the topic of "db or fs?" ... some more resources: a thread on the tomcat dev list recently explored this too ... <BR/><BR/>http://mail-archives.apache.org/mod_mbox/tomcat-users/200802.mbox/%3c47B08812.8000006@compulsivecreative.com%3e <BR/><BR/>http://mail-archives.apache.org/mod_mbox/tomcat-users/200802.mbox/%3ced5105470802100246n41aa5c12w87ec26494bc0ea3d@mail.gmail.com%3eUnknownhttps://www.blogger.com/profile/02377481719823166658noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-54411620740117272792008-01-28T04:24:00.000-05:002008-01-28T04:24:00.000-05:00Hi Frank, interesting and well-written post. My co...Hi Frank, <BR/><BR/>interesting and well-written post. My comment was indeed intended in the way you eloquently describe it in your article:<BR/><BR/>"There are more than available features, cost and quantity discount factors to take into account when making a decision about the DBMS that should be used for a particular environment and architecture."<BR/><BR/>and<BR/><BR/>"For us, it's not just about storing 400 million photos. It's also about handling load that is generated by serving more than 4 billion page views a month."<BR/><BR/>Anyway - it's great to hear your point of view - thanks for sharing it.<BR/><BR/>Rolandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.com