This Guidance demonstrates how you can optimize costs for applications that access Amazon Relational Database Service (Amazon RDS) for MySQL databases. It uses an in-memory data store to reduce the database load for read-heavy workloads. By caching frequently accessed query results in this high-performance data store, your applications can retrieve data faster, allowing you to reduce the provisioned capacity needed for the Amazon RDS database instance, thereby lowering overall costs.

Please note: [Disclaimer]

Architecture Diagram

[Architecture diagram description]

Download the architecture diagram PDF 

Get Started

Deploy this Guidance

Well-Architected Pillars

The AWS Well-Architected Framework helps you understand the pros and cons of the decisions you make when building systems in the cloud. The six pillars of the Framework allow you to learn architectural best practices for designing and operating reliable, secure, efficient, cost-effective, and sustainable systems. Using the AWS Well-Architected Tool, available at no charge in the AWS Management Console, you can review your workloads against these best practices by answering a set of questions for each pillar.

The architecture diagram above is an example of a Solution created with Well-Architected best practices in mind. To be fully Well-Architected, you should follow as many Well-Architected best practices as possible.

  • You can optimize your operations by taking advantage of the fast query retrieval capabilities and the in-memory data store of ElastiCache. Also, by offloading repetitive queries from Amazon RDS to ElastiCache, you can free up resources for additional workloads, allowing your applications to respond swiftly to user demands while delivering a seamless and responsive experience. This powerful combination of data retrieval for ElastiCache and the robust database capabilities of Amazon RDS helps ensure that your applications can handle high traffic and demanding workloads without compromising on performance or user experience.

    Read the Operational Excellence whitepaper 

  • Safeguard your data with ElastiCache and Amazon RDS for MySQL. These services offer robust security features, so your sensitive information remains protected. ElastiCache supports encryption in transit and at rest, with your data encrypted both during transmission and while stored. Additionally, ElastiCache is compliant with industry-leading security standards such as the Federal Risk and Authorization Management Program (FedRAMP), Service Organization Control (SOC), and the Health Insurance Portability and Accountability Act (HIPAA).

    Read the Security whitepaper 

  • In the event of disruptions to Amazon RDS, ElastiCache can serve as an additional source of data, providing a reliable fallback until Amazon RDS resumes normal operations. Also, with the high-performance data retrieval capabilities of ElastiCache, your applications remain available and responsive, even during unexpected events.

    Read the Reliability whitepaper 

  • ElastiCache can serve query results in sub-millisecond timeframes, outperforming traditional database caching, making it the ideal choice for workloads where speed of data retrieval is paramount. Moreover, ElastiCache is highly scalable, allowing you to seamlessly scale your in-memory data store to handle increasing traffic and data volumes without compromising performance. It supports consistent low-latency data retrieval even under heavy loads, including large datasets.

    Read the Performance Efficiency whitepaper 

  • ElastiCache delivers a cost-effective caching solution by eliminating the need for additional hardware and storage resources, offering a significantly lower cost model compared to traditional database caching. By replacing Amazon RDS read replicas with ElastiCache, you can achieve substantial cost savings without compromising performance. Furthermore, ElastiCache provides flexible pricing options, including instance-based and serverless models, allowing you to align your costs with your evolving business requirements.

    Read the Cost Optimization whitepaper 

  • ElastiCache and Amazon RDS for MySQL help you achieve high performance with an optimized hardware footprint, reducing energy consumption and environmental impact. These AWS services allow you to attain the same or better performance levels while utilizing fewer physical resources for powering and cooling your data storage environments. By minimizing the infrastructure overhead, you can contribute to a more sustainable future for your business and the planet without compromising on scalability or performance.

    Read the Sustainability whitepaper 

Related Content

Blog

Optimize cost and boost performance of RDS for MySQL using Amazon ElastiCache for Redis

This blog post demonstrates how you can optimize your relational database costs with in-memory caching using Amazon ElastiCache.

Disclaimer

The sample code; software libraries; command line tools; proofs of concept; templates; or other related technology (including any of the foregoing that are provided by our personnel) is provided to you as AWS Content under the AWS Customer Agreement, or the relevant written agreement between you and AWS (whichever applies). You should not use this AWS Content in your production accounts, or on production or other critical data. You are responsible for testing, securing, and optimizing the AWS Content, such as sample code, as appropriate for production grade use based on your specific quality control practices and standards. Deploying AWS Content may incur AWS charges for creating or using AWS chargeable resources, such as running Amazon EC2 instances or using Amazon S3 storage.

References to third-party services or organizations in this Guidance do not imply an endorsement, sponsorship, or affiliation between Amazon or AWS and the third party. Guidance from AWS is a technical starting point, and you can customize your integration with third-party services when you deploy the architecture.

Was this page helpful?

 Feedback