Home > Oracle Database / Applications Tips > Oracle database administrator > Replication for high availability
Oracle Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ORACLE DATABASE ADMINISTRATOR

Replication for high availability


Rick Cook
03.14.2005
Rating: -2.59- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


This tip reprinted courtesy of SearchStorage.com.

Replication for high availability can be simple and cheap or it can be elaborate and expensive. It all depends on what you want to replicate -- and what you consider to be acceptable performance.

When it comes to replication, there are solutions available for every taste and budget. They range from near real-time mirroring to a local server (or a server at a remote location), to host-based replication software that automatically switches to replicated data when it detects a problem, to simple RAID-1 mirroring. Needless to say, the prices run the gamut as well.

But how high is high availability? This is sort of like asking how high is up. The first thing you need to do is to establish measurable criteria for your replication system. Then you need to consider the possible solutions in terms of those criteria.

For high-availability replication, those criteria usually boil down to fault tolerance and speed. Ask yourself these questions:

  • How fault tolerant does your system need to be? Is it enough if your system can survive an array or server failure, or do you need a system that will keep your data available if the next hurricane levels your data center?
  • How quickly do you need data back? Although replication implies a copy of your data, it can take time to access it. For example, it takes time to remount and bring back up a DBMS even if all the data is completely replicated.
  • How close to the failure point does your recovery point need to be? A replication system that can roll back to the state it was in at midnight is a lot cheaper than one that rolls back to an hour ago, and one that rolls back an hour is much cheaper than a system with a recovery point measured in seconds.
Obviously, these kinds of decisions involve more than the storage administrator. It's important that everyone deciding the rollback and degree of fault tolerance understands the cost effects of those parameters.

To take one example, the fastest replication solutions usually require identical hardware. This is not only expensive, but keeping the hardware identical poses a maintenance problem.

Remote replication imposes speed (and cost) penalties because of the limited link bandwidth, but it can keep you going when the next big one wipes out your whole data center.

Finally, you need to decide what to replicate. You can replicate everything, of course, but most of the time you don't need to. Even if you do need to replicate everything, you almost certainly don't need everything back in the same time frame. That offers opportunities for cost savings.

About the author

Rick Cook has been writing about mass storage since the days when the term meant an 80 K floppy disk. The computers he learned on used ferrite cores and magnetic drums. For the last 20 years, he has been a freelance writer specializing in storage and other computer issues.

Rate this Tip
To rate tips, you must be a member of SearchOracle.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Oracle database administrator
Understanding SQL string functions
What is the difference between a database engineer, architect and administrator?
Import on one table from dump file
Error during RMAN backup
Can I drop a column in SYS schema?
STATSPACK tool: transaction vs. execution measurement
Should I port from Microsoft Access?
Installing multiple Oracle homes
How can I find statistics on total memory usage and database connections?
Modifying SYS password in a RAC environment

Oracle database backup and recovery
Can I perform an Oracle server backup through a client machine?
How to execute DML in an Oracle trigger with EXECUTE IMMEDIATE
How to restore a dump file with the Oracle SHOW=Y option
Why do I get an Oracle not available error with Oracle 8i on Windows?
Oracle tutorial library: SearchOracle.com's learning guides
How to perform Oracle database recovery with a corrupt online redo log
Can I create an Oracle Catalog Database with the Enterprise Console?
Do I need to recreate views after an Oracle table reorg?
Client-based apps vs. web-based apps in Developer 2000
How to perform an Oracle 8i to 10g migration
Oracle database backup and recovery Research

Oracle database availability
Review: Oracle's 11g R2 database has some good and bad
Oracle releases new database, says 11g upgrade will cut costs
Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux
Data modeling tools no substitute for hard work
Oracle RMAN case study: Improving backup and recovery efficiency
Oracle and the rise of the virtual machine
Using connection load balancing with Oracle RAC
Grid computing adoption slow amid fears of complexity
DBA 102: Beyond the basics
Difference between Oracle RAC and Data Guard
Oracle database availability Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Oracle Development Solutions - SQL, J2EE, XML, SOA
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts