Quest would like to provide a presentation for the next CAOUG lunch meeting. Please review their suggested possibilities, decide which one you'd be most interested in, and use the Survey Monkey link to let us know which one you chose.
Going Beyond RAC: Increasing Scalability and Reliability with Data Replication
Oracle Real Application Clusters (RAC) is a powerful infrastructure. It enables database scalability, which is useful as data volumes grow exponentially. However, RAC has its limitations in availability, performance, platform flexibility, geography and cost. There are other options when it comes to scalability needs.
Using Oracle replication instead of RAC or in conjunction with RAC enables cost- effective horizontal scalability without the drawbacks of RAC alone. Technologies for real-time data replication enable organizations to have one or more copies of their Oracle databases, which reduces risk and downtime while improving performance and infrastructure options.
Reduce Downtime During Migrations & Upgrades
Although they reap long-term business benefits, migrations are a major availability challenge that companies face today.
Some typical migration situations include:
· Data center &/or server consolidation
· Retiring older technology
· Platform version and application upgrades
Perhaps your company has participated in a merger or acquisition and is experiencing a related data center consolidation. Or you may be considering a change in hardware platform, operating system or application upgrade. How can you reduce downtime in these situations and allow business to continue while the migration activities occur?
Enhance High Availability & Disaster Recovery
Companies need to protect their critical data and files in case of disaster. A loss of data could trigger severe corporate hardships so keeping these systems highly available 24x7 is of the essence. There are many technologies which can accomplish this and some are even “free”. The long-term network costs are where the real spend occurs.
· Can the same hardware can be used to reduce downtime for planned maintenance activities.
· Ensuring that the DR solution will be available when needed requires testing which often involves taking the DR solution offline which can be a costly exercise. Without regular testing, the probability of the DR solution working degrades with time. How to achieve a DR solution that is continuously tested and always available for fail over.
· Often the time to recover from a disaster will seriously affect a company’s bottom line. Fastest methods available for fail over to the DR site in various configurations including peer-to-peer where there is simultaneous access to both databases.
The image of disaster is often interpreted to mean a site based event where the computing infrastructure is physically destroyed. Studies have shown that the vast majority of data loss is not due to these kinds of events. Instead, incidents such as a table drop, block level corruption or even the loss of a data file are some of the leading causes of data loss.
Offload Reporting to an Operational Data Store
Many businesses face conflicting business needs: the need for the fastest possible response time for performing transactions, yet effective and timely decision support and reporting is critical to remain competitive.
These divergent activities often slow the production system to unacceptably low levels especially during peak reporting times such as week, month or quarter end.
How to solve this problem by providing a current and separate target system that can be used as an operational data store for reporting and billing during those peak periods. Transaction processing can continue at the same performance levels and reports can be run with fresh data during regular business hours.
This horizontal scaling strategy allows transaction processing to run without competing with constant queries for reporting needs. Regardless of how much reporting is asked of the system, it will have no effect on response time for your customers and internal users.
When a single replica does not provide the required scaling, additional replicas can be brought on line to further scale and increase performance of reports.
Use this link to vote for your favorite: