PMAN — Partition Manager for Oracle Range Partitions
Michael Wang, Julie Wang
The authors describe the benefits of Oracle table partitioning.
Database Protection Using Oracle Data Guard
Aaron Diehl
Diehl describes implementation and monitoring strategies of Oracle’s Data Guard services that can help make database recovery less painful.
Oracle RAC Primer
Chris Page
Page examines how a RAC database environment differs from a conventional Oracle database.
Oracle RAC Isn’t Just for Databases
Chris Page
Page examines Oracle’s clusterware technology and provides a simple configuration for demonstration purposes.
Implementing Highly Available Oracle Databases with Red Hat Cluster Suite
Sergey Nemirovsky
Nemirovsky explains the capabilities and limitations of Red Hat Cluster Suite in reducing downtime and improving availability of Oracle databases.
Building a Bulletproof Penguin: DB2 and Linux Failover
Joe La Chapell, JT Vogt
Implementing a new enterprise resource planning (ERP) system that will impact every division of a company is an intriguing proposition. A lot is expected of such a system, and when we were tasked with this undertaking at our company, we did not want to neglect the foundation of it -- the database. As we researched this project, it became evident that we could satisfy all the necessary requirements with a combination of products: IBM DB2, Red Hat Linux, as well as Heartbeat, Mon, and ipfail. In this article, I will describe how we built a "bulletproof penguin" one piece at a time.
Restoring Your Confidence in Oracle Backups
John Ouellette
Wouldn't it be great to be able to rely on your backups and have full confidence that they will work properly during a disaster or a routine restore operation? Unfortunately, making assumptions about your restores can lead to delays in projects, wasted time, and ultimately data loss. While it may be fairly easy to configure backups and assume the restore process will work as long as the backups have run successfully, the reality is that each process is different and involves its own set of challenges.
MySQL 5.0 Cluster: Architecture, Implementation, and Management
Norm Collins
Today's networks and applications are concentrating more on high availability and redundancy. Corporations are selling services to customers with a "guarantee", or "service-level agreement" (SLA), that provides an overall percentage of uptime along with detailed instructions on the rebate structure if certain conditions are not met. One of the key components in the delivery of information to customers is the availability of data from a robust and effective database management system (DBMS).
Getting to Know Your Network -- Part II
Luis E. Munoz
In the first article of this series, I showed how to build a script, aconfig, which allowed us to quickly execute commands on network devices. It also allowed us to use Perl to generate commands on the fly and process the result of those commands. To tell aconfig what to do, I wrote some small snippets of configuration commands, called ascripts. Those ascripts are used to gather version and configuration information from the network devices. In this article, I'll take the process one step further and build all this into a neat network inventory. (The complete listings for this article are available from the Sys Admin Web site at: http://www.sysadminmag.com.)
Veritas Volume Manager Recovery Features
Ryan Matteson
Veritas Volume Manager (VxVM) has become the standard Logical Volume Manager (LVM) in many enterprises for its robust feature set, its ability to run on multiple operating systems (e.g., HP-UX, Linux, Solaris, Windows), and the numerous scalability, availability, and recoverability features that come with the base product. The recoverability features help to ensure that data is protected when hardware platforms fail and to ease the process required to restore systems to an operational state.
- More -
|
|
 |
|
Find white papers, case studies, Webcasts and analyst reports on everything from design through development to testing and implementation at Sys Admin's Research Papers and Reports.
|
|
