Browsing Category

MySQL

117 posts

Articles related to MySQL, Percona Server, MariaDB

No comments

MySQL Podcast – Practical Learning & Training

Kedar
November 6, 2024

Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…

View Post

No comments

MySQL Change Buffer – What When and FAQ

Kedar
November 4, 2024

In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…

View Post

No comments

Understanding Return Codes of pt-upgrade: A quick guide

Kedar
October 14, 2024

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…

View Post

MySQL

One comment

Troubleshooting MySQL: Encryption can’t find Master Key

Kedar
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,…

View Post

2 comments

MySQL 8 upgrade may fail using checkForServerUpgrade

Kedar
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…

View Post

One comment

How to avoid data loss in MySQL Primary Key change

Kedar
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.

View Post