How to monitor database for uptime? [closed]

Question

Yes, you can set up a free method to check if your WordPress database is online and get an email if the site shows the “Error Establishing a Database Connection” message. You can achieve this by adding a simple PHP script to your WordPress theme or via a custom plugin.
Step-by-Step Solution:

Create a Custom Plugin or Add Code to functions.php: You can either create a custom plugin or add the following code to your theme’s functions.php file. The code will check the database connection periodically and send an email if it fails.

Add the Database Check Code:

Add this code to your functions.php or create a new plugin with it:

 <?php

function check_db_connection() {
    global $wpdb;

    // Attempt to connect to the database
    if (is_wp_error($wpdb->db_connect())) {
        // Send email notification if there's a problem with the database connection
        $to = '[email protected]';
        $subject="WordPress Database Connection Error";
        $message="Your WordPress site is currently having issues establishing a database connection.";
        $headers="From: Your Site <[email protected]>" . "\r\n";

        wp_mail($to, $subject, $message, $headers);
    }
}

// Hook this function to run periodically using WordPress cron jobs
add_action('check_db_connection_hook', 'check_db_connection');

// Schedule the event if it's not already scheduled
if (!wp_next_scheduled('check_db_connection_hook')) {
    wp_schedule_event(time(), 'hourly', 'check_db_connection_hook');
}

Explanation:

This code uses WordPress’s $wpdb object to check the database connection.

If the connection fails (checked using is_wp_error()), it sends an email notification to your specified email address.

The check is scheduled to run hourly using WordPress’s cron system.

Set Up Email:

Make sure to replace ‘[email protected]‘ with your actual email address.

To ensure that emails are sent correctly, you can install an SMTP plugin like WP Mail SMTP if your hosting has issues with PHP’s mail() function.

Activate WordPress Cron Jobs: WordPress’s cron system works when a visitor accesses your site, so if your site has low traffic, it may not run often enough. To make sure the cron jobs run regularly, you can set up a real cron job on your server (optional).

On Linux servers, add this to your crontab to trigger WordPress cron every hour:

bash

wget -q -O - http://yourdomain.com/wp-cron.php?doing_wp_cron > /dev/null 2>&1

Adjust the Check Frequency (Optional): If you want the checks to occur more or less frequently, you can change the schedule in wp_schedule_event(). Possible values are hourly, twicedaily, or daily.

Now, your WordPress site will automatically check the database connection and send you an email if it detects an issue.

Related Posts: