• English
    • Deutsch (German)
    • Français (French)
    • Italiano (Italian)
    • 日本語 (Japanese)
  • Support
  • Login
  • Search
  • Solutions
    • Overview
    • Financial ManagementAnalyze, optimize, & plan technology spend
    • Cloud & HybridOptimize cost & utilization of multi-cloud & on-premises
    • Apps & ServicesRationalize portfolio & invest for growth
    • Vendors & SuppliersGovern your technology vendor portfolio
    • Agile & ProjectsTrack & prioritize investments for value
    • Business ValueShape business demand & recover costs
    • Public Sector ITAlign resources to reduce risk & maximize mission objectives
  • Products
        • PRODUCTS
        • ITFM FoundationAutomate IT financial planning & analysis
        • CloudabilityAllocate & optimize cloud resources
        • Cloudability SaaSIdentify SaaS apps to optimize costs and manage risk
        • Cost TransparencyAggregate & normalize IT cost, performance & utilization
        • Agile Investment ManagementPlan, track, and forecast investments for Agile delivery
        • All Products >
          • Bill of IT
          • Hybrid Business Management
          • IT Benchmarking
          • IT Planning Foundation
          • Vendor Insights
          • Project Financial Planning
        • Platform
        • DatalinkIngest & structure data from over 350 source systems
        • Apptio TBM Unified ModelEmploy best practices for data sources, allocations & KPIs
        • InsightsSurface actionable insights & opportunities hidden in your data
        • Self-Service ReportingUnlock information and share reports across your organization
        • Comments & CollaborationDrive clarity with rich context without leaving the system
        • Action PlansSet, track, & monitor progress toward goals & objectives
  • Resources
        • Overview
        • Testimonials
        • Resource Center
        • Blog
        • Community
        • Support
        • Professional Services
        • Events & Webinars
  • Company
        • Overview
        • Careers
        • Leadership
        • Technology Business Management
        • Trust
        • Partners
        • News
        • Locations
  • Get Started
  • Search
  • Support
  • Login
  • English (English)
    • Deutsch (German)
    • Français (French)
    • Italiano (Italian)
    • 日本語 (Japanese)
Get Started
Apptio Blog

7 Simple Steps To Reduce AWS RDS Spend

  • The Team at Apptio
  • February 14, 2018

Amazon Relational Database Services (RDS) enables any service to access a maintenance-free elastic relational database—at least maintenance-free from a user’s perspective. Minimal up-front engineering effort to use a relational database service does come with a cost.

