In MySQL, use “utf8mb4” instead of “utf8” (2016)

Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by sshine on Wednesday January 12, 2022 @12:03PM (#29909502)

I suspect this is because for large databases, schema changes lock the tables for extended periods of time, and if this time exceeds a reasonable time for a service window, you need good database replication. And you probably don’t have good MySQL database replication unless you’re on AWS or similar.

[ Parent | on HN ]

Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by spookthesunset on Wednesday January 12, 2022 @01:54PM (#29911256)

That’s exactly what it is. If you have a big table you are gonna have a pretty long outage while you update that schema. Like in the last place I worked our largest table would take more than an hour for a schema update. So we never did schema updates.

[ Parent | on HN ]

Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by sshine on Friday January 21, 2022 @04:23PM (#30030185)

At my last workplace, we had a service window of one weekend. Prior to this, an application had to be restructured to even make the schema upgrade able to finish in one weekend.

[ Parent | on HN ]

Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by cerved on Wednesday January 12, 2022 @06:16PM (#29914164)

sounds like how I approach laundry

[ Parent | on HN ]