We all know MySQL InnoDB ClusterSet, a solution that links multiple InnoDB Clusters and Read Replicas asynchronously to easily generate complex MySQL architectures and manage them without burdensome commands. All this thanks to the MySQL Shell’s AdminAPI. This is an example of MySQL InnoDB ClusterSet using two data centers: Let’s explore how we can automate […]

In my previous blog post, Understanding trx-consistency-only on MyDumper Before Removal, I talked about --trx-consistency-only removal, in which I explained that it acts like a shortcut, reducing the amount of time we have to block the write traffic to the database by skipping to check if we are going to backup any non-transactional tables. Now, […]

We're now expanding OCI Database Management capabilities with a new set of enhanced monitoring features - designed to reduce operational burden on DBAs and developers, strengthen observability, and support high availability across modern MySQL deployments.

I’ve hacked together a horrible thing in Python, and made it available in mysql-release-notes

on GitHub.

It’s a Python project (done with uv) that downloads all MySQL release notes, dumps them into a release_notes folder, and then parses them, pushing everything into a database.

It uses SQLAlchemy and mysqlclient to connect to the database.

It generates a schema (not preserving any data), and fills it with all the release notes we have.

The schema is a simple star.

For each release, we have many issues, and for each issue we store a number of properties. Properties aren’t stored as plain text — they’re encoded, and we only keep the property ID.

Sample queries like

select t.contributor,
       min(r.release_date), min(r.version),
       max(r.release_date), max(r.version), …

HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats, and maintain detailed records for regulatory requirements. The audit system is easy to set up, supports granular activity tracking, and provides actionable insights directly through the SQL interface.

The post HeatWave MySQL Database Audit first appeared on dasini.net - Diary of a MySQL expert.

MySQL Analysis: With an AI-Powered CLI Tool

As DBAs with MySQL we often live on a Linux terminal window. We also enjoy free options when available. This post shows an approach that allows us to stay on our terminal window and still use an AI-powered tool. You can update to use other direct AI providers but I set this example up to use aimlapi.com as it brings multiple AI models to your terminal for free with limited use or very low cost for more testing.

Note: I'm not a paid spokesperson for AIMLAPI or anything - this is just an easy example to highlight the idea.

The Problem

You're looking at a legacy database with hundreds of tables, each with complex relationships and questionable design decisions made years ago. The usual process involves:

• Manual schema inspection
• Cross-referencing documentation (if it exists)
• Running multiple EXPLAIN queries
…

Boost your MySQL performance with AI for MySQL. Learn how AI tools can optimize queries, enhance troubleshooting, and automate database management. Get started now!

The post How to Use AI for MySQL: Optimizing Queries and Database Management  appeared first on Devart Blog.

Reflecting on 30 Years of MySQL and Looking Ahead

This year marks an incredible milestone as MySQL celebrates 30 years of powering applications worldwide! Whether you’re a long-time fan or just starting your journey, you’re invited to join the MySQL Global Forum a virtual event bringing together MySQL leaders, experts, and community members from around the globe.

In the previous post, we explored how the MySQL Shell extension for Visual Studio Code brings database development directly into your editor. In this follow-up, we'll walk through how to connect to a HeatWave MySQL database which is hosted in the cloud on Oracle Cloud Infrastructure (OCI) and how to browse schemas and run queries, all without leaving VS Code. Here is an architecture diagram that gives an idea of how VS Code connects to the HeatWave MySQL DB system.

Fintech (financial technology) companies continue to disrupt the financial services industry. The technology they rely on is paramount; it often determines their ability to deliver an innovative solution exhibiting the performance, scalability, security, reliability, and cost-efficiency that will sway customers. Let’s consider in this blog why 3 fintech startups migrated to HeatWave MySQL, and the results they achieved.