Already a member?
Sign in
Location: Fibre Channel Cluster
Discussion: Active/Active Cluster with SQL 05
Keyword tags:
active/active
clustering
Oracle
RAC
SQL
Watch
|
brian_summers |
Active/Active Cluster with SQL 05
Jul 17 2008, 9:44 AM EDT Ah...I found the page :-) Ok but now...per the info above "active/active" is a different concept than Oracle RAC...yes? i.e. Oracle RAC enables multiple nodes to read/write from the same volumes but MS Active/Active clustering does not? Do you find this valuable? |
|
todd_muirhead |
RE: Active/Active Cluster with SQL 05
Jul 17 2008, 3:32 PM EDT Oracle RAC is very different from a SQL Server "Active/Active" cluster. With Oracle RAC all nodes are active at the same time on the same database - accessing the same tables. There is only one copy of the database, which resides on shared storage, and is accessed by the nodes at the same time, but is arbitrated by the cluster layer in RAC. This ensures that data remains consistent and the nodes aren't writing over each other. So the direct answers to your questions are Yes and Yes. Todd Do you find this valuable? |

