2 ms·
Copied the email we got from Amazon verbatim: ____ Hello Marcus, Hope you are keeping well and safe. Thank you for reaching back out to me. I can completely
by marcus_holmes 3y ago
Copied the email we got from Amazon verbatim:
____
Hello Marcus,
Hope you are keeping well and safe. Thank you for reaching back out to me.
I can completely understand that this is not the behavior you expected with regards to engine version upgrades with multi-AZ configuration.
By design, when performing any version upgrade on a multi-AZ instance, the engine version is upgraded on the primary and the secondary at the same time resulting in both the primary and standby being unavailable. Unfortunately, it is not possible for the instance to failover in this scenario since the database level changes needs to be applied at the same time.
As mentioned in my previously correspondence, you do have the ability to opt-out of auto minor version upgrades if this does not suit your requirements [1]. By doing this, minor version updates will no longer be applied automatically and will have to be manually maintained.
As additional information, note that multi-AZ deployment does reduce the downtime in certain activities, however database engine version upgrade does not come under this. Multi-AZ deployments helps RDS automatically perform a failover in the event of any of the following:
1. An Availability Zone outage
2. The primary DB instance fails
3. The DB instance's server type is changed
4. The operating system of the DB instance is undergoing software patching
5. A manual failover of the DB instance was initiated using Reboot with failover
For more information on High Availability (Multi-AZ) deployments, kindly refer the below document for your reference [2].
I sincerely hope I was able to address your concerns Marcus. Please don't hesitate to reach back out to me and I will be happy to assist further as best I can.
Thank you for your time. Wishing you a great weekend ahead, and stay safe.
References:
[1] Automatically upgrading the minor engine version
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html#USER_UpgradeDBInstance.Upgrading.AutoMinorVersionUpgrades https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
[2] Failover Process for Amazon RDS
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html#Concepts.MultiAZ.Failover http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concep...
We value your feedback. Please share your experience by rating this correspondence using the AWS Support Center link at the end of this correspondence. Each correspondence can also be rated by selecting the stars in top right corner of each correspondence within the AWS Support Center.