{"id":1357,"date":"2009-03-01T04:52:47","date_gmt":"2009-03-01T09:52:47","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1357"},"modified":"2009-03-01T04:52:47","modified_gmt":"2009-03-01T09:52:47","slug":"posterous-and-friendfeed-talk-infrastructure","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2009\/03\/01\/posterous-and-friendfeed-talk-infrastructure","title":{"rendered":"Posterous and FriendFeed talk infrastructure"},"content":{"rendered":"<p>A couple interesting things coming out of startup land.<\/p>\n<p>For one, <a href=\"http:\/\/posterous.com\/\">Posterous<\/a> has a little writeup on <a href=\"http:\/\/axonflux.com\/building-and-scaling-a-startup\">Building and Scaling a Startup on Rails: 12 Things We Learned the Hard Way<\/a>. Good things to take away include using Sphinx\/Solr for search, but the real important takeaway for the MySQL crowd is <b> Storage engine matters, and you should probably use InnoDB<\/b>. If you&#8217;re writing an application, know your storage engines. There are also bits to tell you how to use query_viewer and New Relic to help you fix database bottlenecks, use memcached later, and more. Its a great read.<\/p>\n<p>Next up, there&#8217;s <a href=\"http:\/\/bret.appspot.com\/entry\/how-friendfeed-uses-mysql\">How FriendFeed uses MySQL to store schema-less data<\/a>. I hope Bret from FriendFeed writes more on their infrastructure over time. Its interesting to see that they thought of going the CouchDB route, but never saw it as &#8220;proven&#8221; technology (in comparison to MySQL). <\/p>\n","protected":false},"excerpt":{"rendered":"<p>A couple interesting things coming out of startup land. For one, Posterous has a little writeup on Building and Scaling a Startup on Rails: 12 Things We Learned the Hard Way. Good things to take away include using Sphinx\/Solr for search, but the real important takeaway for the MySQL crowd is Storage engine matters, and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[393,1775,780,519,116],"class_list":["post-1357","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-friendfeed","tag-mysql","tag-posterous","tag-rails","tag-storage-engine"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-lT","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1357"}],"version-history":[{"count":2,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1357\/revisions"}],"predecessor-version":[{"id":1359,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1357\/revisions\/1359"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}