Deploying PostgreSQL on a Docker Container

PostgreSQL, often simply "Postgres", is an object-relational database management system (ORDBMS) with an emphasis on extensible and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on... Continue Reading →

Active/Passive MySQL High Availability Pacemaker Cluster with DRBD

High availability means a lot of things, but the primary meaning is contained within the name. Keeping a database available at all times can be a rough challenge, and for certain environments, redundancy is a must. Two of everything is the order of the day. This sounds expensive at first, but a hardware failure at... Continue Reading →

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 ↑