By implementing the Best Practices provided in this white paper, HP improved the baseline performance on the OLTP workload by 15% with basic database tuning and up to 7% application performance increase when the redo logs were properly sized for the particular workload. A 16% improvement on the application performance was gained by increasing the bandwidth for the workload being replicated.
Disk-array-based remote copy infrastructures have been available and in use for over a decade. When properly configured and deployed, they are capable of providing a timely recovery from a variety of failures, including the loss of an entire data center site. The key requirement is the remote copying of databases must be done in concert with the native relational database management system (RDBMS) technology in order for the solution to be practical.
This solution provides a comprehensive set of test-proven best practices for properly configuring, deploying, and operating an Oracle 11g database with Oracle’s Automatic Storage Manager (ASM) on an HP Enterprise Virtual Array (EVA), using Continuous Access (CA) as the remote copy infrastructure.
Specifically, the white paper addresses our findings upon investigating the following fundamental deployment issues:
- The best way to configure an Oracle 11g database on the EVA for replication and how that configuration does or does not differ from standalone (non-replicated) configuration.
- The effect of replication method, bandwidth, latency, and distance on replication behavior.
- The effect of synchronous, asynchronous, and enhanced asynchronous replication on database performance, and the practical considerations for choosing the best method to use.
- The effect of the distance between sites.
- What you need to know about your Oracle application to properly size the remote link.
- Best practices for the major elements of the deployment (servers, storage, interconnect, and database).
The methods and best practices described in this solution are intended to be used to facilitate both the productive planning for and the timely deployment of a fully operational remote copy infrastructure, one that will have:
- Predictable performance characteristics
- Ease of operation
- Satisfactory recoverability capabilities
- Accelerated time to deployment
This white paper is a revisit of the topic as discussed in the previously published white paper Replication Best Practices for Oracle 10g with ASM and EVA8000 which can be found at http://h71028.www7.hp.com/ERC/downloads/4AA1-4941ENW.pdf. Changes to this newer version include upgrading the infrastructure (host bus adapters (HBAs), switches, and EVA controllers) to 4 Gb as well as testing on Oracle 11g Enterprise Edition. In addition, new focus areas include a comparison of optical carriers OC6 and OC9, the impact of the online redo log size, utilization of the write history log, and recovery point objectives (RPOs) for various link latencies.
|
Printable version
