{"id":2246,"date":"2019-08-22T10:57:40","date_gmt":"2019-08-22T10:57:40","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=2246"},"modified":"2020-05-02T07:47:30","modified_gmt":"2020-05-02T07:47:30","slug":"rds-db-instances","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/","title":{"rendered":"RDS DB Instances"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>DB instance is an isolated database environment\nin cloud. <\/li><li>Is basic building block of RDS. <\/li><li>Can contain multiple user-created databases<\/li><li>can be accessed using client tools and\napplications similar for standalone database instance. <\/li><li>Can be created or modified by <ul><li>AWS\ncommand line tools<\/li><\/ul><ul><li>RDS\nAPI operations<\/li><\/ul><ul><li>AWS\nManagement Console<\/li><\/ul><\/li><li>Maximum 40 RDS DB instances. <\/li><li>Out of 40, up to 10 can be Oracle or SQL Server\nDB instances under the &#8220;License Included&#8221; model. <\/li><li>40 DB instances for SQL Server or Oracle under\nthe &#8220;BYOL&#8221; licensing model. <\/li><li>All 40 DB instances can be used for <ul><li>MySQL<\/li><\/ul><ul><li>MariaDB<\/li><\/ul><ul><li>PostgreSQL<\/li><\/ul><\/li><li>Request additional DB instances for more DB\ninstances <\/li><li>Every DB instance has DB instance identifier,\ngiven by customer and must be unique for customer in AWS Region.<\/li><li>Each DB instance supports a database engine.\nAmazon RDS currently supports MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL\nServer, and Amazon Aurora database engines.<\/li><li>Some database engines require database name\nduring creation, as <ul><li>For\nMySQL and MariaDB, the database name is, name of a database hosted in your DB\ninstance. <\/li><\/ul><ul><li>A\nDB instance can host multiple databases, or a single Oracle database with\nmultiple schemas. The database name value depends on the database engine:<\/li><\/ul><ul><li>For\nOracle, database name has value of ORACLE_SID, to be supplied when connecting\nto the Oracle RDS instance.<\/li><\/ul><ul><li>For\nMicrosoft SQL Server database engine, database name is not a supported\nparameter.<\/li><\/ul><ul><li>For\nPostgreSQL database engine, the database name is name of a database hosted in\nDB instance.<\/li><\/ul><\/li><li>DB instance identifier identifies the DB\ninstance by <ul><li>Amazon\nRDS API <\/li><\/ul><ul><li>AWS\nCLI commands<\/li><\/ul><\/li><li>RDS maximum size for a MS SQL Server DB with SQL\nServer Express Edition is 10GB per DB<\/li><li>Supported RDS Platforms:<ul><li>MS\nSQL Server<\/li><\/ul><ul><li>Oracle<\/li><\/ul><ul><li>MySQL\nServer<\/li><\/ul><ul><li>PostgreSQL<\/li><\/ul><ul><li>Aurora<\/li><\/ul><ul><li>MariaDB<\/li><\/ul><\/li><li>When a backup is restored, the restore will always\nbe a new RDS instance, with a new DNS name<\/li><li>Backup types:<ul><li>Automated\nbackups<ul><li>Allows\nyou to recover your database to any point in time within a retention period<\/li><\/ul><ul><li>Retention\nperiods can be between 1 and 35 days<\/li><\/ul><ul><li>Takes\na full daily snapshot and will also store transaction logs through the day<\/li><\/ul><ul><li>When\nyou do a recovery, AWS will choose the most recent daily backup and then apply\ntransaction logs<\/li><\/ul><ul><li>Allows\nyou to do a point in time recover down to a second within the retention period<\/li><\/ul><ul><li>Enabled\nby default<\/li><\/ul><ul><li>Backup\ndata is stored in S3<\/li><\/ul><ul><li>You\nget free storage space equal to the size of your database. <\/li><\/ul><ul><li>Taken\nwithin a defined window<\/li><\/ul><ul><li>During\nthe backup, storage I\/0 may be suspended and you may experience extended\nlatency<\/li><\/ul><\/li><\/ul><ul><li>Database\nsnapshots<ul><li>User\ninitiated from the console<\/li><\/ul><ul><li>Stored\neven after you delete the original RDS instance unlike automatic backups<\/li><\/ul><\/li><\/ul><\/li><li>Encryption:<ul><li>Encryption\nat rest is supported for MySQL, Oracle, SQL Server, PostgreSQL, and MariaDB<\/li><\/ul><ul><li>Encryption\nis done using the AWS Key Management Service (KMS)<\/li><\/ul><ul><li>Once\nyour RDS instance is encrypted the data stored at rest in the underlaying\nstorage is encrypted, as are its automated backups, read replicas and snapshots<\/li><\/ul><ul><li>To\nuse RDS encryption, create a new DB instance with encryption enabled and\nmigrate your data to it<\/li><\/ul><\/li><li>Encrypting an existing DB instance is not supported <\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB instance is an isolated database environment in cloud. Is basic building block of RDS. Can contain multiple user-created databases can be accessed using client tools and applications similar for standalone database instance. Can be created or modified by AWS command line tools RDS API operations AWS Management Console Maximum 40 RDS DB instances. Out&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2084,"menu_order":45,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[7,372,380,417],"class_list":["post-2246","page","type-page","status-publish","hentry","tag-aws","tag-devops","tag-devops-engineer","tag-rds-db-instances"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RDS DB Instances - Testprep Training 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\/aws-devops-engineer\/rds-db-instances\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RDS DB Instances - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"DB instance is an isolated database environment in cloud. Is basic building block of RDS. Can contain multiple user-created databases can be accessed using client tools and applications similar for standalone database instance. Can be created or modified by AWS command line tools RDS API operations AWS Management Console Maximum 40 RDS DB instances. Out...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-02T07:47:30+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/\",\"name\":\"RDS DB Instances - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-08-22T10:57:40+00:00\",\"dateModified\":\"2020-05-02T07:47:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Certified DevOps Engineer Professional\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RDS DB Instances\"}]},{\"@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 DB Instances - Testprep Training 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\/aws-devops-engineer\/rds-db-instances\/","og_locale":"en_US","og_type":"article","og_title":"RDS DB Instances - Testprep Training Tutorials","og_description":"DB instance is an isolated database environment in cloud. Is basic building block of RDS. Can contain multiple user-created databases can be accessed using client tools and applications similar for standalone database instance. Can be created or modified by AWS command line tools RDS API operations AWS Management Console Maximum 40 RDS DB instances. Out...","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-05-02T07:47:30+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/","name":"RDS DB Instances - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-08-22T10:57:40+00:00","dateModified":"2020-05-02T07:47:30+00:00","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/rds-db-instances\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"AWS Certified DevOps Engineer Professional","item":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-devops-engineer\/"},{"@type":"ListItem","position":3,"name":"RDS DB Instances"}]},{"@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\/2246","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=2246"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2246\/revisions"}],"predecessor-version":[{"id":2459,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2246\/revisions\/2459"}],"up":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2084"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=2246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=2246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=2246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}