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
Technical
42 posts
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…
A year in MySQL Blogging – top blogs, summary and review
The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…
Can not connect to ProxySQL: reasons and fixtures
This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you…
MySQL backup shell script with status email
This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The…
Restore A Table / Database From Full Backup – Yet Another Way
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.