{"id":296,"date":"2022-02-21T21:46:39","date_gmt":"2022-02-21T21:46:39","guid":{"rendered":"https:\/\/liangqi.org\/?p=296"},"modified":"2022-08-01T09:51:43","modified_gmt":"2022-08-01T16:51:43","slug":"aws-technology-usage","status":"publish","type":"post","link":"https:\/\/liangqi.org\/?p=296","title":{"rendered":"AWS Technology Usage"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"athena-s3\">Athena + S3<\/h2>\n\n\n\n<p>Tracking information. Cheap to save and pay on-demand<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"dynamodb\">DynamoDB<\/h2>\n\n\n\n<p>Fast access. Known query pattern (Partition Key, Sorting Key). Scale up automatically if partition it right. TTL should be considered and dump historical data out. (how?)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sqs\">SQS<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"rds\">RDS<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"elastic-cache\">Elastic Cache<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Athena<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">ECS<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Load Balancer<\/h2>\n\n\n\n<p>Query S3s by SQL (Presto).<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Athena + S3 Tracking information. Cheap to save and pay on-demand DynamoDB Fast access. Known query pattern (Partition Key, Sorting Key). Scale up automatically if partition it right. TTL should be considered and dump historical data out. (how?) SQS RDS Elastic Cache Athena ECS Load Balancer Query S3s by SQL (Presto).<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,16],"tags":[],"class_list":["post-296","post","type-post","status-publish","format-standard","hentry","category-aws","category-16"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AWS Technology Usage - Liangqi\u2018s Technical Journey<\/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:\/\/liangqi.org\/?p=296\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS Technology Usage - Liangqi\u2018s Technical Journey\" \/>\n<meta property=\"og:description\" content=\"Athena + S3 Tracking information. Cheap to save and pay on-demand DynamoDB Fast access. Known query pattern (Partition Key, Sorting Key). Scale up automatically if partition it right. TTL should be considered and dump historical data out. (how?) SQS RDS Elastic Cache Athena ECS Load Balancer Query S3s by SQL (Presto).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/liangqi.org\/?p=296\" \/>\n<meta property=\"og:site_name\" content=\"Liangqi\u2018s Technical Journey\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-21T21:46:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-01T16:51:43+00:00\" \/>\n<meta name=\"author\" content=\"liangqi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"liangqi\" \/>\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\":\"Article\",\"@id\":\"https:\/\/liangqi.org\/?p=296#article\",\"isPartOf\":{\"@id\":\"https:\/\/liangqi.org\/?p=296\"},\"author\":{\"name\":\"liangqi\",\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3\"},\"headline\":\"AWS Technology Usage\",\"datePublished\":\"2022-02-21T21:46:39+00:00\",\"dateModified\":\"2022-08-01T16:51:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/liangqi.org\/?p=296\"},\"wordCount\":54,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3\"},\"articleSection\":[\"AWS\",\"\u6280\u672f\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/liangqi.org\/?p=296#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/liangqi.org\/?p=296\",\"url\":\"https:\/\/liangqi.org\/?p=296\",\"name\":\"AWS Technology Usage - Liangqi\u2018s Technical Journey\",\"isPartOf\":{\"@id\":\"https:\/\/liangqi.org\/#website\"},\"datePublished\":\"2022-02-21T21:46:39+00:00\",\"dateModified\":\"2022-08-01T16:51:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/liangqi.org\/?p=296#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/liangqi.org\/?p=296\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/liangqi.org\/?p=296#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/liangqi.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Technology Usage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/liangqi.org\/#website\",\"url\":\"https:\/\/liangqi.org\/\",\"name\":\"Liangqi\u2018s Technical Journey\",\"description\":\"Chasing Excellence; Enjoy life.\",\"publisher\":{\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/liangqi.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3\",\"name\":\"liangqi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/liangqi.org\/wp-content\/uploads\/2022\/01\/P1100089-3-scaled.jpg\",\"contentUrl\":\"https:\/\/liangqi.org\/wp-content\/uploads\/2022\/01\/P1100089-3-scaled.jpg\",\"width\":2560,\"height\":1920,\"caption\":\"liangqi\"},\"logo\":{\"@id\":\"https:\/\/liangqi.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/liangqi.org\"],\"url\":\"https:\/\/liangqi.org\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWS Technology Usage - Liangqi\u2018s Technical Journey","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:\/\/liangqi.org\/?p=296","og_locale":"en_US","og_type":"article","og_title":"AWS Technology Usage - Liangqi\u2018s Technical Journey","og_description":"Athena + S3 Tracking information. Cheap to save and pay on-demand DynamoDB Fast access. Known query pattern (Partition Key, Sorting Key). Scale up automatically if partition it right. TTL should be considered and dump historical data out. (how?) SQS RDS Elastic Cache Athena ECS Load Balancer Query S3s by SQL (Presto).","og_url":"https:\/\/liangqi.org\/?p=296","og_site_name":"Liangqi\u2018s Technical Journey","article_published_time":"2022-02-21T21:46:39+00:00","article_modified_time":"2022-08-01T16:51:43+00:00","author":"liangqi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"liangqi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/liangqi.org\/?p=296#article","isPartOf":{"@id":"https:\/\/liangqi.org\/?p=296"},"author":{"name":"liangqi","@id":"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3"},"headline":"AWS Technology Usage","datePublished":"2022-02-21T21:46:39+00:00","dateModified":"2022-08-01T16:51:43+00:00","mainEntityOfPage":{"@id":"https:\/\/liangqi.org\/?p=296"},"wordCount":54,"commentCount":0,"publisher":{"@id":"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3"},"articleSection":["AWS","\u6280\u672f"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/liangqi.org\/?p=296#respond"]}]},{"@type":"WebPage","@id":"https:\/\/liangqi.org\/?p=296","url":"https:\/\/liangqi.org\/?p=296","name":"AWS Technology Usage - Liangqi\u2018s Technical Journey","isPartOf":{"@id":"https:\/\/liangqi.org\/#website"},"datePublished":"2022-02-21T21:46:39+00:00","dateModified":"2022-08-01T16:51:43+00:00","breadcrumb":{"@id":"https:\/\/liangqi.org\/?p=296#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/liangqi.org\/?p=296"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/liangqi.org\/?p=296#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/liangqi.org\/"},{"@type":"ListItem","position":2,"name":"AWS Technology Usage"}]},{"@type":"WebSite","@id":"https:\/\/liangqi.org\/#website","url":"https:\/\/liangqi.org\/","name":"Liangqi\u2018s Technical Journey","description":"Chasing Excellence; Enjoy life.","publisher":{"@id":"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/liangqi.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/liangqi.org\/#\/schema\/person\/105c89d9b783fda67b62e3ce113d6cd3","name":"liangqi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/liangqi.org\/#\/schema\/person\/image\/","url":"https:\/\/liangqi.org\/wp-content\/uploads\/2022\/01\/P1100089-3-scaled.jpg","contentUrl":"https:\/\/liangqi.org\/wp-content\/uploads\/2022\/01\/P1100089-3-scaled.jpg","width":2560,"height":1920,"caption":"liangqi"},"logo":{"@id":"https:\/\/liangqi.org\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/liangqi.org"],"url":"https:\/\/liangqi.org\/?author=1"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/posts\/296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/liangqi.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=296"}],"version-history":[{"count":3,"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/posts\/296\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/liangqi.org\/index.php?rest_route=\/wp\/v2\/posts\/296\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/liangqi.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liangqi.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/liangqi.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}