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

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, defect, P2)

Description

[Ed Morley [:emorley]]

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

Comment 1

[Ed Morley [:emorley]]

Attachment: 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.

Comment 2

[Ed Morley [:emorley]]

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

Comment 3

[Kendall Libby [:fubar] (he/him)]

Updated stage to 5.6.34. Dev is not yet done (cf bug 1331397; it's hung up on wanting a final snapshot name)

Comment 4

[Kendall Libby [:fubar] (he/him)]

Dev is done.

Comment 5

[Ed Morley [:emorley]]

Attachment: devservices-aws PR #35: Update prod from MySQL 5.6.29 to 5.6.34

Comment 6

[Ed Morley [:emorley]]

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

Comment 7

[Kendall Libby [:fubar] (he/him)]

prod and prod-ro are both, finally, done