O'Reilly Radar _ Database War Stories #3_ Flickr - The Diigo Meta page

• 30 Dec 08
  

  Lee Aylett
• 04 Sep 08
  

  Sacha Arozarena

  database web2.0 development tagging

• 29 Mar 08
  

  Bruno Martins

  Continuing my series of queries about how "Web 2.0" companies used databases, I asked Cal Henderson of Flickr to tell me "how the folksonomy model intersects with the traditional database. How do you manage a tag cloud?"

  architecture clustering database development flickr optimization programming research web web2.0

• 22 Jan 08
  

  Frank Colcord

  Database

• 21 Jan 08
  

  hyacint

  database flickr architecture web2.0 mysql optimization programming

• 

  Joel Liu

  database scalability

  • "started as a big vertically scaled classic replication tree (well, started as a  single box) and soon hit against performance walls in terms of writes (repl  gives you more reads, same writes as slowest machine in your tree). when we  started, we barely knew anything about how mysql works with indexes (the  documentation is fairly non-beginner), so months of index wrangling to get  better performance ensued.
• 

  Mert Nuhoglu

  database web2.0

• 02 Nov 07
  

  Jason Wehmhoener

  He replied: "lots of the 'web 2.0' feature set doesn't fit well with traditional normalised db schema design. denormalization (or heavy caching) is the only way to generate a tag cloud in milliseconds for hundereds of millions of tags. you can cache stuff

  database flickr web2.0 architecture mysql optimization data scalability sql delicious

• 18 Oct 07
  

  chew barkla

  architecture database flickr optimization scalability performance persistence storage web2.0

• 13 Sep 07
  

  tags

  database tags

• 09 Sep 07
  

  Hendy Irawan

  I also asked for any information on the scale of data Flickr manages and its growth rates. Cal answered:
  
  total stored unique data : 935 GB
  total stored duplicated data : ~3TB

  2 ajax backup article blogging blog blogs business design programming optimization mysql architecture flickr web2.0 database

• 28 Aug 07
  

  Navneet Kumar

  web_databases Database

• 09 Aug 07
  

  Don

  flickr dev

• 05 Aug 07
  

  Bill D

  database web2.0 data article optimization design normalization

• 28 Jun 07
  

  Gautham

  database relational-database shards flickr delicious-import

• 11 Jun 07
  

  Terry Jones

  cal database denormalization details flickr henderson

• 26 Apr 07
  

  Cory Forsyth

  database toread caching cloud databases web2.0 programming php architecture performance fromdelicious

• 25 Mar 07
  

  liu yong

  database

• 24 Mar 07
  

  lei zhou

  database database-war-stories

  • Database War Stories
• 29 Jan 07
  

  mauricio de diana

  software database architecture

• 24 Jan 07
  

  Christian Winkler

  read

• 

  haraldgroven

  How to make a web2.0 data service manageble, even if the amount of meta data (text, comments, tags and user info) is 3TB

  database scalability sql db flickr dbarchitechture for:yngvewb mysql fromDelicious

• 27 Aug 06
  

  j cebrian

  programming mysql optimization architecture web2.0 flickr database dba design development oreilly performance normalization AJAX caching cache webdesign Blog blogs

• 07 Aug 06
  

  Pierre L

  management Flickr MySQL database blog

• 03 Aug 06
  

  Sean E Keener

  architecture for:blafrance for:donovanpacholl programming

• 30 Jul 06
  

  Ivo Frazão

  Artigo falando de como o Flickr usa banco de dados

  database performance web2.0 estudos from_delicious

• 24 Jun 06
  

  s_bergmann

  database design

• 21 May 06
  

  politvs

  opensource basedatos mysql web2.0 flickr

• 20 May 06
  

  Rachel C

  Tim O'Reilly's interview with Cal Henderson of Flickr, on 27 April 2006

  O'Reilly TimOReilly flickr database statistics interview CalHenderson web2.0 information architecture programming

• 09 May 06
  

  veigaard

  16uger database flickr web2.0

• 02 May 06
  

  Konrad .

  oreilly article sql

• 29 Apr 06
  

  Andy Edmonds

  db mysql atScale

• 28 Apr 06
  

  dlgogma

  ajax data folksonomy oreilly tagging web2.0

• 

  gaston

  howto backup web2.0 development

• 

  vladimir liba

  web2.0 flickr optimization database

• 

  ken .

  Denormalising db to cope with millions of tags and achieve acceptable response time (without offline processing), backups (with 935gb unique tag data, no graphics), federated spaces etc.

  database design development folksonomy mysql programming tagging web

• 

  znarfor

  imported sql flickr

• 

  Chrys R

  database flickr optimization web2.0

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.