Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

database monitoring

CSommer
Contributor

Hello Exasol-Community,

I would be interested to know what options there are for monitoring the status of the database.
Especially a notification when the database shuts down would be helpful.
It happened that a query was sent via a tool that used so much temporary memory that the database shut down.
If something like this happens, it would be helpful if you received a notification (e.g. email).

If someone has implemented further monitoring (e.g. node-status changes), feel free to throw it out.

 

best regards

Colin

6 REPLIES 6

przemek
Xpert

Hi @CSommer ,
Is your Exasol instance running on AWS?
If so, Exasol provides an excellent adapter in the Github repository for connecting to CloudWatch.

https://github.com/exasol/cloudwatch-adapter

CloudWatch hands-on guide
https://www.youtube.com/watch?v=baABKvLu5vw

In our company, we're using our own solution and monitoring our Exasol instance with Grafana.

Many greetings
Przemek

CSommer
Contributor

Hi @przemek ,

thank you for your reply! 

 

The Exasol instance runs locally.

Grafana sounds interesting, do you also use Grafana to monitor instance failures and get notified?

 

best regards

Colin

 

PeterK
Xpert

Hi @CSommer 

At our company we use Nagios for monitoring Exasol and sending alerts.

https://github.com/exasol/nagios-monitoring

Best

Peter

CSommer
Contributor

Hi @PeterK,

thank you very much for your answer!

Is it also possible to get the status of the database with Nagios?
We had the following error message from a query sent from a reporting tool:
 
Emergency shutdown: Process 1 requested emergency shutdown. Reason: Full disk handling cannot ensure normal operation of database. Automatic restart doesn't seem to be useful. Manual intervention is needed.

 

Regardless of the cause of the error, it is important that the database shut itself down and "only" created a log entry. They only found out about it two days later when trying to connect to the database.

It would be nice if you were informed of such a process or if Nagios checks the status of the database and sent a message/mail/fax/whatever if the status is no longer "running".

best regards
Colin

przemek
Xpert

Hi @CSommer ,
yes, grafana also allows alerting notifications.

https://grafana.com/docs/grafana/latest/alerting/

Best,
Przemek

PeterK
Xpert

Hi @CSommer  - Yes, the Nagios example that I linked above connects to Exasol's XMLRPC API which allows it to monitor log entries, statuses, and many other things that the API exposes: https://github.com/exasol/exaoperation-xmlrpc