{"id":1826,"date":"2019-08-07T08:23:10","date_gmt":"2019-08-07T08:23:10","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=1826"},"modified":"2020-03-12T11:10:29","modified_gmt":"2020-03-12T11:10:29","slug":"rds","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/","title":{"rendered":"RDS"},"content":{"rendered":"\r\n<ul class=\"wp-block-list\">\r\n<li>Traditional relational databases that include tables, rows, fields<\/li>\r\n<li>On-Line Transaction Processing (OLTP) type DB<\/li>\r\n<li>You can copy a snapshot to another region if you want to have your database available in another region<\/li>\r\n<li>You scale your DB by taking a snapshot and doing a restore to a larger sized tier<\/li>\r\n<li>RDS maximum size for a MS SQL Server DB with SQL Server Express Edition is 10GB per DB<\/li>\r\n<li>Supported RDS Platforms:\r\n<ul>\r\n<li>MS SQL Server<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Oracle<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>MySQL Server<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>PostgreSQL<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Aurora<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>MariaDB<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>When a backup is restored, the restore will always be a new RDS instance, with a new DNS name<\/li>\r\n<li>Backup types:\r\n<ul>\r\n<li>Automated backups\r\n<ul>\r\n<li>Allows you to recover your database to any point in time within a retention period<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Retention periods can be between 1 and 35 days<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Takes a full daily snapshot and will also store transaction logs through the day<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>When you do a recovery, AWS will choose the most recent daily backup and then apply transaction logs<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Allows you to do a point in time recover down to a second within the retention period<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Enabled by default<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Backup data is stored in S3<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>You get free storage space equal to the size of your database.<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Taken within a defined window<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>During the backup, storage I\/0 may be suspended and you may experience extended latency<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Database snapshots\r\n<ul>\r\n<li>User initiated from the console<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Stored even after you delete the original RDS instance unlike automatic backups<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Encryption:\r\n<ul>\r\n<li>Encryption at rest is supported for MySQL, Oracle, SQL Server, PostgreSQL, and MariaDB<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Encryption is done using the AWS Key Management Service (KMS)<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Once your RDS instance is encrypted the data stored at rest in the underlaying storage is encrypted, as are its automated backups, read replicas and snapshots<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>To use RDS encryption, create a new DB instance with encryption enabled and migrate your data to it<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Encrypting an existing DB instance is not supported<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>RDS And Multi-AZ Failover<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Allows you to have an exact copy of your production database in another AZ<\/li>\r\n<li>AWS handles the replication for you, so when your prod database is written to, the write will automatically be synchronized to the stand-by DB<\/li>\r\n<li>In the event of DB maintenance, instance failure or AZ failure, RDS will automatically fail-over to the standby so that database operations can resume quickly without Admin intervention.<\/li>\r\n<li>In a fail-over scenario, the same DNS name is used to connect to the secondary instance, There is no need to reconfigure your application<\/li>\r\n<li>Multi AZ configurations are used for HA\/DR only, and is not used for improving performance<\/li>\r\n<li>To scale for performance you need to set up read replicas<\/li>\r\n<li>Available for SQL Server, Oracle, MySQL, PostGreSQL, and Aurora<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>RDS &amp; Using Read Replicas<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Uses asynchronous replication, from the primary instance to other instances that can be read from<\/li>\r\n<li>You can have up to 5 read replicas of your main database<\/li>\r\n<li>Allow you to have a read only copy of your prod database<\/li>\r\n<li>Used primarily for very read-heavy database workloads<\/li>\r\n<li>SQL Server and Oracle are not supported<\/li>\r\n<li>Used for scaling not DR<\/li>\r\n<li>Must have automatic backups setup<\/li>\r\n<li>You can have read replicas of read replicas (but could incur latency as its daisy chained)<\/li>\r\n<li>Each read replica will have its own DNS endpoint<\/li>\r\n<li>You cannot have read replicas that have Multi-AZ<\/li>\r\n<li>You can create read replicas of Multi-AZ source databases however<\/li>\r\n<li>Read Replicas can be promoted to be their own databases, however this breaks replication<\/li>\r\n<li>Read Replicas in a second region for MySQL and MariaDB, not for PostgreSQL<\/li>\r\n<li>Read Replicas can be bigger than the primary source DB from a resource perspective<\/li>\r\n<\/ul>\r\n","protected":false},"excerpt":{"rendered":"<p>Traditional relational databases that include tables, rows, fields On-Line Transaction Processing (OLTP) type DB You can copy a snapshot to another region if you want to have your database available in another region You scale your DB by taking a snapshot and doing a restore to a larger sized tier RDS maximum size for a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[7,324],"class_list":["post-1826","page","type-page","status-publish","hentry","category-amazon-aws","tag-aws","tag-rds"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RDS | AWS | TestPrep Tutorials<\/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:\/\/www.testpreptraining.ai\/tutorial\/rds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RDS | AWS | TestPrep Tutorials\" \/>\n<meta property=\"og:description\" content=\"Traditional relational databases that include tables, rows, fields On-Line Transaction Processing (OLTP) type DB You can copy a snapshot to another region if you want to have your database available in another region You scale your DB by taking a snapshot and doing a restore to a larger sized tier RDS maximum size for a...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-12T11:10:29+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/\",\"name\":\"RDS | AWS | TestPrep Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-08-07T08:23:10+00:00\",\"dateModified\":\"2020-03-12T11:10:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RDS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RDS | AWS | TestPrep Tutorials","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:\/\/www.testpreptraining.ai\/tutorial\/rds\/","og_locale":"en_US","og_type":"article","og_title":"RDS | AWS | TestPrep Tutorials","og_description":"Traditional relational databases that include tables, rows, fields On-Line Transaction Processing (OLTP) type DB You can copy a snapshot to another region if you want to have your database available in another region You scale your DB by taking a snapshot and doing a restore to a larger sized tier RDS maximum size for a...","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-03-12T11:10:29+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/","name":"RDS | AWS | TestPrep Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-08-07T08:23:10+00:00","dateModified":"2020-03-12T11:10:29+00:00","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/rds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/rds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"RDS"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=1826"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1826\/revisions"}],"predecessor-version":[{"id":4538,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1826\/revisions\/4538"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=1826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=1826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=1826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}