MySQL Data Archiving basics – considerations, mistakes, best practices
This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…
AI tools – technology and kids
AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed. The message out…
Killer Blog for MySQL Administrators
This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…
MySQL Podcast – Practical Learning & Training
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…
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…
Podcast: Duplicate Indexes in MySQL
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…