A safe MySQL upgrade that wasn't so safe
What happened
I get a notification that my database version has reached end of life, and it has to be upgraded. And the AWS extended support fees are a good motivator to upgrade as soon as possible.
Summary assembled by rule from the sources below