Hi All, We are in the process of implementing following APIM analytics feature:
*Abnormal tier usage *- if we haven't got any API hits or less than *X *number of API hits continuously for* Y* days, we should send an alert. This could be an indication of a weird state (eg: the application is not functioning properly). This feature will enable API creators to identify faulty APIs and hence to take necessary actions. We have identified this as a batch analytics task and hence, planning to use Spark SQL queries. All API requests are recorded in “ORG_WSO2_APIMGT_STATISTICS_REQUEST” table. Therefore, by grouping above table using “api, api_version and applicationId” we can get request counts per “api, api_version and applicationId” basis. Next, by filtering out using the policy enforced by api developer/admin ( i.e. if we haven't got any API hits or less than X number of API hits continuously for Y days, we should send an alert and we will be keeping those policies in a configuration file.) we can identify what are the APIs for which we need to send alters. I have managed to write a Spark SQL query to extract APIs which show abnormal tier usage. Now, I’m working on following tasks. 1. We need to think how we could configure this alert as it's not using a Siddhi execution plan. 2. Since we are using Spark SQL for identifying abnormal tire usage, we have to find a proper way of sending alerts from DAS. Your suggestions regarding our approach and tasks currently I'm working on are welcome. Thanks, Upul -- Upul Bandara, Mob: +94 715 468 345.
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
