Showing entries 21 to 30 of 44073
« 10 Newer Entries | 10 Older Entries »
HeatWave MySQL security series - Customer managed encryption keys

Cloud database security isn’t just a best practice—it's an absolute necessity. With sensitive data flowing into the cloud, protecting your business-critical assets is non-negotiable, and Oracle Cloud Infrastructure (OCI) HeatWave MySQL provides robust features to help. This blog explores customer managed encryption key, the related backup strategies, and the required security policies so you can keep your databases both agile and secure.

How do you upgrade MySQL HeatWave when deploying with Terraform?

Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform? When you tried, you realized, I hope you didn’t turn off backups, that the instance is destroyed and recreated new! This is our current MySQL HeatWave DB System deployed using Terrafrom: And this is […]

Uplevel the MySQL REST Service

The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. Try the latest MySQL REST Service lab release!

Uplevel the MySQL REST Service

The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. The MySQL REST Service was first released on https://labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released on MySQL HeatWave and standard […]

Diagnosing MySQL Crashes on RHEL with GDB: How to Identify the Database, Table, and Query Involved

When troubleshooting a MySQL crash, having only the error log is rarely enough to pinpoint the exact root cause. To truly understand what happened, we need to go deeper—into the memory state of the process at the moment it crashed. That’s where GDB, the GNU Debugger, comes in. GDB lets us inspect a core dump […]

Deploying High Availability and Disaster Recovery MySQL on OCI like a devops

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

MyDumper Refactors Locking Mechanisms

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

New Monitoring Capabilities for MySQL in OCI Database Management

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.

MySQL: Release Notes Database

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), …
[Read more]
HeatWave MySQL Database Audit

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.

Showing entries 21 to 30 of 44073
« 10 Newer Entries | 10 Older Entries »