<div dir="auto">You have to modify the cluster. Take an outage. Then it comes back. Generally I'd agree 10 min is easy enough but with two weeks to the show the site sees constant traffic </div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 24, 2023, 2:23 PM Phil Dibowitz <<a href="mailto:phil@ipom.com">phil@ipom.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Oh that explains a lot. I keep answering you, LOL. Lets get you on the <br>
list, ffs.<br>
<br>
As I mentioned to you once off list and a few times you wouldn't have <br>
seen onlist, the site has been tested on newer versions of MySQL so I'm <br>
not worried.<br>
<br>
A 10-minute outage doesn't seem like a huge deal to me, given our site <br>
traffic. It also doesn't seem to matter much to me if its 2/24 or 3/1. <br>
However I've been hoping to find a time when Philip will be around in <br>
case there's some weird unexpected incompatibility.<br>
<br>
As it stands my plan was to hit him up when I get back from the DMV this <br>
afternoon and then spend 10 minutes finding the button, hit it, and then <br>
poke around when it was done.<br>
<br>
I'm not super familiar with RDS, but I figure I can hit the 'migrate' <br>
button.<br>
<br>
If the 10 minutes bothers you and you'd rather do the clone-and-cut-over <br>
process, let me know and I can hand it off to you. I'm not even sure <br>
where to update the DB info in the PHP and stuff.<br>
<br>
<br>
On 2/24/23 01:35, Ilan Rabinovitch wrote:<br>
> (as a non-list member I dont get replies if you're not replying to me as <br>
> well)<br>
> <br>
> the upgrade will resulted in a 10 minute outage for reg.<br>
> <br>
> The way to work around it is clone the DB and cut over seems to be spin <br>
> up a new cluster thats upgraded, cut over, kill old cluster.<br>
> <br>
> On Fri, Feb 24, 2023 at 4:31 AM Ilan Rabinovitch <<a href="mailto:ilan@linuxfests.org" target="_blank" rel="noreferrer">ilan@linuxfests.org</a> <br>
> <mailto:<a href="mailto:ilan@linuxfests.org" target="_blank" rel="noreferrer">ilan@linuxfests.org</a>>> wrote:<br>
> <br>
> <br>
> <br>
> We really dont want the website down during or leading up to SCALE.<br>
> <br>
> Let me know if I need to grab this.<br>
> <br>
> ---------- Forwarded message ---------<br>
> From: *Amazon Web Services, Inc.* <<a href="mailto:no-reply-aws@amazon.com" target="_blank" rel="noreferrer">no-reply-aws@amazon.com</a><br>
> <mailto:<a href="mailto:no-reply-aws@amazon.com" target="_blank" rel="noreferrer">no-reply-aws@amazon.com</a>>><br>
> Date: Fri, Feb 24, 2023 at 4:29 AM<br>
> Subject: Amazon Aurora MySQL 1 (with MySQL 5.6 compatibility) will<br>
> reach end of life on February 28, 2023 [AWS Account: 355993445259]<br>
> [US-EAST-1]<br>
> To: <<a href="mailto:ilan@linuxfests.org" target="_blank" rel="noreferrer">ilan@linuxfests.org</a> <mailto:<a href="mailto:ilan@linuxfests.org" target="_blank" rel="noreferrer">ilan@linuxfests.org</a>>><br>
> <br>
> <br>
> Hello,<br>
> <br>
> You are receiving this message because you have one or more Amazon<br>
> Aurora MySQL clusters running a version of Aurora MySQL 1 (with<br>
> MySQL 5.6 compatibility) in the US-EAST-1 Region.<br>
> <br>
> Amazon Aurora MySQL 1 (with MySQL 5.6 compatibility) will reach end<br>
> of life on February 28, 2023. We are providing you with a one week<br>
> notice so you have sufficient time to upgrade your database<br>
> cluster(s). You can find additional information needed to plan your<br>
> upgrade including a detailed timeline with milestones in the<br>
> 'Preparing for Amazon Aurora MySQL-Compatible Edition version 1 end<br>
> of life' documentation [1].<br>
> <br>
> Clusters that are running these deprecated engine versions after<br>
> March 1, 2023 will be upgraded on your behalf within a maintenance<br>
> window after March 1, 2023. The major version upgrade will start<br>
> within your maintenance window and typically finish within that<br>
> timeframe. Depending on the cluster and the database activity at the<br>
> time, the upgrade process may extend beyond the maintenance window.<br>
> For more information, please refer to the Amazon RDS maintenance<br>
> window [2].<br>
> <br>
> The clusters we identified as affected are listed in your 'Affected<br>
> resources' tab of your AWS Health Dashboard. You may also find<br>
> clusters affected by this deprecation notice by utilizing the<br>
> 'Finding clusters affected by this end-of-life process' guide [3].<br>
> <br>
> Should you have any questions or concerns, the AWS Support Team is<br>
> available on re:Post [4] and via Premium Support [5].<br>
> <br>
> [1]<br>
> <a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html</a> <<a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html</a>><br>
> [2]<br>
> <a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.Maintenance.html#Concepts.DBMaintenance" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.Maintenance.html#Concepts.DBMaintenance</a> <<a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.Maintenance.html#Concepts.DBMaintenance" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.Maintenance.html#Concepts.DBMaintenance</a>><br>
> [3]<br>
> <a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html#find-cluster" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html#find-cluster</a> <<a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html#find-cluster" rel="noreferrer noreferrer" target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.MySQL56.EOL.html#find-cluster</a>><br>
> [4] <a href="https://repost.aws/" rel="noreferrer noreferrer" target="_blank">https://repost.aws/</a> <<a href="https://repost.aws/" rel="noreferrer noreferrer" target="_blank">https://repost.aws/</a>><br>
> [5] <a href="https://aws.amazon.com/support" rel="noreferrer noreferrer" target="_blank">https://aws.amazon.com/support</a> <<a href="https://aws.amazon.com/support" rel="noreferrer noreferrer" target="_blank">https://aws.amazon.com/support</a>><br>
> <br>
> Sincerely,<br>
> Amazon Web Services<br>
> <br>
> Amazon Web Services, Inc. is a subsidiary of Amazon.com, Inc.<br>
> Amazon.com is a registered trademark of Amazon.com, Inc. This<br>
> message was produced and distributed by Amazon Web Services Inc.,<br>
> 410 Terry Ave. North, Seattle, WA 98109-5210<br>
> <br>
> ---<br>
> Reference:<br>
> <a href="https://phd.aws.amazon.com/phd/home?region=us-east-1#/event-log?eventID=arn:aws:health:us-east-1::event/RDS/AWS_RDS_OPERATIONAL_NOTIFICATION/AWS_RDS_OPERATIONAL_NOTIFICATION_a6c3c27c8fa9a17b4966661b72fa8534d37f3090b2ca1b5040c2ff611f27a90f&eventTab=details" rel="noreferrer noreferrer" target="_blank">https://phd.aws.amazon.com/phd/home?region=us-east-1#/event-log?eventID=arn:aws:health:us-east-1::event/RDS/AWS_RDS_OPERATIONAL_NOTIFICATION/AWS_RDS_OPERATIONAL_NOTIFICATION_a6c3c27c8fa9a17b4966661b72fa8534d37f3090b2ca1b5040c2ff611f27a90f&eventTab=details</a> <<a href="https://phd.aws.amazon.com/phd/home?region=us-east-1#/event-log?eventID=arn:aws:health:us-east-1::event/RDS/AWS_RDS_OPERATIONAL_NOTIFICATION/AWS_RDS_OPERATIONAL_NOTIFICATION_a6c3c27c8fa9a17b4966661b72fa8534d37f3090b2ca1b5040c2ff611f27a90f&eventTab=details" rel="noreferrer noreferrer" target="_blank">https://phd.aws.amazon.com/phd/home?region=us-east-1#/event-log?eventID=arn:aws:health:us-east-1::event/RDS/AWS_RDS_OPERATIONAL_NOTIFICATION/AWS_RDS_OPERATIONAL_NOTIFICATION_a6c3c27c8fa9a17b4966661b72fa8534d37f3090b2ca1b5040c2ff611f27a90f&eventTab=details</a>><br>
> <br>
> <br>
> _______________________________________________<br>
> scale-infra mailing list<br>
> <a href="mailto:scale-infra@lists.linuxfests.org" target="_blank" rel="noreferrer">scale-infra@lists.linuxfests.org</a><br>
> <a href="https://lists.linuxfests.org/cgi-bin/mailman/listinfo/scale-infra" rel="noreferrer noreferrer" target="_blank">https://lists.linuxfests.org/cgi-bin/mailman/listinfo/scale-infra</a><br>
<br>
-- <br>
Phil Dibowitz <a href="mailto:phil@ipom.com" target="_blank" rel="noreferrer">phil@ipom.com</a><br>
Open Source software and tech docs Insanity Palace of Metallica<br>
<a href="http://www.phildev.net/" rel="noreferrer noreferrer" target="_blank">http://www.phildev.net/</a> <a href="http://www.ipom.com/" rel="noreferrer noreferrer" target="_blank">http://www.ipom.com/</a><br>
<br>
"Be who you are and say what you feel, because those who mind don't<br>
matter and those who matter don't mind."<br>
- Dr. Seuss<br>
<br>
<br>
</blockquote></div>