Check if your cubeSQL server is up and running (with StatusCake)

March 25th, 2015 | 1 Comment »

A lot of time there is the need to monitor if a server like cubeSQL is up and running (and if something goes wrong to be promptly notified). I recently discovered a nice service StatusCake which perfectly fits with the majority of these needs.

There is a free account that you can try before any further purchase. Setup a cubeSQL is really easy, just set Test type to TCP and then enter IP or hostname and port (4430 is the official cubeSQL default port, registered at IANA).

Screen Shot 2015-03-25 at 12.21.19

Once setup, you’ll have access to both a reserved area where you can monitor your service and a public page full of useful stats (optional). And note that you’ll be promptly notified by email, sms or via a http call when something goes wrong with your server.

statuscake

I strongly recommend to give StatusCake a try.

One Response to “Check if your cubeSQL server is up and running (with StatusCake)”

  • Oliver Osswald says:

    I use a little script to check whether cubesql is up and running and if not, then it will start it.
    On a linux virtual server, I defined a cron-job which runs that script every other minute.

    Save this text for instance to /opt, and allow the file to be executed (755, rwxr-xr-x)

    #!/bin/bash
    if [[ ! `pidof -s cubesql` ]]; then
    sudo cubesqlctl start
    fi

Leave a Reply

This field is required

This field is required