How to Automate Minor Version Upgrades for MySQL on RDS

Amazon RDS for MySQL offers the option to automate minor version upgrades using the minor version upgrade policy, a property that lets you decide if Amazon is allowed to perform the upgrades on your behalf. Usually the goal is not to upgrade automatically every RDS instance but to keep up to date automatically non-production deployments. This helps you address engine issues as soon as possible and improve the automation of the deployment process.

If your are using the AWS Command Line Interface (CLI) and you have an instance called test-rds01 it is as simple as changing

[--auto-minor-version-upgrade | --no-auto-minor-version-upgrade]

For example:

aws rds modify-db-instance --db-instance-identifier test-rds01 --apply-immediately
--auto-minor-version-upgrade true

And if you use the AWS Management Console, it is just a check box.  All sorted? Unfortunately not. The main problem is that Amazon performs those upgrade only in rare circumstances.

As for Amazon’s documentation:

Minor version upgrades only occur automatically if a minor upgrade replaces an unsafe version, such as a minor upgrade that contains bug fixes for a previous version. In all other cases, you must modify the DB instance manually to perform a minor version upgrade.

If the new version fixes any vulnerabilities that were present in the previous version, then the auto minor version upgrade will automatically take place during the next weekly maintenance window on your DB instance. In all other cases, you should manually perform the minor version upgrade. So in most scenarios, the automatic upgrade is unlikely to happen and using the

auto-minor-version-upgrade
  attribute is not the way to keep your MySQL running on RDS updated to the latest available minor version.

How to improve automation of minor version upgrades Amazon RDS for MySQL

Let’s say you want to reduce the time a newer minor version reaches your development environments or even your production ones. How can you achieve that on RDS? First of all you have to consider the delay it takes for a minor version to reach RDS that can be anything between a few weeks and a few months.  And you might even not notice that a new minor is available as it is not obvious how to be notified when it is.

What is the best way to be notified of new minor versions available on RDS MySQL?

In the past you could (even automatically) monitor the release notes page but the page is not anymore used for RDS. Now you have to monitor the database announcement page, something that you can hardly automate.

Any way to speed up the minor version upgrades?

You can use the AWS CLI invoking the describe-db-engine-versions API or write a simple Lambda function to retrieve the latest available minor version and act accordingly: you can, for example, notify your team of DBAs using Amazon Simple Notification Service (SNS) or you can automatically upgrade the instance. Let’s first see how to achieve that using the command line:

aws --profile sandbox rds describe-db-engine-versions --engine 'mysql' --engine-version '5.7'
--query "DBEngineVersions[-1].EngineVersion"

where the -1 in the array let you filter out the very latest version of the engine available on RDS. Today the result is “5.7.21” and a simple cron job will monitor and can trigger notification for changes. Note that the same approach can be used to retrieve the latest available minor version for engines running MySQL 5.5 and MySQL 5.6. And PostgreSQL engines too.

If you want to automatically and immediately upgrade your instance, the logic can be easily done in a few lines in bash with a cron on a EC2. For example, the following function requires only the database instance identifier:

rds_minor_upgrade() {
  rds_endpoint=$1
  engine_version="5.7"
  rds_current_minor=$(aws rds describe-db-instances
     --db-instance-identifier="$rds_endpoint" --query "DBInstances[].EngineVersion")
  rds_latest_minor=$(aws rds describe-db-engine-versions -- engine 'mysql'
      --engine-version $eng_version --query "DBEngineVersions[-1].EngineVersion")
  if [ "$rds_latest_minor" != "$rds_current_minor" ]; then
    aws rds modify-db-instance --apply-immediately --engine-version
      $rds_latest_minor --db-instance-identifier $rds_endpoint
  fi
}

Alternatively you can write the code as a scheduled Lambda function in your favourite language. For example, using the AWS node.js SDK you can manage RDS and implement the logic above using the rds.describeDBEngineVersions andrds.modifyDBInstance to achieve the same.

(...)
rds.describeDBEngineVersions(params, function(err, data) {
(...)
});
(...)
var params = {
DBInstanceIdentifier: 'test-rds01',
ApplyImmediately: true,
EngineVersion: '<new minor version>',
(...)
};
rds.modifyDBInstance(params, function(err, data) {
(...)
});

Speed up your minor upgrade!

To summarize, Amazon Web Services does not offer a real way to automatically upgrade a RDS instance to the latest available minor in the most common scenarios, but it is very easy to achieve that by taking advantage of the AWS CLI or the many SDKs.

The goal is not to upgrade automatically every deployment. You would not normally use this for production deployments. However, being able to monitor the latest available minor version on RDS and apply the changes automatically for development and staging deployment can significantly reduce the time it takes to have MySQL up to date on RDS and make your upgrade process more automated.

upgrade minor versions MySQL Amazon RDS

 

The post How to Automate Minor Version Upgrades for MySQL on RDS appeared first on Percona Community Blog.

关注dbDao.com的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569