Re:DDoS detection and remediation with Akvorado and Flowspec
by justsomehnguy on Tuesday March 07, 2023 @11:57AM
(#35057680)
IMO the most straightforward solution would be to something like:
a) add these 'metric counters' in a little more friendly way than mess with ClickHouse itself (maybe a directory with *.sql to be loaded on the start/file change?)
b) a way to publish them in JSON through the webserver
After that I can just poll the endpoint with a script and do whatever I need with that info.
AFAIR ClickHouse has a built-in REST-like interface, which can be used for that but that means the need to expose ClickHouse itself.
a) add these 'metric counters' in a little more friendly way than mess with ClickHouse itself (maybe a directory with *.sql to be loaded on the start/file change?)
b) a way to publish them in JSON through the webserver
After that I can just poll the endpoint with a script and do whatever I need with that info.
AFAIR ClickHouse has a built-in REST-like interface, which can be used for that but that means the need to expose ClickHouse itself.