Many applications start with a simple database setup: create one MySQL user, give it access to the application schema, put the credentials in the app config, and move on. That may work at first, but it is not a good long-term security model. A better approach is to use separate MySQL users for separate application […]

Best practices for MySQL customers and users in an AI-accelerated security landscape: A practical guide to hardening MySQL and the environment around it Oracle recently described how AI is transforming vulnerability detection and response. The latest generation of AI is increasing the speed and scale at which vulnerabilities can be identified and remediated. Oracle is […]

When people ask me how to tune MySQL, they usually mean, “Which variables should I change in my.cnf?” (the MySQL configuration file) That certainly is a reasonable place to start, because most day-to-day performance tuning really is driven by MySQL itself: memory allocation, redo flushing, connection handling, temporary tables, and InnoDB I/O behavior. But the […]

Production data is invaluable for day-to-day operations—support, troubleshooting, analytics, and development. But when that data contains sensitive fields such as SSNs, emails, phone numbers, or other identifiers, broad read access can quickly become unnecessary exposure.  Just as importantly, many organizations operate under regulatory and contractual requirements that expect strong controls around access to sensitive data—often including data masking as […]

With MySQL 9.7.0 LTS, MySQL establishes its next long-term support release line, expands key capabilities in Community Edition, and introduces Dynamic Data Masking for Enterprise users. The April releases mark an important milestone for MySQL. With the GA of MySQL 9.7.0 LTS, MySQL moves from the 9.x innovation series to a new Long-Term Support release line. This begins […]

MySQL observability is essential in modern enterprises, whether you run a few critical databases or operate at massive scale. With the right real‑time monitoring, teams reduce MTTD/MTTR, avoid cascading failures, and continuously track workload health—CPU, memory, I/O, buffer pool efficiency, session contention, transaction/replication lag, error rates, and query latency. This Grafana monitoring template helps teams […]

Sensitive data has a way of showing up in unexpected places: an “email” column in a demo app, a forgotten “token” field in a logging table, or free-text notes that quietly become regulated data. I wanted a lightweight, repeatable way to answer a simple question on any MySQL instance: Where is sensitive data likely to […]

If you’ve ever dived into MySQL configuration, you’ve probably come across the term “SQL modes.” These are powerful settings that can change how MySQL interprets SQL queries, handles data validation, and even enforces certain standards. But with great power comes great responsibility – choosing the wrong mode can lead to unexpected behaviors, data inconsistencies, or […]

We recently announced the availability of MySQL AI which enables predictive and generative AI workflows for on-premise MySQL customers. MySQL AI includes built-in LLMs and embedding models that run on CPUs, a vector store, semantic search functions, automated machine learning and a graphical console called MySQL studio. Since its release there has been considerable interest […]

Announcing MySQL HeatWave Migration Assistant — the newest way to move MySQL workloads to Oracle Cloud Infrastructure (OCI) with ease! Migrating critical databases to the cloud is often viewed as complex. That changes with the launch of the MySQL HeatWave Migration Assistant. This new tool is purpose-built to help organizations move their on-premises MySQL databases […]