The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.
Course Of The Month
9 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Limited distance between 2 nodes in a cluster using Oracle RAC 11gR2
Posted on 2010-11-16
Hi,
My company are buying a multimedia content management system. We want to deploying it on 2 sites (their distance = 1500km) and want to sync database between them. Each site is a complete system that can work without other site. The system requirement for database on this system is Oracle RAC 11gR2. I find some info on google which said that 2 nodes in a cluster must be < 100 km but i can't verify this.
If this info is true, is there other solution else to synchronize database between 2 or more very far sites ?
Oh, the most important thing i want to know is limited distace between 2 nodes.
Thx
My company are buying a multimedia content management system. We want to deploying it on 2 sites (their distance = 1500km) and want to sync database between them. Each site is a complete system that can work without other site. The system requirement for database on this system is Oracle RAC 11gR2. I find some info on google which said that 2 nodes in a cluster must be < 100 km but i can't verify this.
If this info is true, is there other solution else to synchronize database between 2 or more very far sites ?
Oh, the most important thing i want to know is limited distace between 2 nodes.
Thx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Since RAC shares a disk sub-system you would need some disk management what could span this distance in a pretty efficient manner. That is likely the limiting factor. It also needs a quick heartbeat interconnect.
As far as a remote sync I would look at streams replication or if one of the remote databases can be read-only, take a look at active dataguard.
As far as a remote sync I would look at streams replication or if one of the remote databases can be read-only, take a look at active dataguard.
Oracle RAC is very sensitive, From experience if the cluster has issues with the interconnect they will recommend that all nodes connect to the same switch. You may have failover interconnects going to a different switch but all primaries should be on the same switch and all failover interconnects should be on the same switch. Also they recommend a 1g minimum connection.
Oh, the most important thing i want to know is limited distace between 2 nodes.
=> One thing i can recommend is, make sure that ping time between/among the RAC nodes is less than 25 milliseconds. Usually, in all RAC implementations, we see this to be less than a milli second. :)
Hope that answers your question about the distance.
Another piece of note:
Despite the all RAC nodes being in the same data center, many times we had to increase the CSS timeout from its default 60 seconds to avoid node evictions.
As jgiordano said, RAC is very sensitive.
=> One thing i can recommend is, make sure that ping time between/among the RAC nodes is less than 25 milliseconds. Usually, in all RAC implementations, we see this to be less than a milli second. :)
Hope that answers your question about the distance.
Another piece of note:
Despite the all RAC nodes being in the same data center, many times we had to increase the CSS timeout from its default 60 seconds to avoid node evictions.
As jgiordano said, RAC is very sensitive.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
- Databases
- Oracle Database
- Acronis
- MongoDB
- Oracle
- *Backup Software
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 1 hour left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.