MySQL Connection Usage

By default 151 is the maximum permitted number of simultaneous client connections in MySQL 5.5. If you reach the limit of max_connections you will get the “Too many connections” error when you to try to connect to your MySQL server – which means all available connections are in use by other clients. MySQL permits one extra connection on top of the... Continue Reading →

PostgreSQL Point-in-time Recovery (Incremental Backup)

PostgreSQL “Point-in-time Recovery” (PITR) also called as incremental database backup , online backup or may be archive backup. At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_wal/ subdirectory of the cluster's data directory. The log records every change made to the database's data files. This log exists primarily for crash-safety purposes: if the system crashes, the database can... Continue Reading →

MongoDB point-in-time backup and recovery.

In this blog, we describe a procedure that allows you to manually perform a point-in-time restore of MongoDB data. Point-in-time restore refers to the ability to restore the database to a precise moment in time. The instructions presented here require that you have regular backups of your data, and that your data is stored in a... Continue Reading →

Setting up Nagios Monitoring for MSSQL Server

Nagios provides complete monitoring of MSSQL – including availability, database and table sizes, cache ratios, and other key metrics. Implementing effective MSSQL monitoring with Nagios offers the following benefits: Increased application availability Increased database performance Fast detection of database outages, failures, and table corruption Predictive analysis of storage requirements and index performance Downloading & installing... Continue Reading →

Powered by WordPress.com.

Up ↑