Owner's Manual

Database Management 133

Database Management

Introducing Databases

This chapter discusses database management procedures. This discussion includes installation

with the embedded MySQL 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.

Administration Basics

You can download the MySQL administrator and, can get its manual at

dev.mysql.com/downloads/

mysql/5.0.html

(GUI tools and Documentation links). This optional tool has a graphical user

interface, and provides an overview of the MySQL settings. It displays performance indicators

graphically, making it easier to determine and tune server settings.

Start this tool to view databases. When you install the embedded database, installation creates two

databases:

owmetadb

and

owbusdb

. The installation also creates a

root

and

(users

oware

and

owmeta

are created, too).