{"id":128962,"date":"2020-12-08T16:00:02","date_gmt":"2020-12-08T13:00:02","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it\/"},"modified":"2020-12-08T16:00:02","modified_gmt":"2020-12-08T13:00:02","slug":"what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it\/","title":{"rendered":"#What AWS Storage Should You Use For a Database Server? \u2013 CloudSavvy IT"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3845798527b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3845798527b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it\/#Database-Focused_EC2_Instances\" >Database-Focused EC2 Instances<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it\/#EBS_Volume_Types\" >EBS Volume Types<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/what-aws-storage-should-you-use-for-a-database-server-cloudsavvy-it\/#Hard_Drive_Volumes\" >Hard Drive Volumes<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#What AWS Storage Should You Use For a Database Server? \u2013 CloudSavvy IT&#8221;<\/strong><\/p>\n<div id=\"article-content-area\">\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5269\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/0eb3564906a864c93706b30eaca199af\/p\/uploads\/2020\/06\/e601b806.png\" alt=\"AWS Logo\" width=\"700\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Database performance is heavily affected by the performance of the underlying memory. For reads, having a lot of RAM can speed things up, but for write-heavy operations, the bottleneck is the SSD of hard disk it runs out. AWS has plenty of options for storage, so which one is best for you?<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Database-Focused_EC2_Instances\"><\/span>Database-Focused EC2 Instances<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Beyond just underlying storage, there are plenty of other factors to database performance. AWS has many different classes of instances with individual tiers within them.<\/p>\n<p>The most database-oriented instance <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/aws.amazon.com\/ec2\/instance-types\/r5\/?tag=reviewgeek-20\">are the R5 series<\/a>. Theses are optimized for memory performance, both with RAM speed and size and EBS performance. They offer a high ratio of core count to available memory, all the way up to\u00a0768 GB of RAM on the\u00a0r5.24xlarge.<\/p>\n<p>There is also the\u00a0r5d <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a>, a subclass of R5 that offers a straight up local disk, not on EBS. The largest tier has four\u00a0900 GB NVMe SSDs. Smaller in size than EBS\u2019s max capacity, but will have stellar performance and great latency.<\/p>\n<p>There is also the D3 series, which offer the largest amount of local storage possible for an EC2 instance, up to 336 TB. If you\u2019re looking to run a particularly massive instance storing a lot of data, D3 may work best for you.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"EBS_Volume_Types\"><\/span>EBS Volume Types<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>EBS has a a few different tiers. The most common is gp3, which is a <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">general<\/a> purpose SSD backed volume that offers solid performance at a higher price than hard drive backed volumes. <code>gp3<\/code>\u00a0is the latest generation, replacing <code>gp2<\/code>and offering 4x better performance using PCIe Gen 4 SSDs.<\/p>\n<p>gp3 uses a burst-bucket pricing model. Depending on the size of the volume, it earns \u201cIO Credits\u201d per hour that are used automatically to buy IOPS, or input-output-operations-per-second. This allows quick bursts of performance when needed, but if you need steady, solid performance, relying on this is not a great idea. There is also a maximum number of IOPS; for gp3, that\u2019s\u00a016,000.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2391 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/890d9cf389659b14e31e55240bb7a75d\/p\/uploads\/2019\/10\/f22af404.png\" alt=\"GP2 burst bucket model\" width=\"700\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/h3>\n<p>Volumes earn IO credits at a rate of 3 per GB per second. Meaning that if you have a volume greater than 1 TB, your bucket will be always full, and you won\u2019t have to worry about burst performance. Anything lower than that, and you\u2019re limited to the baseline performance based on how many credits you earn.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2392 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/3ad1d4ad04a6ce74c47c0ed98a78e12f\/p\/uploads\/2019\/10\/b4097f75.png\" alt=\"Baseline performance exceeds burst after 1 TB\" width=\"700\" height=\"316\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>What this means in practice is that if you need extra performance, you\u2019ll want to use the second SSD based volume, <code>io2<\/code>, also known as Provisioned IOPS SSD. These allow you to literally buy disk performance directly, provisioned to your EBS volume. The best tier, <code>io2 Block Express<\/code>, offers up to 4000 MB\/s per volume and\u00a07,500 MB\/s per instance.<\/p>\n<p>That\u2019s up to four times the performance of <code>gp3<\/code>, but only if you can pay for it\u2014bandwidth is expensive, and you\u2019ll need to pay for every bit of it. A top-of-the-line <code>io2<\/code> volume can easily cost thousands of dollars per month, more than the EC2 instance that may be running on it. That\u2019s on top of the 83% increase in per-GB storage costs.<\/p>\n<p>While <code>io2<\/code>\u00a0is an option for customers who need every ounce of performance they can get, unless you\u2019re maxing out your drive, the general purpose <code>gp3<\/code>\u00a0volumes will be great for many people.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Hard_Drive_Volumes\"><\/span>Hard Drive Volumes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are two main hard drive EBS volumes,\u00a0Throughput Optimized HDD (st1) Volumes, and\u00a0Cold HDD (sc1) Volumes. The names are fairly self explanatory\u2014st1 is optimized for decent enough sequential read speeds (though terrible random performance, as all hard drives have). For non-critical <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lications requiring large file sizes, sc1 offers great local storage performance.<\/p>\n<p>Both types of volumes also use the burst bucket model, but top out at a fixed MBps number based on volume size.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2394 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/8d544e1acb0ef7d2bb0097966131a0e8\/p\/uploads\/2019\/10\/b4097f75-1.png\" alt=\"Base throughput is always lower than burst\" width=\"700\" height=\"284\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For databases though, random read and write performance can matter a lot, as does latency. It\u2019s 2020, and your users shouldn\u2019t have to wait for a disk to spin up and wait for a magnetic read head to fetch some basic data. Not to mention how it would handle complex SQL queries that could grind the disk to a halt.<\/p>\n<p>For anything user-facing, performance matters, and you should use an SSD. The only case where it makes sense is in read heavy applications where the database is small enough that it can be held mostly in memory, but even then, it would be small enough where the slight premium of even a basic gp3 volume would be worth it.<\/p>\n<p>However, for big data, analytics, and other internal databases, the database can be so large that the cost of local storage is too high to run on SSDs. If you\u2019re looking to run a\u00a0high capacity data lake or multi-server cluster, you may not care so much about slightly worse disk speed, especially if it\u2019s saving you money in the process.\n<\/p><\/div>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.cloudsavvyit.com\/8464\/what-aws-storage-should-you-use-for-a-database-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#What AWS Storage Should You Use For a Database Server? \u2013 CloudSavvy IT&#8221; Database performance is heavily affected by the performance of the underlying memory. For reads, having a lot of RAM can speed things up, but for write-heavy operations, the bottleneck is the SSD of hard disk it runs out. AWS has plenty of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":128963,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.cloudsavvyit.com\/p\/uploads\/2020\/06\/e601b806.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-128962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/128962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=128962"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/128962\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/128963"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=128962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=128962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=128962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}