Monitor when database goes down in your PHP application

LogSnag makes it easy to track your PHP application and monitor when your database goes down.

Almost every PHP 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 PHP 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 PHP 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.

PHP 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 PHP with cURL
<?php

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://api.logsnag.com/v1/log',
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'POST',
  CURLOPT_POSTFIELDS =>'{"project":"my-saas","channel":"status","event":"Database is Down","description":"PostgresSQL is down in Oregon","icon":"🚨","notify":true}',
  CURLOPT_HTTPHEADER => array(
    'Content-Type: application/json',
    'Authorization: Bearer YOUR_API_TOKEN'
  ),
));

$response = curl_exec($curl);

curl_close($curl);
echo $response;
Using PHP with Guzzle
<?php
$client = new Client();
$headers = [
  'Content-Type' => 'application/json',
  'Authorization' => 'Bearer YOUR_API_TOKEN'
];
$body = '{
  "project": "my-saas",
  "channel": "status",
  "event": "Database is Down",
  "description": "PostgresSQL is down in Oregon",
  "icon": "🚨",
  "notify": true
}';
$request = new Request('POST', 'https://api.logsnag.com/v1/log', $headers, $body);
$res = $client->sendAsync($request)->wait();
echo $res->getBody();
Using PHP with HTTP_Request2
<?php
require_once 'HTTP/Request2.php';
$request = new HTTP_Request2();
$request->setUrl('https://api.logsnag.com/v1/log');
$request->setMethod(HTTP_Request2::METHOD_POST);
$request->setConfig(array(
  'follow_redirects' => TRUE
));
$request->setHeader(array(
  'Content-Type' => 'application/json',
  'Authorization' => 'Bearer YOUR_API_TOKEN'
));
$request->setBody('{"project":"my-saas","channel":"status","event":"Database is Down","description":"PostgresSQL is down in Oregon","icon":"🚨","notify":true}');
try {
  $response = $request->send();
  if ($response->getStatus() == 200) {
    echo $response->getBody();
  }
  else {
    echo 'Unexpected HTTP status: ' . $response->getStatus() . ' ' .
    $response->getReasonPhrase();
  }
}
catch(HTTP_Request2_Exception $e) {
  echo 'Error: ' . $e->getMessage();
}
Using PHP with pecl_http
<?php
$client = new http\Client;
$request = new http\Client\Request;
$request->setRequestUrl('https://api.logsnag.com/v1/log');
$request->setRequestMethod('POST');
$body = new http\Message\Body;
$body->append('{"project":"my-saas","channel":"status","event":"Database is Down","description":"PostgresSQL is down in Oregon","icon":"🚨","notify":true}');
$request->setBody($body);
$request->setOptions(array());
$request->setHeaders(array(
  'Content-Type' => 'application/json',
  'Authorization' => 'Bearer YOUR_API_TOKEN'
));
$client->enqueue($request)->send();
$response = $client->getResponse();
echo $response->getBody();

PHP integration details

LogSnag is a powerful real-time event tracking tool that works seamlessly with PHP 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 PHP 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. Track payment events via PHP

  2. Track user signup events via PHP

  3. Track your PHP cron jobs

  4. Track waitlist signup events via PHP

  5. Track user sign in events in PHP

  6. Get a notification when your PHP code is done executing

  7. Monitor when a user exceeds the usage limit for your PHP service

  8. Monitor when a new feature is used in your PHP application

  9. Monitor suspicious activity in your PHP application

  10. Monitor when a user is being rate limited in your PHP application

  11. Monitor your CPU usage in your PHP application

  12. Monitor memory usage in your PHP application

  13. Monitor high disk usage in your PHP application

  14. Track when a file is uploaded to your PHP application

  15. Track when a form is submitted to your PHP application

  16. Track canceled subscriptions in your PHP application

  17. Monitor failed payments for your PHP application

  18. Monitor your CI/CD build status for your PHP application

  19. Monitor when a user changes their email address in your PHP application

  20. Monitor Redis downtime in your PHP application

    View all common use-cases with PHP