Building Active/Active SQL cluster-part1
كتبهاmahmoud magdy ، في 6 يناير 2007 الساعة: 11:21 ص
I have searched the internet for a detailed guide on how to implement SQL active/active cluster, I have implemented it couple of time before but It was so strange not finding a detailed and clear guide, most of the current articled that speaks about the subject either talking about windows 2000 clustring, or talking from a general prospective. So If you are looking for a detailed guide this one for you.
in the cluster name specify the cluster name "in my case otdb", click next
in the computer name select hte first node PC, click next.
in the Ip address specify the IP address for the Cluster, click next.
in the cluster service account spcify the account shich the clsuter service will run under it’s priviledge ( i highly recommend that you create a special account for the cluster service and don’t use an administrator account) ,click next
in the quorum disk select the disk which will hold the quorom in my case i chose the E drive and clik next
after the wizard finshes configuring the cluster on the first node open the cluster administrator and verify the succesfull installation.
to add the second node to the Cluster group:
from the File Menu, select new, and select Node:
in the add new node wizard select next.
in the computer name field, type the computer name or browse for the computer, add the computer using the add button, and click next.
after the analyzing configuration wizard finishes, Click next.
in the cluster service account page, specify the cluster service account password, click next:
the wizard will configure the second node and will join it to the existing cluster. there is some ocnfiguration are required for QA the cluster configuration, a etailed list of the QA procedure could be found here:
this is part one, i will continue in the part 2 in building the active/active cluster configuration.
ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
التصنيفات : Cluster | السمات:Cluster
أرسل الإدراج | دوّن الإدراج
يوليو 24th, 2007 at 24 يوليو 2007 6:51 ص
When I install active/active SQL database clustering follow your help, I have 2 virtual sql servers, 2 instances. I want to ask you How can I declare the client connect to cluster databases? Can I use just only once connection to both virtual server or must be use two difference connections to two sql virtual server?
Please help me. I read a lot documents but I can no see anything about that.
Thanks & Regards
يوليو 25th, 2007 at 25 يوليو 2007 3:22 م
I didn’t get your purpose however I htink that you need to connect to a database on a virtual server,
this will be as followin virtualservername\instancename and then you can state your database name.
يوليو 26th, 2007 at 26 يوليو 2007 3:58 ص
I have install 2 virtual sql servers, 2 instances, 1 database.
I have 2 cluster groups, 1 MSDTC group and Group 0 & Group 1 for Data and log disk
The first, I install sqlvirtual1 with instance1 on both node 1 & node 2 and Group0
The second, I install sqlvirtual2 with instance2 on both node2 and Group1
Is it right for active/active clustering?
When a client use connection sqlvirtual1\instance1 to connect to sqlvirtual1\instance1, at that moment just node1 is active and node 2 is standby. But in active/active both 2 server are active. So I don’t know how does it work with that installation in active/active?
Can you show me how to connection for my case or general connection declaration in active/active sql clustering
Thanks & Best regards,
ToanDa
يوليو 26th, 2007 at 26 يوليو 2007 1:30 م
Ok now i got you,
Active active cluster is different than active/passive, because you treat each virtual server as a totally seperate SQL server, but it can fail over to the second cluster node,
so you will need to create a database on the virtual node2 and thus you will have 2 SQL virtual server, instances, and totally 2 seperate databases.
when you access them you have database 1 on virtual server 1 and database 2 on virtual sever2, if server 1 failed, then virtualserver1 will fail over to the server2 that holds virtual server2 and thus server2 will have 2 virtual sql server and 2 instances and 2 databases.
يوليو 27th, 2007 at 27 يوليو 2007 3:00 ص
So my application must declare two connections, first connection is sqlvirtual1\instance1 and second is sqlvirtual2\instance2. My another question is when my application use two connections concurrently to two servers because it is actice/active clustering or just only when the first server (sqlvirtual1) failed, my application will use the second connection (connection to server 2 - sqlvirtual2\instance2)?
And If it right, I must be reconfigure and modified my application to use two connections and failover when the first connection is failed . Currently, it just use only one connection because it use active/passive clustering.
Please help me and confirm that.
Thanks Mahmoud Maqdy so much. I waste a lot of times but can not find out how to solve my problems.
Thanks again.
ToanDa
ps: I registered member on this website, but I can not received email activate. My email is toan_dat@yahoo.com.
يوليو 28th, 2007 at 28 يوليو 2007 8:40 ص
ToanDa,
YOu don’t need to register 2 connections in your application, SQL active active cluster means 2 different servers, totally!!!,
suppose that you application is using DB called DB1 that runs on virtual server1, so in you application you will declare the connection to DB1 on virtualserver1, when a hardware failure occur, virtual server1 will failover to server2, thus server 2 will hold 2 virtual servers, and the application will reamin working and it will connect to virtual server1 but in this case virtual server 1 runs on sever2 instead of the failed server1
يوليو 30th, 2007 at 30 يوليو 2007 2:49 ص
OK, I understand what you mean. So that, If I want to setup SQL Active/Active cluster I must have at least two databases difference (ex: DB1 & DB2), two applications difference and both databases are installed on SQL1 and SQL2. My application 1 connect to SQL1 and application 2 connect to SQL2.
My mistake is understanding that Active/Active can working concurrently with one database on two servers and now I understand clearly.
Thanks Mahmoud Magdy so much.
Best regards,
ToanDa
مارس 31st, 2008 at 31 مارس 2008 9:55 ص
Hi,
Do you know, is jTDS driver can support connection to this SQL Server Cluster?
Thanks
أكتوبر 13th, 2008 at 13 أكتوبر 2008 1:36 م
Hi there,
I have been reading up on muti-instance, but what I really need is
multi-node. Let me explain.
We have two nodes configured in an active/pasive, using a named instance. So
we have two node ‘entsqlprod1′ and ‘entsqlprod2′ in a named instance of
‘entsqlprod’ with a virtual server of the same.
We are putting in SharePoint and rather the buying an aditional two servers
thought that maybe we could purchase one and have active/active/passive in a
single named instace/virtual server.
The nodes are all HA with 64GB mem and access an HA SAN which is mirrored to
DR site using HP CA.
Can you tell me if adding another active node to our cluster is possible and
it would work as required (if you could point to somewhere I can read from
that would be great to).
Could you email me on adam.zacks@northdoor.co.uk
أكتوبر 14th, 2008 at 14 أكتوبر 2008 7:03 ص
so you want the virtual server to be available across the 3 nodes but active on one and able to failover the second, am I correct.