<div dir="ltr" style="text-align: left;"><span style="background-color: white; color: #777777; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.7999992370605px;">Migrating from an on-premises, self- hosted SQL database to AWS Relational Database (RDS) can be scary business. ;</span><span style="background-color: white; color: #777777; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.7999992370605px;">Migrating to AWS RDS is a chance to not only take care of issues your dealing with today, but also to plan for issues you anticipate.</span></p>
<ol start="3" style="background-color: white; color: #777777; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.7999992370605px; list-style-type: none; margin: 5px 0px 10px 20px; padding: 5px 0px 0px;">
<li style="list-style-type: decimal; margin: 0px; padding: 3px 0px;"><strong style="color: #333333;">Choose your RDS features</strong>Once steps 1 and 2 are completed, you can decide which AWS RDS features best suit your needs.Check out the table below to analyze your individual needs:
<div style="padding: 0.5em 0px;"></div>
<table style="margin: 0px; padding: 0px; width: auto;">
<tbody>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;"><strong style="color: #333333;">Problem Area</strong></td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;"><strong style="color: #333333;">AWS RDS Feature</strong></td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;"><strong style="color: #333333;">Description</strong></td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;"><strong style="color: #333333;">Checklist</strong></td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">DR &; HA</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS Multi-AZ</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Enable the Multi AZ feature for production databases to provide a synchronous “standby” replica of every database in a different availability zone. if one of the zones in a region goes down, RDS will serve your database requests from another zone. Since both the database and its replica are in sync, data loss is impossible.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Decide whether or not you need HA. Though it may be pricey, your production system could require it.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">If you are not using Multi-AZ, be sure to plan maintenance procedures carefully so as to prevent downtime and latency.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Backup &; Restore</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS Snapshot &; Point in Time Backup</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">RPO and RTO are critical factors for any HA system, and require appropriate backup and restore operations. AWS RDS provides two distinct backup mechanisms that can restore data from either a specific point in time (snapshot) or up to the last 5 minutes of operations (automated backup).</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Select an RTP &; RTO.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">If automated backup does not meet your requirements, plan on setting up frequent snapshots as well as HA with Multi AZ.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Plan your snapshots when data is stable.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">Security</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">VPC, Security Group, SSL</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Security is key when you are migrating to cloud-based databases. Thankfully, AWS provides VPC, which launches databases in private subnets for secure access.RDS also supports SSL and AWS provides a virtual firewall with security groups.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Be sure to set up VPC for secure database access.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Choose which IPs (application / organization access) to connect to RDS.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Open ports in the appropriate security groups.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">If needed, set up ;<a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.SSLSupport" style="color: #153860; text-decoration: none;">SSL</a> ;for RDS.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Monitoring</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">CloudWatch</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS provides multiple metrics for monitoring with Cloudwatch.Using AWS SNS with Cloudwatch provides you with alert notifications.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Set up alarms and notifications for metrics, such as high CPU utilization, low disk space, and high database connections.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Leverage AWS database event notifications to get alerts on certain RDS events, such as backup, availability, configuration changes and many more.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Access Control</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">IAM with RDS</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Identity and access management (IAM) allows segregation of duties and it’s an important way to enforce security.If you want to create policies to limit AWS RDS access, create IAM users/groups and define respective policies.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Calculate the amount of users that will access RDS.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Verify the types of access that will be needed.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Create a policy for each type of access.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Audit Trail</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS CloudTrail</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS CloudTrail logs all API calls to AWS RDS.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Decide where to store API logs.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Review the CloudTrail log format to analyze your data.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Performance</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">IOPS, Instance Sizes</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Production databases constantly require faster performance with lower latency. Therefore, RDS provides configured IOPS rates and storage for the lifetime of your DB instance.RDS instance sizes also have varying performance. Larger sizes yield better I/O, which translates into higher throughput and lower latency.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Decide on an appropriate instance size based on your workload.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Select a disk size.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Choose an application load, database size and database page size.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Based on the steps above, select an adequate number of IOPS.</li>
</ul>
<div style="padding: 0.5em 0px;"></div>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Scaling</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Read Replica + Data Partitioning with ScaleBase</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Web scale is one of the core challenges for cloud databases these days. With RDS, it is easy to scale up (vertical scaling) but not easy to scale out (horizontal scaling).If you only have read only requests, you can use Read Replicas to scale out. However real database scale can only be achieved by horizontally scaling out (sometimes called sharding) the database.If you decide to scale out on your own, you need to factor in test and shard code management overhead. An easier option is to leverage ScalaBase AWS software. It automatically partitions your data without any modification to your apps. ; And each partition can still have read-replicas associated with it.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Identify if you need a read only DB.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Create read replicas in separate regions/zones.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">The best option is to use ScaleBase (<a href="https://aws.amazon.com/marketplace/pp/B00KZ0U7DA/ref=sp_mpg_product_title?ie=UTF8&;sr=0-2" style="color: #153860; text-decoration: none;" target="_blank">on AWS Marketplace</a>) to manage elasticity and automated scale out a single RDS database instance into multiple database instances that work together to act as a single database. ;Learn more.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Cost</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Reserved Instances</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Cost optimization influences every company. Consequently, RDS provides reserved instances to help lower costs.Note: if you partition your database (see Scaling above), you can use smaller and less expensive instances working together to obtain more compute power than is available from a single larger (and more expensive) instance.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Select a utilization period for your RIs (i.e. 1 year, 3 years, etc…). Be sure to keep the cost optimization factor in mind.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">DB Engine Configuration</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS RDS Parameter Group</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">The AWS RDS parameter group allows you to perform DB engine configurations. Think of it like a container for your database engine that can be applied to one or more RDS database instances. Note that AWS does not allow changes to be made to all parameters.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">RDS has a default parameter group created for database engines. If needed, you can modify many of the parameters, such as “max_allowed_packet”, “log-error” and many more.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Remember that the default RDS parameter group is set for optimized database performance. If you do not modify it correctly, it may result in lowered database performance.</li>
</ul>
</td>
</tr>
<tr>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-left-color: rgb(238, 238, 238); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">Caching</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">AWS RDS Option Group</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px;">You can use an option group based on your engine’s configuration. Option settings control the behavior of an option. For example, Amazon RDS supports using the memcached interface with InnoDB tables. MySQL 5.6 introduced a plugin that implements a daemon service which exposes the data from InnoDB tables through the<a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.html" style="color: #153860; text-decoration: none;" target="_blank">memcached protocol</a>.  ;It serves as an in-memory caching layer.The memcached API enables applications to use InnoDB tables in a manner similar to NoSQL key-value data stores.</td>
<td style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; border-right-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; color: #777777; padding: 4px; text-align: center;">
<ul style="list-style-type: none; margin: 0px 0px 10px; padding: 5px 0px 0px;">
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">Here if you are ;<a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.Options.html" style="color: #153860; text-decoration: none;" target="_blank">adding the memcached option group</a> ;for RDS, you need to decide which columns in your MySQL tables can be accessed through the memcached interface.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">The memcached plugin creates a catalog table named ‘containers’ in a dedicated database named ‘Innodb_memcache’.</li>
<li style="list-style-position: outside; list-style-type: decimal; margin: 0px 0px 0px 17px; padding: 3px 0px; text-align: left;">You can insert a row into the ‘containers’ table to map an InnoDB table to access through memcached.</li>
</ul>
</td>
</tr>
</tbody>
</table>
<div style="padding: 0.5em 0px;">Once all of the above ;factors are considered, launch an RDS database instance based on your selected configurations and parameters. I<span style="line-height: 23.7999992370605px;">mport data from your on-premises SQL database to your RDS instance.</span></div>
</li>
</ol>
</div>

The Cyber Security, Compliance & Cloud
Cyber Security | Digital Transformation | Cloud Computing
