Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Prevent replication queries to logging in audit log file #284

Open
manishkr47 opened this issue Jan 28, 2025 · 0 comments
Open

Prevent replication queries to logging in audit log file #284

manishkr47 opened this issue Jan 28, 2025 · 0 comments

Comments

@manishkr47
Copy link

My Mysql version is 8.0.26 and setu is running in master-master replication. i am using audit plugin version audit-plugin-mysql-8.0-1.1.12-999-linux-x86_64.zip. in my sinario traffic is coming on both master and i have used audit_whitelist_users=audit_whitelist_users so that each master log their indivisual queries only not replication query. but this is not working and replication queries are logging to both matser i mean queries directly coming on master M1 is loggin toto Master M2 audit file like below.

{"msg-type":"activity","date":"1738087816312","thread-id":"834","query-id":"147883","user":"skip-grants user","priv_user":"skip-grants user","ip":"","host":"","status":"0","cmd":"

Please suggest way to prevent this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant