Bug 1343630 Comment 2 Edit History

Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.

Original comment by
on 
I agree switching all tables makes sense.

For anyone working on this in the future, this will require:
1) Adjusting the mysql.cnf file in the Treeherder repository used by Vagrant, so that the dev DB that gets created uses utf8mb4 instead of utf8
2) Updating the Terraform config for RDS so with the equivalent change from (1): https://github.com/mozilla-platform-ops/devservices-aws/blob/master/treeherder/rds.tf
3) Actually updating the existing dev/stage/prod DB schemas (since the change in (2) will only apply to new tables) using the techniques described here:
  - https://mathiasbynens.be/notes/mysql-utf8mb4
  - http://hanoian.com/content/index.php/24-automate-the-converting-a-mysql-database-character-set-to-utf8mb4
Revision 1 by
on 
I agree switching all tables makes sense.

For anyone working on this in the future, this will require:
1) Adjusting the mysql.cnf file in the Treeherder repository used by Vagrant, so that the dev DB that gets created uses utf8mb4 instead of utf8
2) Updating the Terraform config for RDS so with the equivalent change from (1): https://github.com/mozilla-platform-ops/devservices-aws/blob/master/treeherder/rds.tf
3) Actually updating the existing dev/stage/prod DB schemas (since the change in (2) will only apply to new tables) using the techniques described here:
    - https://mathiasbynens.be/notes/mysql-utf8mb4
    - http://hanoian.com/content/index.php/24-automate-the-converting-a-mysql-database-character-set-to-utf8mb4

Back to Bug 1343630 Comment 2