Can I control if and when MySQL based RDS Instance is upgraded to new supported versions?
A.
No
B.
Only in VPC
C.
Yes
when MySQL based RDS Instance is upgraded to new supported versions?
Can I control if and when MySQL based RDS Instance is upgraded to new supported versions?
Yes. Of course.
for managed databases you cant
A:
Q: Does Amazon RDS provide guidelines for support of new database engine versions, and for deprecating database engine versions that are currently supported?
This statement applies to Amazon RDS for Amazon Aurora, MySQL, MariaDB, Oracle, SQL Server, and PostgreSQL.
Over time, we plan to support additional database versions, both minor and major, for Amazon RDS’s engines. The number of new version releases supported in a given year will vary based on the frequency and content of releases and patches from the engine’s vendor or core team, and the outcome of a thorough vetting of these releases and patches by our database engineering team. However, as a general guidance, we aim to support new engine versions within 3-5 months of their general availability.
Here is a general statement of Amazon RDS’s deprecation policy:
We intend to support major version releases (e.g., MySQL 5.6) for at least 3 years after they are initially supported by Amazon RDS.
We intend to support minor versions (e.g., MySQL 5.6.21) for at least 1 year after they are initially supported by Amazon RDS.
From time to time, we will deprecate major or minor versions. We expect to provide a three-month grace period after the announcement of a deprecation for you to initiate an upgrade to a supported version. At the end of this grace period, an automatic upgrade will be applied to any un-upgraded instances during their scheduled maintenance windows.
While we strive to meet these guidelines, in some cases we may deprecate specific major or minor versions sooner, such as when there are security issues.
A you can’t control it. AWS do.
A
Q: Does Amazon RDS provide guidelines for support of new database engine versions, and for deprecating database engine versions that are currently supported?
…
From time to time, we will deprecate major or minor versions. We expect to provide a three-month grace period after the announcement of a deprecation for you to initiate an upgrade to a supported version. At the end of this grace period, an automatic upgrade will be applied to any un-upgraded instances during their scheduled maintenance windows.
…
C
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html
With Amazon RDS, you control when to upgrade your MySQL instance to a new version supported by Amazon RDS. You can maintain compatibility with specific MySQL versions, test new versions with your application before deploying in production, and perform version upgrades at times that best fit your schedule.
Unless you specify otherwise, your DB instance will automatically be upgraded to new MySQL minor versions as they are supported by Amazon RDS. This patching will occur during your scheduled maintenance window, and it will be announced on the Amazon RDS Community Forum in advance. To turn off automatic version upgrades, set the AutoMinorVersionUpgrade parameter to “false.”
C
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html
As a result, Amazon RDS doesn’t apply major version upgrades automatically; you must modify your DB instance manually to perform a major version upgrade.
When a new patch version of the Amazon Aurora database engine is released, no automatic upgrade is required. You can choose to upgrade and apply the patch, otherwise the patch will be applied during the next automatic upgrade for a minor version release.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Aurora.DatabaseEngineUpdates.html
C is correct
Opting for C here based on following.
https://aws.amazon.com/blogs/aws/amazon-rds-mysql-upgrade-and-version-management/
With DB Engine Version Management, Amazon RDS gives you additional (yet optional) control over the version of relational database software (i.e. MySQL) powering your DB Instance. The goal of this functionality is to provide you the flexibility to maintain compatibility with specific MySQL versions, test new versions with your application before deploying in production, and perform version upgrades on your own terms and timelines.
Automatic Upgrade Schedule
C.
Yes
To manually upgrade a database instance to a supported engine version, use the Modify DB Instance command on the AWS Management Console or the ModifyDBInstance API and set the DB Engine Version parameter to the desired version. By default, the upgrade will be applied or during your next maintenance window. You can also choose to upgrade immediately by selecting the Apply Immediately option in the console API.
What is the correct answer ?
If you remove the “if” – than it is C. otherwise it is A