Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

2 node RAC vs Master <-> Slave failover

jfbaro-JavaNetFeb 19 2013 — edited Feb 19 2013
Hi there,

I always heard Oracle RAC is a super robust solution when it comes to availability, but how does it (2 node Oracle RAC) compare to MySQL Master-Slave configuration?

They say MySQL Master/Slave can failover in about 5 to 10 seconds, and no data is lost. So the application would drop some connections for 5 to 10 seconds.

What about RAC, is it a zero downtime solution? Would it keep the connections running even if the client was connected to the "faulty" server?

In summary, what makes Oracle RAC (2 nodes) so much better than other solutions (regarding Availability only)?

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2013
Added on Feb 19 2013
6 comments
978 views