2 node RAC vs Master <-> Slave failover
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