Showing entries 1 to 10 of 22246
10 Older Entries »
Displaying posts with tag: MySQL (reset)
MySQL with Diagrams Part Three: The Life Story of the Writing Process

When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed: [crayon-68caf01b86ddc081419091/] The log […]

MySQL Podcast: InnoDB Cluster Group Replication

I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…

The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable.

Beyond EOL: The Real Benefits of Upgrading to MySQL 8.4

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 […]

Don’t Trust, Verify: How MyDumper’s Checksums Validates Data Consistency

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 […]

MySQL 8.0 Deprecated Features: What You Need to Know

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 […]

MySQL Router 8.4: How to Deal with Metadata Updates Overhead

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 […]

Archive Smarter, Query Faster: Unlocking MySQL Performance with HeatWave

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.

MySQL 9.4 – Thank you for your contributions!

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 […]

Top 5 Security Risks of Running MySQL 8.0 After Its EOL

Your MySQL database has been running smoothly for years. Your team knows it inside and out. Everything just… works. Why rock the boat with an upgrade? Here’s why: MySQL 8.0 reaches its end-of-life date in April 2026. After this date, there’s no safety net; staying on end-of-life software means you’re taking on all the responsibility […]

MySQL 8.0 End of Life Date: What Happens Next?

If you’re running MySQL 8.0 databases, you need to know this: Oracle will stop supporting them in April 2026. That means no more security patches, bug fixes, or help when things go wrong. Maybe you’re thinking, “But April 2026 feels far away!“. But once that date hits, every day you keep running MySQL 8.0 makes […]

Showing entries 1 to 10 of 22246
10 Older Entries »