Welcome, data explorers, to the grand dining hall of MySQL, where today you get your first taste of hands-on creation! You’ve learned about library metaphors, database magic, and why MySQL is the world’s super-organized librarian. Now, it’s time to roll up your sleeves and set the table—well, the database table—for the feast ahead. By the […]

When you design a database, one of the first big decisions is how you want to store each piece of data. Think of MySQL data types as the basic building materials for your database: concrete for foundations, glass for windows, wood for bookshelves. If you pick the right material for each job, everything fits together […]

Welcome back, data explorer! You now know the basics of MySQL’s structure. But how do you actually step into this wonderland of tables and data? That’s where the MySQL Shell comes in—think of it as your trusty librarian, always ready to fetch books, organize sections, or gently shush unruly queries. What Is MySQL Shell? MySQL […]

Welcome to your journey into the world of MySQL! If you’ve ever wondered about the invisible engine powering your favorite apps, managing your music playlist, or keeping track of your pizza orders, you’re about to discover one of the most trusted tools working behind the scenes: MySQL. Databases, like MySQL, are the unsung heroes of […]

Right now, you’re probably hoping someone else will deal with this MySQL 8.0 end-of-life situation. Maybe your team can squeeze another few months out of it. Maybe Oracle will extend support. Maybe it won’t be as bad as everyone says. We get it.  You’ve got enough things going on without adding “major database upgrade” to […]

How do you know if your backup is truly reliable? The last thing you want is to discover your data is corrupted during a critical restore or during a migration. While MyDumper is a powerful tool for logical backups, its -M option takes backup integrity to the next level by creating checksums. This often-overlooked feature […]

If you manage a MySQL database, you’ve probably heard the news: MySQL 8.0 is heading for its End of Life (EOL), and taking center stage is MySQL 8.4, the first-ever Long-Term Support (LTS) release. This is great news for all of us who value stability, as it means a more predictable, enterprise-ready platform for the […]

It may be surprising when a new InnoDB Cluster is set up, and despite not being in production yet and completely idle, it manifests a significant amount of writes visible in growing binary logs. This effect became much more spectacular after MySQL version 8.4. In this write-up, I will explain why it happens and how to address […]

As databases grow, DBAs and developers often face a tough choice:
+ Keep historical data in production tables and risk slow queries
+ Archive it and lose fast access

With HeatWave, you don’t have to choose. You can archive old partitions, keep recent data in production, and still run lightning-fast queries across all your data.

The post Archive Smarter, Query Faster: Unlocking MySQL Performance with HeatWave first appeared on dasini.net - Diary of a MySQL expert.

On July 22nd, 2025, we released MySQL 9.4, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can notice several contributions related to NDB and the Connectors Connectors MySQL Server – Replication InnoDB Optimizer C API (client […]