Published on October 24, 2022

Monitor when database goes down in your NodeJs application

Monitor when database goes down in your NodeJs application

Almost every NodeJs application requires some data persistence. In a good number of cases, we can go by using a simple JSON, CSV, or even a text file to store our data. However, in most cases, we need a more robust solution that can handle a large amount of data and many requests and allow us to perform complex queries.

This is where databases come in. Databases are a great way to store and retrieve data in a structured form. They are also a great way to perform complex queries and scale our application. However, databases can be a complex topic and can be challenging to set up and maintain.

One of the most common problems with databases is that they can go down and become unavailable for various reasons. As a consequence, our NodeJs application will fail to work correctly and will not be able to retrieve or store data.

In such cases, it's essential to monitor your database activity and notify you and your team when something is wrong. This way, you can take immediate action and fix the problem before it becomes a significant issue.

Fortunately, LogSnag is an excellent tool for this problem as it trivializes tracking events in your NodeJs application and monitoring database outages. With LogSnag, you can easily track your database outages in real-time and notify you and your entire team when something goes wrong.


Setting up LogSnag

  1. Sign up for a free LogSnag account.
  2. Create your first project from the dashboard.
  3. Head to settings and copy your API token.

NodeJs code snippets

Use the following code snippet to track your database outages with LogSnag. Please don't forget to replace the YOUR_API_TOKEN with your API token and update the project and channel names.

Using NodeJs with Axios
const axios = require('axios');
let data = JSON.stringify({
"project": "my-saas",
"channel": "status",
"event": "Database is Down",
"description": "PostgresSQL is down in Oregon",
"icon": "🚨",
"notify": true
});

let config = {
method: 'post',
maxBodyLength: Infinity,
url: 'https://api.logsnag.com/v1/log',
headers: {
'Content-Type': 'application/json',
'Authorization': 'Bearer YOUR_API_TOKEN'
},
data : data
};

axios.request(config)
.then((response) => {
console.log(JSON.stringify(response.data));
})
.catch((error) => {
console.log(error);
});
Using NodeJs with Native
var https = require('follow-redirects').https;
var fs = require('fs');

var options = {
'method': 'POST',
'hostname': 'api.logsnag.com',
'path': '/v1/log',
'headers': {
'Content-Type': 'application/json',
'Authorization': 'Bearer YOUR_API_TOKEN'
},
'maxRedirects': 20
};

var req = https.request(options, function (res) {
var chunks = [];

res.on("data", function (chunk) {
chunks.push(chunk);
});

res.on("end", function (chunk) {
var body = Buffer.concat(chunks);
console.log(body.toString());
});

res.on("error", function (error) {
console.error(error);
});
});

var postData = JSON.stringify({
"project": "my-saas",
"channel": "status",
"event": "Database is Down",
"description": "PostgresSQL is down in Oregon",
"icon": "🚨",
"notify": true
});

req.write(postData);

req.end();
Using NodeJs with Request
var request = require('request');
var options = {
'method': 'POST',
'url': 'https://api.logsnag.com/v1/log',
'headers': {
'Content-Type': 'application/json',
'Authorization': 'Bearer YOUR_API_TOKEN'
},
body: JSON.stringify({
"project": "my-saas",
"channel": "status",
"event": "Database is Down",
"description": "PostgresSQL is down in Oregon",
"icon": "🚨",
"notify": true
})

};
request(options, function (error, response) {
if (error) throw new Error(error);
console.log(response.body);
});
Using NodeJs with Unirest
var unirest = require('unirest');
var req = unirest('POST', 'https://api.logsnag.com/v1/log')
.headers({
'Content-Type': 'application/json',
'Authorization': 'Bearer YOUR_API_TOKEN'
})
.send(JSON.stringify({
"project": "my-saas",
"channel": "status",
"event": "Database is Down",
"description": "PostgresSQL is down in Oregon",
"icon": "🚨",
"notify": true
}))
.end(function (res) {
if (res.error) throw new Error(res.error);
console.log(res.raw_body);
});

NodeJs integration details

LogSnag is a powerful real-time event tracking tool that works seamlessly with NodeJs applications. It provides a number of features such as real-time event tracking, cross-platform push notifications, event filtering, user and product journeys, charts and analytics, and much more.

By being a use-case agnostic event tracking tool, LogSnag allows you to track any event in your NodeJs applications in any way you want. You can track your database outages, system status, and even user activity in real-time.

Other use-cases for LogSnag

  1. Monitor your CI/CD build status for your NodeJs application
  2. Monitor your CPU usage in your NodeJs application
  3. Monitor high disk usage in your NodeJs application
  4. Monitor when a user changes their email address in your NodeJs application
  5. Monitor failed logins in your NodeJs application
  6. Monitor failed payments for your NodeJs application
  7. Monitor memory usage in your NodeJs application
  8. Monitor MySQL downtime in your NodeJs application
  9. Monitor when a new feature is used in your NodeJs application
  10. Monitor your Postgres downtime in your NodeJs application
  11. Monitor Redis downtime in your NodeJs application
  12. Monitor suspicious activity in your NodeJs application
  13. Monitor when a user exceeds the usage limit for your NodeJs service
  14. Monitor when a user is being rate limited in your NodeJs application
  15. Get a notification when your NodeJs code is done executing
  16. Send push notifications to your phone or desktop using NodeJs
  17. Track canceled subscriptions in your NodeJs application
  18. Track your NodeJs cron jobs
  19. Track when a file is uploaded to your NodeJs application
  20. Track when a form is submitted to your NodeJs application
  21. Track payment events via NodeJs
  22. Track user sign in events in NodeJs
  23. Track user signup events via NodeJs
  24. Track waitlist signup events via NodeJs
View all common use-cases with NodeJs