[MDEV-11618] Server audit won't log the replication process at replication slave Created: 2016-12-21  Updated: 2023-04-24  Resolved: 2023-04-24

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit, Replication
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Su, Jun-Ming Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Sprint: 10.1.22

 Description   

I have one replication slave at my site, and I enable the server audit plug-in at slave server.

I think there are many replication log (binlog replay) in the server audit log, but there is only the operations that on slave server will be logged.

If I want to log the replication log replayed process, is the server audit plug-in will be done?

 Comments   
Comment by Ralf Gebhardt [ 2018-11-13 ]

The audit for such changes should be done on the master from my point of view. In which case would auditing of the slave be different to an audit of the master?

Comment by Su, Jun-Ming [ 2018-11-14 ]

Thanks for your responding.

I have 2 reasons for this issue.

1. Prevent the performance of master server low.
Because of the performance of master server and needed to do audit (for information scecurity process), I want to do audit on read-only slave server because all master server operation will be replayed on slave server.

2. Troubleshoot for delayed slave serer.
Because of solving the problem for delayed slave server, I need to check the replay process on all transation from master server, it is convinent for me to read audit logs.

Generated at Thu Feb 08 07:51:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.