Results 1 to 5 of 5

Thread: Monitoring doubts with Database and Ubuntu

  1. #1
    Join Date
    Feb 2014
    Beans
    1

    Monitoring doubts with Database and Ubuntu

    Good days, my company request to me the implementation of a tool for monitoring my network company, the same have two types of databases, Oracle and PostgreSQL database. I thought install Nagios or Hobbit/Symon tool in a Ubuntu system, but I have someone doubts. ¿what types of checks Hobbit provides to me for monitor these databases? and ¿there is documentation about how its checks is configured?. ¿why was better hobbit than nagios?, ¿Somebody can help me?A lot of Thanks

  2. #2
    Join Date
    Nov 2008
    Location
    Boston MetroWest
    Beans
    16,326

    Re: Monitoring doubts with Database and Ubuntu

    If by "monitoring" you mean simply asking whether the server is up, I just use "ps" for this task like this:

    Code:
    ps ax | grep postgres | grep -v grep
    I wrote a little script that runs from cron every fifteen minutes and checks to see if any of a set of programs is not running, i.e., where the command above returns an empty string. The script then tries to restart the program with the "service" command and sends an email notice to me if it fails.

    Now if, by monitoring, you mean checking to see whether the server is functioning properly, perhaps the best test would be a script that ran some common queries against the databases and made sure they returned the correct answers. For this you'd need to write a script to invoke the "psql" client (for PostgreSQL) with a set of test queries.

    This sounds like the kind of goof-ball request from management who throw out a word like "monitoring" as if there is some well-defined method for this task. Ask them what they mean specifically by monitoring before you invest much time in this.
    Last edited by SeijiSensei; February 16th, 2014 at 04:21 PM.
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  3. #3
    Join Date
    Dec 2010
    Beans
    573
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Monitoring doubts with Database and Ubuntu

    Monitoring is a big topic. It can be as simple as a script run by cron that sends an email when something is wrong or as a major implementation of a vendor product from HP, CA or BMC.

    A decent opens source monitoring/alerting app is Nagios. It has a wide variety of modules for gathering information about many common services and send alerts based on criteria you set.

  4. #4
    Join Date
    Oct 2009
    Beans
    Hidden!
    Distro
    Ubuntu 22.04 Jammy Jellyfish

    Re: Monitoring doubts with Database and Ubuntu

    Zabbix is another one, but I've been using Nagios at work for a while now and it is quite effective.
    Come to #ubuntuforums! We have cookies! | Basic Ubuntu Security Guide

    Tomorrow's an illusion and yesterday's a dream, today is a solution...

  5. #5
    Join Date
    Aug 2009
    Location
    Makati City, Philippines
    Beans
    2,269
    Distro
    Xubuntu 16.04 Xenial Xerus

    Re: Monitoring doubts with Database and Ubuntu

    +1 for nagios.
    A bit hard to setup but you can configure to query the database every 5 minutes or so to make sure the database server is running.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •