Database Management

9

Introducing Databases

Database Timeout

Embedded Database Sizing

Modifying the MySQL File Systems

Database Backup / Restoration

Failover

Introducing Databases

This chapter discusses database management procedures. This discussion includes installation both with the embedded MySQL database and the supported Oracle database.

In addition to correctly sizing your database, best practice is to develop a plan to regularly back up the database, including steps to verify this backup with recovery. The frequency of backups depends upon your environment, but you should back up often enough to minimize data loss.

The following describes administration for the basic database, installed with the application. If your system has the optional performance monitoring add-on, then you may also want to install a separate database for performance data. Consult the performance monitoring chapter in the User Guide for instructions about how to do this.