How to deal with AWS RDS maintenance windows

Amazon RDS is one of the best MySQL-based DBaaS service from Amazon AWS. It provides high availability, resizable capacity, and consistent performance to your applications. To take the advantage of the RDS features, we need to design, operate and apply the best practices to RDS to utilize the capability of it to the max extent.
In the last 2 months, we had so many security issues identified in Linux, hypervisors, and MySQL applications that impacted on the Amazon Infrastructure too. To mitigate the security issues, Amazon needs to perform some maintenance activity on the underlying EC2 Instances of RDS MySQL and to patch to the MySQL supported versions. These activities will impact the availability of RDS Instance during the maintenance window.
Amazon is introducing many new features to their existing services to provide top-notch solutions to their customers. Recently, they introduced General Purpose SSD and Provisioned IOPS (SSD) Storage Volumes for RDS instances to deliver fast, predictable, and consistent performance for I/O intensive transactional database workloads. They also introduced other new features like memory-optimized DB Instances, pre-warming InnoDB buffer pool on reboot and even more. Yet again, you need to reboot your RDS instances to take advantage of these new features.
To mitigate the risk of RDS instances unavailability during the maintenance window, some good practices come in handy. Let’s see how to deal with them:
1. Turn on Multi-AZ mode. This is the first and foremost thing to do to improve the availability and enable the built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure or reboot or any maintenance activity.
RDS Maintenance
2. Enable Event Subscriptions to get the notifications of all the Events happening on the RDS instance.
RDS maintenance
 
When you subscribe for the Events, it will deliver the Events details to the given Notification Email IDs.
RDS_Events_Details
3. Enable CloudWatch metrics on RDS Instances to monitor the replication status between the Master and Read-Replicas. Replication may fail because of changes to the master RDS instance or DB Instance shutdown, so it’s good to have this feature on.
4. Verify the RDS DB Instance reachability, memory and number of DB Connections to understand whether it receives connections or not.
5. In Multi-AZ mode, RDS might take some 30 – 300 seconds to switch to the Fail-Over node, so notify the respective stakeholders on the maintenance activity and approximate downtime.
This is the minimum set of things that you should enable to deal with the AWS RDS maintenance and minimize your downtime. Nevertheless, additional hints and best practices should be deployed to further increase both availability and performance of your infrastructure:

  • Read-Replica in Cross-Region: create a read-replica in cross-region to maximize the availability. Whenever primary region outage happens, we can promote the read-replica as the master instance and get the DB instance available all the time.
  • General Purpose (SSD) storage for Consistent Performance: for small and medium database workloads, modify the Storage Type to the General Purpose (SSD) Storage for consistent IOPS delivery for Database operations.
  • Change the Instance type to Current Generation: change the RDS Instance type to Current Generation Instance Types: T2, M3, R3 as per your workload requirements. The newer generation instances will give us the best RAM, CPU and Networking capabilities compared to the previous generation instance types T1, M1, C1, M2, etc.
  • Tune the MySQL Parameters of RDS as you Scale: When you Scale up and Scale down your RDS instance, there will be many parameters depending on your RDS IOPS, Memory, CPU and networking. Tune them accordingly, otherwise it will lead to bad performance of the RDS instances.

Written by

I have strong experience on Multiple Unix/Linux flavours, LAMP Stack, Monitoring Systems, Database, NoSQL. I love to explore the new concepts/services in Cloud Computing World. I have written 4 certifications in different flavours of Linux/Unix.

Related Posts

— November 28, 2018

Two New EC2 Instance Types Announced at AWS re:Invent 2018 – Monday Night Live

Let’s look at what benefits these two new EC2 instance types offer and how these two new instances could be of benefit to you. Both of the new instance types are built on the AWS Nitro System. The AWS Nitro System improves the performance of processing in virtualized environments by...

Read more
  • AWS
  • EC2
  • re:Invent 2018
— November 21, 2018

Google Cloud Certification: Preparation and Prerequisites

