MySQL Major Version Upgrade Checklist – how to
Kedar
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.
Browsing Category
MySQL Upgrade
7 posts
MySQL Upgrade
MySQL 8.4 disables AHI – Why and What you need to know
MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…
A Unique Foreign Key issue in MySQL 8.4
Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…
MySQL 8 utf8mb4_0900_ai_ci collation confusion
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…
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…