{"id":263,"date":"2011-05-23T11:31:04","date_gmt":"2011-05-23T16:31:04","guid":{"rendered":"http:\/\/www.networkjack.info\/blog\/?p=263"},"modified":"2011-05-24T14:54:09","modified_gmt":"2011-05-24T19:54:09","slug":"differences-in-hardwaresoftware-for-a-database-server","status":"publish","type":"post","link":"http:\/\/www.networkjack.info\/blog\/2011\/05\/23\/differences-in-hardwaresoftware-for-a-database-server\/","title":{"rendered":"Differences in Hardware\/Software for a Database Server"},"content":{"rendered":"<p>I previously <a title=\"Differences in Hardware\/Software for an Email Server\" href=\"\/blog\/2011\/02\/14\/differences-in-hardware-software-for-an-email-server\/\">posted<\/a> about the migration we performed for a customer for their email server.<\/p>\n<p>This weekend we performed a cutover for another client from an older dedicated MySQL database server to a newer piece of hardware. First, the graph:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.networkjack.info\/blog\/wp-content\/uploads\/2011\/05\/dbla.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-264\" style=\"border: 0pt none;\" title=\"DB Server Load Average\" src=\"http:\/\/www.networkjack.info\/blog\/wp-content\/uploads\/2011\/05\/dbla.jpg\" alt=\"\" width=\"603\" height=\"244\" srcset=\"http:\/\/www.networkjack.info\/blog\/wp-content\/uploads\/2011\/05\/dbla.jpg 603w, http:\/\/www.networkjack.info\/blog\/wp-content\/uploads\/2011\/05\/dbla-300x121.jpg 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>And so where the system was under an almost continuous load of 1.0, the system now seems almost bored.<\/p>\n<p>Specs for old DB Server<\/p>\n<ul>\n<li>Dell PowerEdge 2850<\/li>\n<li>2GB RAM<\/li>\n<li>2 x 3.6Ghz Xeon with Hyperthreading enabled<\/li>\n<li>3 x 146GB 15K rpm SCSI &#8211; PERC RAID 5<\/li>\n<li>Debian Linux 4 &#8211; 2.4.31-bf2.4 SMP &#8211; 32-bit kernel<\/li>\n<li>MySQL 4.1.11<\/li>\n<\/ul>\n<p>Specs for new DB Server<\/p>\n<ul>\n<li>Dell PowerEdge 2950<\/li>\n<li>8GB RAM<\/li>\n<li>2 x Dual core 3.0Ghz Xeon with HT disabled<\/li>\n<li>7 x 146GB 10k rpm 2.5&#8243; SAS drives &#8211; PERC RAID 5<\/li>\n<li>Debian Linux 6 &#8211; 2.6.32-5-amd64 SMP &#8211; 64-bit kernel<\/li>\n<li>MySQL 5.0.51a (soon to be 5.1)<\/li>\n<\/ul>\n<p>The client is understandably very happy with the result.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I previously posted about the migration we performed for a customer for their email server. This weekend we performed a cutover for another client from&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.networkjack.info\/blog\/2011\/05\/23\/differences-in-hardwaresoftware-for-a-database-server\/\">Continue reading<span class=\"screen-reader-text\">Differences in Hardware\/Software for a Database Server<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,22,7,20,8],"tags":[],"class_list":["post-263","post","type-post","status-publish","format-standard","hentry","category-database","category-hardware","category-linux","category-mysql","category-servers","entry"],"_links":{"self":[{"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/posts\/263"}],"collection":[{"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/comments?post=263"}],"version-history":[{"count":3,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"predecessor-version":[{"id":267,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/posts\/263\/revisions\/267"}],"wp:attachment":[{"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.networkjack.info\/blog\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}