mysql-audit-logging

Manage Percona audit logging with JSON-based filters and per-user assignments.

1|1|Updated May 29, 2026
One-click install
npx skills add https://github.com/Percona-Lab/skills --skill mysql-audit-logging
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mysql-audit-logging
Source: https://github.com/Percona-Lab/skills/tree/main/mysql-audit-logging
Command: npx skills add https://github.com/Percona-Lab/skills --skill mysql-audit-logging

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables users to implement and manage open-source audit logging for Percona Server for MySQL using the Audit Log Filter component, replacing deprecated Enterprise options and ensuring JSON-based filter definitions and per-user assignment for compliance and security auditing.

Core Features & Use Cases

  • Open-source audit filter setup for Percona Server for MySQL (8.0+/8.4).
  • Create, apply, and manage JSON-based audit filters and assign them to users.
  • Install and operate the audit log component; avoid mixing with enterprise plugin.

Quick Start

Create a filter that logs all connections and assign it to all users to begin auditing.

Frequently Asked Questions about mysql-audit-logging

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up audit logging in Percona Server for MySQL using JSON filters?

Percona audit logging is managed through the Audit Log Filter component, which uses JSON-based filter definitions to specify logged events and supports per-user policy assignments for compliance auditing.

Does Percona Server 8.0 support open-source audit logging without the enterprise plugin?

Percona Server 8.0 and 8.4 support open-source audit logging through the Audit Log Filter component, replacing deprecated enterprise plugins while providing JSON filter definitions and user-level policy assignments.

How do I assign audit log filters to specific MySQL users?

Audit log filters are assigned to specific MySQL users through per-user policy configurations managed by the Audit Log Filter component, ensuring targeted compliance tracking for individual database accounts.

Can I manage log rotation and encryption for MySQL audit logs?

MySQL audit log rotation and encryption are managed operationally through the Audit Log Filter component, enabling secure handling and ongoing maintenance of compliance logs across Percona Server environments.

What are the limitations of using the Percona Audit Log Filter component?

A primary limitation of the Percona Audit Log Filter component is avoiding configuration mixing with the deprecated enterprise plugin, requiring strict usage of JSON-based filter definitions for stable compliance auditing.