Update dev/stage/prod RDS instances from MySQL 5.6.29 to 5.6.34

RESOLVED FIXED

Status

Tree Management
Treeherder: Infrastructure
P2
normal
RESOLVED FIXED
a year ago
a year ago

People

(Reporter: emorley, Assigned: emorley)

Tracking

Details

Attachments

(2 attachments)

(Assignee)

Description

a year ago
Until recently the latest MySQL 5.6 release available on RDS was 5.6.29.

However AWS quietly released 5.6.34 on November 15th (and failed to actually put it in the RDS changelog, sigh):
https://forums.aws.amazon.com/ann.jspa?annID=4176

We should try converting dev/stage to the newer version and then if all goes well, the prod replica then prod too.

Changelogs:
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-30.html
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-31.html
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-32.html
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-33.html
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-34.html

Changes of interest (only briefly skimmed):
* In-place ALTER TABLE operations which when executed separately caused no table rebuild could when combined into a single statement result in a table rebuild. (Bug #23475211, Bug #81587)
* A handful of query optimizer improvements
* Various full text index fixes
* Many reliability/security fixes
(Assignee)

Comment 1

a year ago
Created attachment 8828175 [details] [review]
devservices-aws PR #33: Update dev/stage from MySQL 5.6.29 to 5.6.34

I'm happy for this to be applied using the "apply immediately" option.

I'm also presuming Terraform should allow modifying the dev instance without resetting it to the snapshot again? (since `snapshot_identifier` won't have changed and the `taint` command not used)

After we're happy with this on stage, I'll open another PR for prod.
Attachment #8828175 - Flags: review?(klibby)
(Assignee)

Comment 2

a year ago
Comment on attachment 8828175 [details] [review]
devservices-aws PR #33: Update dev/stage from MySQL 5.6.29 to 5.6.34

https://github.com/mozilla-platform-ops/devservices-aws/commit/04a68ef01e81547568f0088a5ad3d07abb9e2145
Attachment #8828175 - Flags: review?(klibby)
Attachment #8828175 - Flags: review+
Attachment #8828175 - Flags: checkin+
Updated stage to 5.6.34. Dev is not yet done (cf bug 1331397; it's hung up on wanting a final snapshot name)
Dev is done.
(Assignee)

Comment 5

a year ago
Created attachment 8831883 [details] [review]
devservices-aws PR #35: Update prod from MySQL 5.6.29 to 5.6.34
Attachment #8831883 - Flags: review?(klibby)
Attachment #8831883 - Flags: review?(klibby) → review+
(Assignee)

Comment 6

a year ago
Comment on attachment 8831883 [details] [review]
devservices-aws PR #35: Update prod from MySQL 5.6.29 to 5.6.34

https://github.com/mozilla-platform-ops/devservices-aws/commit/d8788acdcce49241c2f20e49d523bf6616adf500
Attachment #8831883 - Flags: checkin+
prod and prod-ro are both, finally, done
Status: ASSIGNED → RESOLVED
Last Resolved: a year ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.