{"id":414,"date":"2009-05-15T12:49:58","date_gmt":"2009-05-15T20:49:58","guid":{"rendered":"http:\/\/blog.mozilla.org\/webdev\/?p=414"},"modified":"2017-03-08T14:50:07","modified_gmt":"2017-03-08T22:50:07","slug":"socorro-moves-to-new-hardware","status":"publish","type":"post","link":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/","title":{"rendered":"Socorro Moves to New Hardware"},"content":{"rendered":"<p>What has two quad core 3GHz 64bit CPUs, sixteen gigs of RAM and makes the Socorro users happy?  That would be the new hardware that the Socorro system moved to during a six hour operation on Thursday night.  The new hardware was recommended by the folks from the aptly named <a href=\"http:\/\/pgexperts.com\">PostgreSQL Experts, Inc<\/a> after an intense week of consultation and analysis in March earlier this year.  After auditing our existing system of hardware and software, it was apparent that we were woefully underpowered for what we were trying to do.  While simply tuning PostgreSQL helped in the interim, a more powerful platform was clearly in order.<\/p>\n<p>Before we deployed the new hardware, we had to take several steps to tame our voracious use of disk space.  In the previous week, we removed the archived dumps from the database.  They were rarely ever accessed but took up the lion&#8217;s share of our disk space.  By migrating them to file system storage, we made a three hundred gig database migration onto new hardware into a migration of only sixty gig.  <\/p>\n<p>While there may be a need for tuning over the next week, Socorro users should have a much accelerated experience using the Socorro Web site.<\/p>\n<p>Many thanks to <em>aravind<\/em> for shepherding this project through IT, <em>chizu<\/em> in IT for his \ufeffdb cloning\/replication scripting\/tweaking and <em>jberkus<\/em> from PostgreSQL Experts for his superior navigation skills and a steady hand at the PostgreSQL tiller.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What has two quad core 3GHz 64bit CPUs, sixteen gigs of RAM and makes the Socorro users happy? That would be the new hardware that the Socorro system moved to during a six hour operation on Thursday night. The new &hellip; <a class=\"go\" href=\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/\">Continue reading<\/a><\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96],"tags":[264779],"coauthors":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Socorro Moves to New Hardware - Mozilla Web Development<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"lars\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/\",\"name\":\"Socorro Moves to New Hardware - Mozilla Web Development\",\"isPartOf\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#website\"},\"datePublished\":\"2009-05-15T20:49:58+00:00\",\"dateModified\":\"2017-03-08T22:50:07+00:00\",\"author\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/ee1985ebe3df46ad9f1592d217ed7e00\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.mozilla.org\/webdev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Socorro Moves to New Hardware\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#website\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/\",\"name\":\"Mozilla Web Development\",\"description\":\"For make benefit of glorious tubes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.mozilla.org\/webdev\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/ee1985ebe3df46ad9f1592d217ed7e00\",\"name\":\"lars\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/image\/b782a8b11e738304e1c84fc8bc25c495\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4d5968b64077abc38da76911e841eec9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4d5968b64077abc38da76911e841eec9?s=96&d=mm&r=g\",\"caption\":\"lars\"},\"description\":\"Just another aging biker banging rocks together.\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/author\/larsmozillacom\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Socorro Moves to New Hardware - Mozilla Web Development","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/","twitter_misc":{"Written by":"lars","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/","url":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/","name":"Socorro Moves to New Hardware - Mozilla Web Development","isPartOf":{"@id":"https:\/\/blog.mozilla.org\/webdev\/#website"},"datePublished":"2009-05-15T20:49:58+00:00","dateModified":"2017-03-08T22:50:07+00:00","author":{"@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/ee1985ebe3df46ad9f1592d217ed7e00"},"breadcrumb":{"@id":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.mozilla.org\/webdev\/2009\/05\/15\/socorro-moves-to-new-hardware\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.mozilla.org\/webdev\/"},{"@type":"ListItem","position":2,"name":"Socorro Moves to New Hardware"}]},{"@type":"WebSite","@id":"https:\/\/blog.mozilla.org\/webdev\/#website","url":"https:\/\/blog.mozilla.org\/webdev\/","name":"Mozilla Web Development","description":"For make benefit of glorious tubes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.mozilla.org\/webdev\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/ee1985ebe3df46ad9f1592d217ed7e00","name":"lars","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/image\/b782a8b11e738304e1c84fc8bc25c495","url":"https:\/\/secure.gravatar.com\/avatar\/4d5968b64077abc38da76911e841eec9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4d5968b64077abc38da76911e841eec9?s=96&d=mm&r=g","caption":"lars"},"description":"Just another aging biker banging rocks together.","url":"https:\/\/blog.mozilla.org\/webdev\/author\/larsmozillacom\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts\/414"}],"collection":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/comments?post=414"}],"version-history":[{"count":0,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts\/414\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/media?parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/categories?post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/tags?post=414"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/coauthors?post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}