Avoiding Database Problems
You can take several proactive steps to avoid database problems. System and database server failures can be difficult to predict, but some of the root causes can be monitored. You can monitor how many rows a table gains over time, to monitor database growth. Gradual performance degradation or an available tablespace falling below critical thresholds could be an indication that a failure is imminent. Loss of data can be avoided through the use of data redundancy. Several techniques are available, such as disk mirroring. This is not sufficient, however, unless the failure of a disk mirror, for example, is quickly detected and repaired. The EMS HA Monitors product is one tool for detecting mirror failures.
The database ...
Get UNIX® Fault Management: A Guide for System Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
