exasol / cloudwatch-dashboard-examples

Template for an Exasol – CouldWatch dashboard
MIT License
1 stars 1 forks source link
aws aws-cloudwatch aws-cloudwatch-metrics database-statistics exasol-integration java monitoring

Exasol CloudWatch Example Dashboard

Build Status

Quality Gate Status

Security Rating Reliability Rating Maintainability Rating Technical Debt

Code Smells Coverage Duplicated Lines (%) Lines of Code

This project contains an AWS CDK template for an example CouldWatch dashboard that visualizes the metrics reported by the Exasol – CloudWatch adapter.

This dashboard should get you started with Exasol and CloudWatch integration.

Exasol CloudWatch dashboard example

Quick Usage

If you just want to use the example dashboard, you can simply download the latest AWS CloudFormation template in the releases section and run it in cloudformation.

There you will have to set a Deployment Name. This is the name of your Exasol installation you entered during the setup of the cloudwatch-adapter.

Now you can view and edit your CloudWatch dashboard in the AWS Console. You can also deploy this template multiple times and build different dashboards for different use cases.

Advanced Usage

In this repository we define the dashboard by code using AWS CDK. That allows us to define the dashboard in a very readable way.

You can use this as a starting point for your own dashboards. In contrast to changing the dashboard using the AWS Console that allows you for example to version your dashboards in Git, add a review process or simply copy the same dashboard for multiple Exasol deployments. For that you need to go through the following steps:

Injecting Metrics Values for Testing

To test your dashboard and alarms you can manually inject metrics values by executing commands like these:

aws cloudwatch put-metric-data --namespace "Exasol" --dimensions "Cluster Name=MAIN,Deployment=<YOUR DEPLOYMENT NAME>" --unit Seconds --value 30 --metric-name "BACKUP_DURATION"
aws cloudwatch put-metric-data --namespace "Exasol" --dimensions "Cluster Name=MAIN,Deployment=<YOUR DEPLOYMENT NAME>" --unit Count --value 1 --metric-name "EVENT_BACKUP_START"
aws cloudwatch put-metric-data --namespace "Exasol" --dimensions "Cluster Name=MAIN,Deployment=<YOUR DEPLOYMENT NAME>" --unit Count --value 1 --metric-name "EVENT_BACKUP_END"
aws cloudwatch put-metric-data --namespace "Exasol" --dimensions "Cluster Name=MAIN,Deployment=<YOUR DEPLOYMENT NAME>" --unit Count --value 1 --metric-name "EVENT_BACKUP_ABORTED"

Additional Information