RDS costs are a composite of EC2 compute, EBS data storage, IO, and outbound data transfers. These costs are measured by provisioned capacity and (in some cases) by consumed capacity (e.g., provision a,

On-demand monthly cost for a db.r3.4xlarge RDS instance running MySQL provisioned with 1000GB of gp2 storage would be $1494.70 ($1379.70 for db.r3.4xlarge instance + $115 storage). This is a minimum cost. Data transfers out of RDS add additional cost—as do backups. AWS charges customers for the provisioned capacity. It is your responsibility to optimize what you have paid for.

Customers may monitor RDS utilization information using AWS console and right-size RDS instances and attached storage. Alternatively, customers may use third party tools such as Apptio Cloudability to automate the entire process of monitoring and taking actions to keep RDS instances optimized all the time.

Other simple steps to manage RDS costs:

1. Architectural Assessment:

RDS offers great benefits of relational data models and convenient SQL queries. However, it is a relatively expensive way for storing data. Do an architecture assessment to make sure that a project really needs RDS. Use an e-commerce project as an example, RDS is appropriate for sales transaction data due to its ACID property. On the other hand, product descriptions and pictures could be stored in cheaper storage systems such as S3.

2. Proof of Concept:

Do a small pilot project to try out different instance types and collect database usage patterns. When selecting an instance type, consider that a service workload may fluctuate during a day, on different day of a week, and throughout a year. There is no need to overprovision the instance based on unreliable workload predictions. There are always opportunities to switch instance types. Be aware that instance type switching requires downtime.

3. Data Lifecycle Planning:

Create a data lifecycle management policy. For data that are not accessed for a while, have an automation tool to move them off RDS to a less costly storage service such as S3. Sometimes the raw is not needed after they are processed. For example, after monthly business reports are generated and stored in S3, the original data on RDS may no longer needed and can be removed from RDS. Company data retention policy also impacts how long data need to be kept in RDS.

4. Avoid Data Dump:

Due to widespread knowledge of SQL and convenience of using RDS, resist the temptation of using it as a data dump. Set up a policy and train developers so that only data that need to be in RDS are stored in it. Review the schema periodically and optimize it for RDS.

5. SQL Optimization:

Carefully design SQL queries to minimize the number of requests needed to generate a result. For example, instead of making multiple requests to produce a daily sales report, use SQL join or stored procedure to generate a sales table in one request.

6. Cache Data:

Use a cache to reduce RDS load and data transfer cost. You may use AWS ElastiCache or your own cache mechanism. Adding a cache layer increases the complexity of your project. However, in the long run, cost saving as well as service performance could prove the benefit is well worth the effort.

7. Smooth Operations:

For planned workload, smooth out RDS utilizations in the span of the workload. Typical provisions of RDS need to meet the peak workload requirements. Reducing peaks and valleys of workloads allows optimal provisions of RDS instance types.

Although following these steps seem to be a lot of work, they are already often taken for on-promise projects. The benefit of these steps may be vague for on-promise projects. But they are obvious in AWS when the monthly bill comes in.

Sometimes, simple housekeeping could reduce monthly AWS bill significantly. Apptio offers advanced machine learning driven RDS Optimization. Apptio customers automatically detect unused and under-utilized RDS instances and suggest corrective actions or schedules for utilization.

Editor's note: This post was originally published on the now retired FittedCloud blog (January 2018).

Download 4 steps to successfully monitor and optimize hybrid IT

A hybrid IT approach offers the best of both on-premises and public cloud by keeping costs and risk low while increasing efficiency and speed. But monitoring and optimizing hybrid environments is complicated.

Apptio® Cloudability provides cost and resource optimization capabilities across all leading public cloud providers (AWS, Azure and Google Cloud) so IT leaders can increase the efficiency of public cloud spending and slash waste from over-purchase and underuse. Try Apptio Cloudability for free.

Article Contents

Categories

  • Cloud
  • Cost Optimization

Tags

  • AWS
Get Started

See These Related Items:

02/23/2018
  • Blog: Cloud

A Simple script to implement AWS EC2 TTL (Time to Live)

The Team at Apptio
Read the Article
11/29/2018
  • Blog: TBM

TBM: To Disrupt, or Be Disrupted?

Manik Patil
Read the Article
11/08/2018
  • Blog: Cloud

Making the Most of Your Cloud Infrastructure

Scott Koegler
Read the Article

Get Started

Whether you need help analyzing the true cost of the cloud, optimizing your technology spend, or communicating IT’s value to the business, Apptio can help.

Find a Solution

Request a Demo

Join an Event

Ask a Question

Apptio
Twitter
Linkedin-in
Envelope
  • Solutions
    • Overview
    • Financial Management
    • Cloud & Hybrid
    • Apps & Services
    • Vendors & Suppliers
    • Agile & Projects
    • Business Value
    • Public Sector IT
  • Products
    • PRODUCTS
    • ITFM Foundation
    • Cloudability
    • Cloudability SaaS
    • Cost Transparency
    • Agile Investment Management
    • All Products >
      • Bill of IT
      • Hybrid Business Management
      • IT Benchmarking
      • IT Planning Foundation
      • Vendor Insights
      • Project Financial Planning
    • Platform
    • Datalink
    • Apptio TBM Unified Model
    • Insights
    • Self-Service Reporting
    • Comments & Collaboration
    • Action Plans
  • Resources
    • Overview
    • Testimonials
    • Resource Center
    • Blog
    • Community
    • Support
    • Professional Services
    • Events & Webinars
  • Company
    • Overview
    • Careers
    • Leadership
    • Technology Business Management
    • Trust
    • Partners
    • News
    • Locations
  • Get Started
  • Search
  • Support
  • Login
  • English (English)
    • Deutsch (German)
    • Français (French)
    • Italiano (Italian)
    • 日本語 (Japanese)
Founder and Technical Advisor to the TBM Council

© 2007-2021 Apptio, Inc. All rights reserved. |  Privacy Policy | Modern Slavery Act Statement