Rails 6 MySQLのutf8mb4対応とは何であって何ではないのか

Transcript

1. Rails 6 MySQLͷutf8mb4 ରԠͱ͸ԿͰ͋ͬͯԿͰ͸ ͳ͍ͷ͔ RejectKaigi 2019 @yahonda
2. Rails, not Ruby?
3. "Your proposal for RailsConf 2019 has not been accepted"
4. Rails 6 RC1 is coming
5. utf8mb4ͰͰ͖Δ͜ͱ
6. Emoji
7. [Railsdm 2018: Day3 ಛผߨԋ] Rails 6 ʹ޲͚ ͨ ActiveRecord ͷվળ
8. yahonda “MySQLͷDEFAULT CHARACTER SETΛɺutf8mb4 ʹ͢Δͷ͸͍͍ΞΠσΟΞͩͱ ࢥΘΕ·͢Ͱ͠ΐ͏͔ɻ"
9. kamipo “(σϑΥϧτΛutf8mb4ʹ͢Δͷ ͸)͜Ε͸ݫ͍͠" "key prefix lengthͷ໰୊ΛϢʔβʔʹԡ ͚͍͍ͭͯ͠ΜͩͬͨΒ(utf8mb4͕)σ ϑΥϧτʹͳΔ(Մೳੑ͕͋Δ)"
10. "MySQL schema/ migration should default to CHARSET=utf8mb4” by DHH rails/rails#33596
11. "Use utf8mb4 character set by default for MySQL database #33608” by yahonda rails/rails#33608
12. Key prefix lengthͷ໰୊ͱ͸ • "ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes" • Rails string type is mapped to MySQL varchar(255) • 255(characters) x 4(bytes) = 1020 > 767
13. Key prefix length໰୊͸ Ͳ͏΍ͬͯղܾ͞Ε͔ͨ
14. 5.7 and 8.0 • innodb_default_row_format ͕༗ޮͳͷͰͦͷ··
15. 5.5 and 5.6 • Add ROW_FORMAT=DYNAMIC option if innodb_file_per_table = 1 AND innodb_file_format = 'Barracuda' • https://github.com/rails/rails/pull/34742
16. Priority • ࠷༏ઌ • database.yml default value: encoding: utf8mb4 • σϑΥϧτͷdatabase.ymlΛฤूͨ͠৔߹ • options[:collation] • options[:charset] (options[:encoding] ͱಉ͡ҙຯ) • optionsͷࢦఆ͕ͳ͍ & MySQL 5.7.9Ҏ্ • utf8mb4 • optionsͷࢦఆ͕ͳ͍ & MySQL 5.6ҎԼ • "Configure a supported :charset and ensure innodb prefix is enabled to support indexes on varchar(255) string columns."
17. What about collation?
18. Rails 6 does not have any “default collation”
19. https://github.com/ rails/rails/issues/ 33596
20. Since proper collation is language dependent (that is the reason that Unicode provide multi level comparison), I personally would not like to provide any collation by default.
21. I basically answer "Please consider using default collation (utf8mb4_general_ci in MySQL 5.7 case). If it has any issue for your use case (Sushi-Beer issue, etc), using utf8mb4_bin might avoid that issue.".
22. Enjoy Rails 6!