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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access