{"id":7777,"date":"2012-10-19T17:39:40","date_gmt":"2012-10-19T22:39:40","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=7777"},"modified":"2012-10-19T17:39:40","modified_gmt":"2012-10-19T22:39:40","slug":"twitter-paypal-reveal-database-performance","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=7777","title":{"rendered":"Twitter, PayPal reveal database performance"},"content":{"rendered":"<blockquote><p>Cole revealed that Twitter&#8217;s MySQL database handles some huge numbers \u2014 three million new rows per day, the storage of 400 million tweets per day replicated four times over \u2014 but it is managed by a team of only six full-time administrators and a sole MySQL developer.<\/p><\/blockquote>\n<p>via <a href=\"http:\/\/www.itnews.com.au\/News\/317811,twitter-paypal-reveal-database-performance.aspx\">Twitter, PayPal reveal database performance &#8211; Software &#8211; Technology &#8211; News &#8211; iTnews.com.au<\/a>.<\/p>\n<blockquote><p>Daniel Austin, a technology architect at Paypal, has built a globally-distributed database with 100 terabytes of user-related data, also based on a <strong>MySQL cluster<\/strong>.<\/p>\n<p>Austin said he was charged with building a system with <strong>99.999 percent availability<\/strong>, without any loss of data, an ability to support transactions (and roll them back), and an ability to write data to the database and read it anywhere else in the world in under one second.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Cole revealed that Twitter&#8217;s MySQL database handles some huge numbers \u2014 three million new rows per day, the storage of 400 million tweets per day replicated four times over \u2014 but it is managed by a team of only six &hellip; <a href=\"http:\/\/bucktownbell.com\/?p=7777\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[286],"tags":[475,51,156,151],"class_list":["post-7777","post","type-post","status-publish","format-standard","hentry","category-storage","tag-big-data","tag-clustering","tag-databases","tag-mysql"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/7777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7777"}],"version-history":[{"count":2,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/7777\/revisions"}],"predecessor-version":[{"id":7779,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/7777\/revisions\/7779"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7777"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}