January 5, 2021 at 1:41 pm
I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows fail over cluster
i am not sure what should be ideal architecture and how to proceed with further
any one has detailed idea and if can help me would be greatful
January 5, 2021 at 7:03 pm
How much time have you spent learning how to install and configure Window Clusters?
If you are using SQL 2019, would Availability Groups server you better?
The first step is to configure the 4 servers in a cluster.
The second step is to configure your shared drives.
Last is to install your instances of SQL Server as a clustered resource.
Clearly there are a lot of details to this, but there are also many learning resources on how to do this that exist.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 5, 2021 at 8:29 pm
You might start here: https://www.sqlservercentral.com/stairways/stairway-to-alwayson
You also will want to set some goals. What is the reason you want 3 instances in some HA config? What constraints or requirements are there? You can't have an architecture without knowing why you are doing this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply