Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stavrama
Starting Member
4 Posts |
 Posted - 2008-07-09 : 07:16:33
|
| Hello everyone,I have a few problems concerning the setup of an active/active cluster. At the moment i am testing this via vmware. I managed to create and run an active/passive cluster with no problems but when i tried to do the same on active/active i faced a problem on the second sql server instance. The problem was that the services for the 2nd instance was always down and the status on the group i installed the 2nd instance was always labeled as failed.So far i have installed win 2003 enterprise edition on 2 servers with server names SQLN1, SQLN2. I set 2 network cards on each server, 1 for the public network and 1 for the private network (heartbeat). I have created 5 shared disks. 1 for the quorum and 2 for each node. On the first i ll install the instance and on the 2nd i ll have it for spare use on each server.On cluster administration i have created a cluster connection with a new ip address and after that everything was ok and the nodes were up and running. So in the cluster i have 5 groups. The cluster group and 4 other labeled as Group 0, 1, 2, 3. Groups 0 and 1 are for the first instance so i gave owner rights on sqln1 and 2 and 3 are for the 2nd instance and i gave them owner rights on sqln2.After that i started the installation of the first sql instance (sql2k5ins1). The version of the sql server i used is Sql server 2005 Standard edition. On the installation i gave a new ip for the sqlserver and a new heartbeat ip. I did the same for the second instance (sql2k5ins2). At that time everything went ok . I created databases on each instance and i could log in to them from a remote machine. The problems start to occur when i test the cluster on a failover situation. So i shutdown sqln2 and even though group 2 and 3 were transfered to sqln1, the services of sql2k5ins2 were down and i couldnt start them. The services didint start even when i open sqln2 and the groups failedbackSo my questions are:1) What is the reason of happening this? Did i miss something since this is the first time i try to setup an active/active cluster and i havent managed to find a descent guide for this.2) When i add the heartbeat ip on the sql server setup, do i need to do anything else? I mean on cluster setup the heartbeat ip is the original i used when i setup the network cards for the heartbeat.3) Is there any book that describes step by step an active/active setup? If yes plz share it here :)The next step is to recreate everything from the beggining but before i do that i thought to post here and get some help. Thanx in advance for your help and soz for the long post. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-09 : 10:13:29
|
| Can you manually force the services to start? It could be that you haven't set the permissions for the second instance properly on the first node and them not starting in this situation would point me to look at this.Not sure if you've seen this?http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx |
 |
|
|
stavrama
Starting Member
4 Posts |
Posted - 2008-07-09 : 12:43:34
|
| Yeah i tried to force start the services with no luck. Plus the services dont start even when i pull the 2nd instance on the primary node.Yeah i have seen this guide but it is mostly for an active/passive setup. I try to find a guide from scratch for active/active. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 22:34:51
|
| Did you check app event log to find out why sql failed to start? Why create two resource groups for each instance? Why set headtbeat ip address for each instance? |
|
|
|
stavrama
Starting Member
4 Posts |
Posted - 2008-07-10 : 01:31:36
|
| The 2 groups for each instance was placed in order to try and split the data files and log files if everything was ok. I have the same question for the heartbeat ip since on the sql setup it asks to give one and i think that the setup cant continue if i dont add 1 there. I am not 100% sure of this though. Right now i am in the process of redoing everything from start so i ll have a more cler view. Btw one more extra question. How can i remove the sql server configuration manager? From add/remove programs and windows clean up utility i can remove everything expect that. Am i missing something? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-10 : 23:43:18
|
| Run sql setup and uncheck that tool from option list. |
|
|
|
stavrama
Starting Member
4 Posts |
Posted - 2008-07-11 : 01:40:43
|
| Ah that simple? Never thought of that to be honest :)Thanx a lot for the info guys. I ll start working on the above. |
|
|
|
|
|
|
Question for Active/active failover cluster setup