October 2, 2011 at 11:43 pm
Hi,
I am new entry for sql server cluster high availability configuration, Please tell me, I want to know how to install cluster & step by step configuration.
Active/Active and Active/Passive - two types, I want to go for ACTIVE/ACTIVE cluster
we have SAN storage, and make 3 partition for data file, Tlog file and Tempdb file.
1. Primary server (node A)
-----------------
a. Install SQL engine and SSMS
b. configure and restore user database & users
c. Install - New failover clustering installation
d. Add node to a sql server failover clustering
2. Secondary server (node B)
-------------------
a. Install SQL engine and SSMS
Please tell me, what are the requirement required for Node B server? how to tested node A,B successfully configure cluster? Primary & secondary server Is it required default instance or named instance?
Thanks in advance
ananda
October 2, 2011 at 11:49 pm
Active/Active cluster is no different from active/passive.
It's just that in Active/active, one instance (say instance 1) runs on one node(say node a) and the other one (say instance 2) runs on second node (say node b), so at a given time, both nodes are active.
October 3, 2011 at 12:29 am
Thank you for reply.. please tell me, I had mention some points are in first post for cluster configuration. these are correct or not? Does whatever user database in Node A, that same database have to manually configure at Node B server?
Thanks
ananda
October 3, 2011 at 5:30 am
October 3, 2011 at 7:32 am
ananda.murugesan (10/2/2011)
Hi,I am new entry for sql server cluster high availability configuration, Please tell me, I want to know how to install cluster & step by step configuration.
Active/Active and Active/Passive - two types, I want to go for ACTIVE/ACTIVE cluster
we have SAN storage, and make 3 partition for data file, Tlog file and Tempdb file.
1. Primary server (node A)
-----------------
a. Install SQL engine and SSMS
b. configure and restore user database & users
c. Install - New failover clustering installation
d. Add node to a sql server failover clustering
2. Secondary server (node B)
-------------------
a. Install SQL engine and SSMS
Please tell me, what are the requirement required for Node B server? how to tested node A,B successfully configure cluster? Primary & secondary server Is it required default instance or named instance?
Thanks in advance
ananda
Follow my guide for the parts you need starting at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 4:31 am
SQL Server uses what is called a 'shared nothing' approach to clustering. If you have Instance 1 running on node A then it has exclusive use of the databases and memory it uses. Instance 2 on node B has exclusive use of different databases.
A common scenario for using a two-node active/active cluster is for SQL transactional replication. You have the publisher database running on node A and the distributer database running on node B. This means you make use of the CPU power of both servers, and if one of the servers fails you still have replication running OK.
Another common scenario is where you have at least 3 servers in a cluster and allocate a given database to a given server. If one of the servers fails then it will automatically fail over to another server in the cluster.
FineBuild can do most of the work in taking a clean Windows cluster and configuring MSDTC, installing and configuring SQL Server to run in a cluster. However, FineBuild cannot give you the skills you will need to run the cluster and troubleshoot the problems that time will bring to you.
The best thing anybody new to clustering can do is to get hold of two guest machines, build a windows cluster, then break it and try to fix it. After about a month of building, breaking and fixing cluster problems with and without SQL Server installed you are probably about capable of supporting a production SQL Server cluster.
Enjoy.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply