Clustering with RAC
Clustering is ideal for two or more servers that have shared resources, such as disks. In case of a hardware failure on one server in the cluster, the other servers can pick up the workload until that server can be brought back up.
SQL Server clustering is dependent on operating system clustering. The file systems that SQL Server uses for the datafiles need to be on a clustered shared disk, and the software is installed on all of the nodes of the cluster. The SQL Server instance can be active on only one node (server) at a time, but there can be other SQL Server instances active on other nodes. Active/passive clustering is when one SQL Server instance is installed on the cluster and running on one node, and the second node ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
