MySQL 8 utf8mb4_0900_ai_ci collation confusion
Kedar
Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…
Browsing Category
MySQL Upgrade
4 posts
MySQL Upgrade
Understanding Return Codes of pt-upgrade: A quick guide
Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…
How to save money in AWS RDS – Upgrade to MySQL 8
MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…
MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values…