Price: $250 US

The RP MySQL Maintenance Package provides a set of scripts designed to automate essential maintenance tasks on your MySQL database server. These scripts combine best-of-breed open-source with custom features and integrations by Reliable Penguin.

Tuning Report

Generates a weekly email report which provides guidance on how to improve performance of your server. The tuning report looks at over 20 configuration settings and performance counters. This script will eliminate much of the guess work involved in tuning memory allocation.

Optimize

Run this script daily to perform table optimization. A commonly overlooked way to improve performance in index optimization. This script optimizes each and every database table. It's run automatically each day from a Cron job.

Check

Run daily to check table status and report problems. Instead of waiting for problems to escalate into a crisis, this script checks the integrity of each table daily and sends an email alert if any problem is found.

Backups

Provides comprehensive backups of your databases including:

» Weekly dump to SQL text file.
» Daily hot backup of binary database files.
» Hourly copies of binary log files.

With these backups most problems can be recovered to the hour or the current day.

Replication Check

Monitors replication status on slave servers and send email alert in the event of an error.

Installation

This package is compatible with all versions of MySQL and can be installed on any Linux server. Installation by Reliable Penguin is included in the price.