| title | description | author | ms.author | ms.service | ms.topic | ms.date |
|---|---|---|---|---|---|---|
Access audit logs - Azure portal - Azure Database for MariaDB |
This article describes how to configure and access the audit logs in Azure Database for MariaDB from the Azure portal. |
savjani |
pariks |
mariadb |
how-to |
6/24/2020 |
You can configure the Azure Database for MariaDB audit logs and diagnostic settings from the Azure portal.
To step through this how-to guide, you need:
Important
It is recommended to only log the event types and users required for your auditing purposes to ensure your server's performance is not heavily impacted.
Enable and configure audit logging.
-
Sign in to the Azure portal.
-
Select your Azure Database for MariaDB server.
-
Under the Settings section in the sidebar, select Server parameters.
-
Update the audit_log_enabled parameter to ON.
-
Select the event types to be logged by updating the audit_log_events parameter.
-
Add any MariaDB users to be excluded from logging by updating the audit_log_exclude_users parameter. Specify users by providing their MariaDB user name.
-
Once you have changed the parameters, you can click Save. Or you can Discard your changes.
-
Under the Monitoring section in the sidebar, select Diagnostic settings.
-
Click on "+ Add diagnostic setting"
-
Provide a diagnostic setting name.
-
Specify which data sinks to send the audit logs (storage account, event hub, and/or Log Analytics workspace).
-
Select "MySqlAuditLogs" as the log type.
-
Once you've configured the data sinks to pipe the audit logs to, you can click Save.
-
Access the audit logs by exploring them in the data sinks you configured. It may take up to 10 minutes for the logs to appear.
- Learn more about audit logs in Azure Database for MariaDB
- Learn how to configure audit logs in the Azure CLI