An overview of DDL support for JSON Relational Duality Views introduced in version 9.4.

Congratulations, library explorer! You’ve learned how to use the magical SELECT statement to peek inside your MySQL tables—the database’s equivalent of opening every book in your collection at once. But what if you don’t want a full inventory of every book lover, bestselling novel, or author in your database? What if you just need the sci-fi fans, […]

An overview of DML support for JSON Relational Duality Views introduced in version 9.4.

AI and machine learning are seemingly everywhere, and that’s forcing every database company to think about vector search. Companies want to build things like smart search that actually understands what you mean, recommendation systems that know what you’ll like, and tools that can spot when something’s off. To make all of this work at the […]

This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time.

The audit log filter component in MySQL 8.4 provides administrators with a powerful mechanism for auditing database activity at a fine-grained level. While it offers significant flexibility—such as selectively logging events based on users, hosts, or event types—it can also be challenging to understand and configure correctly.

In this article, we will examine how the audit log filter component works, walk through its core concepts, and share practical tips for configuring and managing audit filters effectively. Our goal is to help you leverage this feature to improve observability, meet compliance requirements, and reduce unnecessary logging overhead.

Enabling Audit Log Filter

We will be using Percona Server 8.4.4 or higher in the examples below. First, we need to enable the audit log filter component. To install the audit log filter component, we need to run the following command:

Copy Copied!

Announcing the release of MySQL AI, an option to MySQL Enterprise Edition, that provides built-in predictive and generative AI capabilities and a vector store.

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-697773637c60c399076158/] The log […]

MySQL is the most widely used open-source database. For over 30 years it has enabled organizations to run business-critical and scalable applications. It is the database of choice for visionary startups, small and medium-sized businesses, some of the largest enterprises run on MySQL. It is globally trusted for its reliability and ease of use. As […]

Begin your hands-on MySQL adventure! This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time.