2

We are using MYSQL as our production database and we have setup another salve for read requests. Time to time various database users can execute insert/update queries on master database. If we want identify those executed queries (auditing/troubleshooting) we are using mysql bingos for it (reading after decoding it). From mysql binlog we can identify the query but we cant identify the executed user. is their a way to get that query executed user info into binlog. Enable general log wont be a option due to performance issues.

  • 2
    Adding information to the binlog requires modifying the code. – Rick James Sep 29 '16 at 22:13
1

Not sure about general log, but this behavior belongs to auditing system. If you don't insist to write into binlog, both Oracle and Percona offer solutions:

  • 1
    I agree, I use the Percona audit_log plugin with my MySQL databases, and it works really well. Gives you everything you want, and then some. – IGGt Sep 30 '16 at 7:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.