MySQL

Troubleshooting MySQL: Encryption can’t find Master Key

September 23, 2024

If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…

MySQL 8 upgrade may fail using checkForServerUpgrade

March 7, 2024

These days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL…

How to avoid data loss in MySQL Primary Key change

March 1, 2024

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.

MySQL Benchmarking and error in my_thread_global_end()

February 20, 2024

I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…

How to save money in AWS RDS – Upgrade to MySQL 8

February 8, 2024

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…

How MySQL Binary Log Gets Its Number

January 28, 2024

In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…