In a hypothetical scenerio:
I want 4 node, active/active/active/active cluster.
There are 4 sql instances installed on each node, with name SQLInstance1....
1) Can I use just one virtual name, for example SQLVirtualServer and clients
can access sql instances in format SQLVirtualServer\InstnaceName? Or Do I
need to create separate pair or virtual name/IP for each sql instance?
How many total IP addresses/hostnames I will need in 4 nodes/instances
2) Each instance will be active on one node and other three nodes will in
stand by mode for that instance? Or there can be only on node in stand by for
3) if there can be multiple nodes stand by, how it is determined which node
will take over in case of a failure?
I would really appreciate any responses.