Google Cloud Platform (GCP) has evolved from being a niche player to a serious competitor to Amazon Web Services and Microsoft Azure. In 2018, research firm Gartner placed Google in the Leaders quadrant in its Magic Quadrant for Cloud Infrastructure as a Service for the first time. In t...

Read more
  • AWS
  • Azure
  • Google Cloud
Khash Nakhostin
— November 13, 2018

Understanding AWS VPC Egress Filtering Methods

Security in AWS is governed by a shared responsibility model where both vendor and subscriber have various operational responsibilities. AWS assumes responsibility for the underlying infrastructure, hardware, virtualization layer, facilities, and staff while the subscriber organization ...

Read more
  • Aviatrix
  • AWS
  • VPC
— November 10, 2018

S3 FTP: Build a Reliable and Inexpensive FTP Server Using Amazon’s S3

Is it possible to create an S3 FTP file backup/transfer solution, minimizing associated file storage and capacity planning administration headache?FTP (File Transfer Protocol) is a fast and convenient way to transfer large files over the Internet. You might, at some point, have conf...

Read more
  • Amazon S3
  • AWS
— October 18, 2018

Microservices Architecture: Advantages and Drawbacks

Microservices are a way of breaking large software projects into loosely coupled modules, which communicate with each other through simple Application Programming Interfaces (APIs).Microservices have become increasingly popular over the past few years. The modular architectural style,...

Read more
  • AWS
  • Microservices
— October 2, 2018

What Are Best Practices for Tagging AWS Resources?

There are many use cases for tags, but what are the best practices for tagging AWS resources? In order for your organization to effectively manage resources (and your monthly AWS bill), you need to implement and adopt a thoughtful tagging strategy that makes sense for your business. The...

Read more
  • AWS
  • cost optimization
— September 26, 2018

How to Optimize Amazon S3 Performance

Amazon S3 is the most common storage options for many organizations, being object storage it is used for a wide variety of data types, from the smallest objects to huge datasets. All in all, Amazon S3 is a great service to store a wide scope of data types in a highly available and resil...

Read more
  • Amazon S3
  • AWS
— September 18, 2018

How to Optimize Cloud Costs with Spot Instances: New on Cloud Academy

One of the main promises of cloud computing is access to nearly endless capacity. However, it doesn’t come cheap. With the introduction of Spot Instances for Amazon Web Services’ Elastic Compute Cloud (AWS EC2) in 2009, spot instances have been a way for major cloud providers to sell sp...

Read more
  • AWS
  • Azure
  • Google Cloud
— August 23, 2018

What are the Benefits of Machine Learning in the Cloud?

A Comparison of Machine Learning Services on AWS, Azure, and Google CloudArtificial intelligence and machine learning are steadily making their way into enterprise applications in areas such as customer support, fraud detection, and business intelligence. There is every reason to beli...

Read more
  • AWS
  • Azure
  • Google Cloud
  • Machine Learning
— August 17, 2018

How to Use AWS CLI

The AWS Command Line Interface (CLI) is for managing your AWS services from a terminal session on your own client, allowing you to control and configure multiple AWS services.So you’ve been using AWS for awhile and finally feel comfortable clicking your way through all the services....

Read more
  • AWS
Albert Qian
— August 9, 2018

AWS Summit Chicago: New AWS Features Announced

Thousands of cloud practitioners descended on Chicago’s McCormick Place West last week to hear the latest updates around Amazon Web Services (AWS). While a typical hot and humid summer made its presence known outside, attendees inside basked in the comfort of air conditioning to hone th...

Read more
  • AWS
  • AWS Summits
— August 8, 2018

From Monolith to Serverless – The Evolving Cloudscape of Compute

Containers can help fragment monoliths into logical, easier to use workloads. The AWS Summit New York was held on July 17 and Cloud Academy sponsored my trip to the event. As someone who covers enterprise cloud technologies and services, the recent Amazon Web Services event was an insig...

Read more
  • AWS
  • AWS Summits
  • Containers
  • DevOps
  • serverless