multi instance failover clustering (sql server)

Question

just want to straighten my concept properly - when we are talking about SQL multi instance failover cluster, e.g. on a 2 node cluster, it means that each node can run its own sql instance, but each instances are running its own database right ?

e.g. 2 nodes (node1, node2)
sql instance A on node1
sql instance B on node2

sql instance A and B are individual instances and are not sharing the same database right ?

when node1 is down, SQL instance A will move to node2 but both sql instance A and B are still separate databases - right ?

Answer 1

That's correct. A traditional failover cluster may contain multiple instances, and each instance may contain multiple databases. A database is part of only one instance, and an instance only runs on one node at a time.