pisanix icon indicating copy to clipboard operation
pisanix copied to clipboard

Support AWS CloudWatch for SQL audit sinking

Open mlycore opened this issue 2 years ago • 3 comments

Feature Request

Is your feature request related to a problem? Please describe:

n/a

Describe the feature you'd like:

Support AWS CloudWatch for SQL auditing sinking, store the data in log groups of AWS S3

Describe alternatives you've considered:

Using Kinesis, or EventBridge to send the audit data to other systems.

Teachability, Documentation, Adoption, Migration Strategy:

n/a

mlycore avatar Aug 08 '22 00:08 mlycore

Tested AWS CloudWatch in #258 . Since there is a quota for each log stream, this may find another way to handle the logs.

mlycore avatar Aug 12 '22 06:08 mlycore

Try to use EventBridge to transfer audit event logs to CloudWatch. And add SQL digest in the future.

mlycore avatar Aug 15 '22 07:08 mlycore

Using AWS EventBridge as a mpsc AuditChannel, every proxy should sink their SQL audit event to the channel, the AuditServer will consume AuditChannel events and send it to AWS EventBridge.

mlycore avatar Aug 24 '22 06:08 mlycore