August 25, 2010 at 5:32 am
We have a DB server running 5 instances of SQL Server. I would now like to migrate these 5 instances to a 2 node cluster to get the benefit of high availability. The 5 instances cannot (easily) be consolidated into one. I would prefer to run SQL Server standard edition on the cluster.
Is it possible to make several clustered instances share the same logical disks? I really don't want to have to split my storage array into 5 different data disks and 5 different log disks, as that would waste a lot of disk space, and in my eyes, just make the whole setup more complex to manage, how can I get around this?
Does SQL Serve Standard Edition support Active/Active clustering, so that I could run 2 instances on one node and the last 3 on the other node?
August 25, 2010 at 6:36 am
christerst (8/25/2010)
Is it possible to make several clustered instances share the same logical disks?
No, that's not how clustering works. Separate storage is required for each instance and ultimately its cluster group
christerst (8/25/2010)
in my eyes, just make the whole setup more complex to manage
welcome to the world of failover clusters!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:16 am
And yes, you can Active/Active as you describe with multiple nodes on one cluster unit. Just be sure to scope out the hardware/configure SQL settings so you can function should you lose one node and all five are running on the other.
August 25, 2010 at 2:01 pm
Realistically, if you're moving everything to a new physical server anyway, it would seem like the same amount of work to consolidate databases onto 2-3 instances...actually, probably less. Remember, the fewer instances you have running, the less you'll have to divide up memory among them and potentially run low on one while the other has a PLE of 4 days.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply