search

database-mesh / pisanix

A Database Mesh Project Sponsored by SphereEx
https://www.pisanix.io
Apache License 2.0
280 stars 37 forks source link

Support AWS CloudWatch for SQL audit sinking #238

Open mlycore opened 2 years ago

mlycore commented 2 years ago

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 commented 2 years ago

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

mlycore commented 2 years ago

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

mlycore commented 2 years ago

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.