{"id":749,"date":"2006-04-28T00:00:00","date_gmt":"2006-04-27T22:00:00","guid":{"rendered":"https:\/\/wwwneu.strehle.de\/tim\/weblog\/archives\/2006\/04\/28\/687\/"},"modified":"2006-04-28T00:00:00","modified_gmt":"2006-04-27T22:00:00","slug":"687","status":"publish","type":"post","link":"https:\/\/www.strehle.de\/tim\/weblog\/archives\/2006\/04\/28\/687\/","title":{"rendered":"Web 2.0 and Databases"},"content":{"rendered":"<p>Tim O&#8217;Reilly cites Ian Wilkes in <a href=\"http:\/\/radar.oreilly.com\/archives\/2006\/04\/web_20_and_databases_part_1_se.html\" title=\"O'Reilly Radar &gt; Web 2.0 and Databases Part 1: Second Life\">Web 2.0 and Databases Part 1: Second Life<\/a>:<\/p>\n<p>&#8222;Like everybody else, we started with One Database All Hail The Central Database, and have subsequently been forced into clustering. However, we&#8217;ve eschewed any of the general purpose cluster technologies (mysql cluster, various replication schemes) in favor of explicit data partitioning. So, we still have a central db that keeps track of where to find what data (per-user, for instance), and N additional dbs that do the heavy lifting. Our feeling is that this is ultimately far more scalable than black-box clustering.&#8220;<\/p>\n<p>Follow-ups: <a href=\"http:\/\/radar.oreilly.com\/archives\/2006\/04\/database_war_stories_2_bloglin.html\" title=\"O'Reilly Radar &gt; Database War Stories #2: bloglines and memeorandum\">Database War Stories #2: bloglines and memeorandum<\/a>, <a href=\"http:\/\/radar.oreilly.com\/archives\/2006\/04\/database_war_stories_3_flickr.html\" title=\"O'Reilly Radar &gt; Database War Stories #3: Flickr\">#3: Flickr<\/a>, <a href=\"http:\/\/radar.oreilly.com\/archives\/2006\/04\/database_war_stories_4_nasa_wo.html\" title=\"O'Reilly Radar &gt; Database War Stories #4: NASA World Wind\">#4: NASA World Wind<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tim O&#8217;Reilly cites Ian Wilkes in Web 2.0 and Databases Part 1: Second Life: &#8222;Like everybody else, we started with One Database All Hail The Central Database, and have subsequently been forced into clustering. However, we&#8217;ve eschewed any of the general purpose cluster technologies (mysql cluster, various replication schemes) in favor of explicit data partitioning. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[1],"tags":[],"class_list":["post-749","post","type-post","status-publish","format-standard","hentry","category-weblog"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/comments?post=749"}],"version-history":[{"count":0,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/749\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/media?parent=749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/categories?post=749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/tags?post=749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}