Monitoring with AWS CloudWatch Agent

You can use AWS CloudWatch Agent to monitor your applications and resources on the AWS in real time. This section explains how to use AWS CloudWatch to monitor Exasol installation on AWS.

Install and Configure CloudWatch Agent

Do the following to install and configure the CloudWatch Agent:

  1. Attach CloudWatchAgentServerPolicy to IAM role of the EC2 instance.
  2. Access the cluster using ssh and run the following command to download the CloudWatch package.

    wget https://s3.amazonaws.com/amazoncloudwatch-agent/redhat/amd64/latest/amazon-cloudwatch-agent.rpm

  3. Run the following command on the nodes that should send the matrices.

    rpm -ivh amazon-cloudwatch-agent.rpm

  4. (Optional) If you want to send the matrices to a different region, modify the following file.

    cd /opt/aws/amazon-cloudwatch-agent/etc/common-conifg.toml

  5. (Optional) Run the following commands to create AWS CloudWatch profile for AWS API.

    pip install pipenv

    pipenv shell

    pip install awscli

  6. (Optional) Enter Key, Secret, and Region in AWS Configure > Profile AmazonCloudWatchAgent.
  7. Create agent configuration or use an existing one at the following location.

    /opt/aws/amazon-cloudwatch-agent/bin/amazon-cloudwatch-agent-config-wizard

    It will create /opt/aws/amazon-cloudwatch-agent/bin/config.json

  8. Run the following command to start the agent and check the syntax.

    /opt/aws/amazon-cloudwatch-agent/bin/amazon-cloudwatch-agent-ctl -a fetch-config -m ec2 -c file:/opt/aws/amazon-cloudwatch-agent/bin/config.json -s

The logs are stored in the following file.

/opt/aws/amazon-cloudwatch-agent/logs/amazon-cloudwatch-agent.log

Start the CloudWatch Agent

Run the following command to start the CloudWatch Agent.

systemctl start amazon-cloudwatch-agent.service

Stop the CloudWatch Agent

Run the following command to stop the CloudWatch Agent.

systemctl stop amazon-cloudwatch-agent.service

Restart the CloudWatch Agent

Run the following command to restart the CloudWatch Agent.

systemctl restart amazon-cloudwatch-agent.service

Check Status of the CloudWatch Agent

Run the following command to check status of the CloudWatch Agent.

systemctl status amazon-cloudwatch-agent.service

Further Information

To transfer information from the database's EXA_STATISTICS schema to AWS CloudWatch metrics, use Exasol – AWS Cloudwatch Adapter. This adapter runs independently of the Exasol database in an AWS Lambda function. For more information, see Exasol - AWS Cloudwatch Adapter.

For more information about AWS CloudWatch Agent, see CloudWatch Documentation.