![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/RDS1.jpg\")
<\/p>\nRDS is a Database as a Service (DBaaS) product. It can be used to provision a fully functional database without the admin overhead traditionally associated with DB platforms. It can perform at scale, be made publicly accessible, and can be configured for demanding availability and durability scenarios.<\/p>\n
<\/p>\n
<\/p>\n
RDS supports a number of database engines:<\/p>\n
RDS can be deployed in single AZ or Multi-AZ mode (for resilience) and supports the following instance types:<\/p>\n
Two types of storage are supported:<\/p>\n
RDS instances are charged based on:<\/p>\n
RDS supports encryption with the following limits\/restrictions\/conditions:<\/p>\n
Network access to an RDS instance is controlled by a security group (SG) associated with the RDS instance.<\/p>\n
<\/p>\n
RDS is capable of a number of different types of backups. Automated backups to S3 occur daily<\/strong> and can be retained from 0<\/strong> to 35 days<\/strong> (with 0<\/strong> being disabled<\/strong>). Manual snapshots are taken manually and exist until deleted, and point-in-time log-based backups are also stored on S3.<\/p>\n <\/p>\n Multi-AZ<\/span><\/p>\n Replication of data is synchronous<\/strong> \u2014 it’s copied in real time from the primary<\/strong> to the standby<\/strong> as it’s written. The primary and master each have their own storage. Backups<\/strong> are taken using the standby<\/strong>, ensuring no performance impact. Maintenance<\/strong> is performed on the standby<\/strong> first, which is then promoted to minimize downtime.<\/p>\n <\/p>\n Multi-AZ<\/p>\n Maintenance<\/span><\/p>\n AWS will perform the following steps:<\/p>\n <\/p>\n Read Replicas<\/span> are read-only<\/strong> copies of an RDS instance that can be created in the same region or a different region from the primary instance.<\/p>\n Read Replicas can be addressed independently<\/strong> (each having their own DNS name)<\/strong> and used for read workloads, allowing you to scale reads. Five Read<\/strong> Replicas can be created from a RDS instance, allowing a 5x<\/strong> increase in reads. Read Replicas can be created from Read Replicas, and they can be promoted to primary instances and can be themselves Multi-AZ.<\/p>\n Reads from a Read Replica are eventually consistent \u2014 normally seconds, but the application needs to support it.<\/p>\n <\/p>\n Scaling for Performance<\/span><\/p>\n <\/p>\n Scenario<\/em>: You need to pull data for analysis, but you don’t want to degrade performance on your production database.<\/p>\n Solution<\/em>: Create a read replica that’s only used for this reason.<\/p>\n <\/p>\n AWS RDS Read Replication vs. Multi-AZ Failover Deployments<\/span><\/p>\n <\/p>\n What Can Trigger a Failover?<\/span><\/p>\n <\/p>\n How Do Failovers Work?<\/span><\/p>\n 1. Amazon detects an issue and starts the failover process.<\/p>\n 2. DNS records are modified to point to the standby instance.<\/p>\n 3. The application re-establishes any existing DB connections.<\/p>\n <\/p>\n How Do We Know When a Failover Happens?<\/span><\/p>\n <\/p>\n Monitoring for performance and availability Instance Classes<\/p>\n Storage Type<\/p>\n Monitoring<\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" RDS is a Database as a Service (DBaaS) product. It can be used to provision a fully functional database without the admin overhead traditionally associated with DB platforms. It can perform at scale, be made publicly accessible, and can be configured for demanding availability and durability scenarios.<\/p>\n","protected":false},"author":1,"featured_media":2841,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[],"_links":{"self":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/2839"}],"collection":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/comments?post=2839"}],"version-history":[{"count":13,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/2839\/revisions"}],"predecessor-version":[{"id":2865,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/2839\/revisions\/2865"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media\/2841"}],"wp:attachment":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media?parent=2839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/categories?post=2839"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/tags?post=2839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/RDS2.jpg\")
<\/p>\n\n
![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/MultiAZ.jpg\")
<\/p>\n\n
![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/MultiAZ2.jpg\")
<\/p>\n\n
![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/ReadReplicas.jpg\")
<\/p>\n\n
\n
![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/ReadReplica.jpg\")
<\/p>\n\n
\n
![\"\"](\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/FailOver.jpg\")
<\/p>\n\n
\n
\n
\n<\/span><\/p>\n\n
\n
\n
\n
\n
\n
\n