March 15, 2010 at 11:32 am
Hi , I have 2 SQL Servers with the Databases ... i want to have a sinfle IP address with refelcts the 2 servers
Can someone please explain ..how can i do this ..
thanks
john
March 15, 2010 at 11:40 am
John Paul-702936 (3/15/2010)
Hi , I have 2 SQL Servers with the Databases ... i want to have a sinfle IP address with refelcts the 2 serversCan someone please explain ..how can i do this ..
thanks
john
Are they both installed on the same machine? If yes, then they both would have the same IP - but different ports
Are the two servers on different networks? Then they could both have the same IP address, but would need some additional network architecture to make them work.
Are the two servers in a cluster? If yes, then the two servers would have the same Virtual server name and same IP address.
Is one server a standby server? If yes, then it can have the same IP, so long as it is not active on the network. A different option would be to have a mechanism in place to fail over a cname in case the standby server needed to become the primary - in which case both servers would have different IP addresses.
Otherwise, servers on the same network do not have the same IP address.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:40 am
maybe you are refering to clustering?
clustering takes two or more servers, each with their real IP, and sets up a service so that they share any requests being services on a new virtual server at a specific IP.
It sounds like that is what you want to look into.
as an example, I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be on IP1 and IP2, but the Cluster Service runs on IP3; if the server on IP1 goes down, traffic is sent to IP2 ultil the service is back up. clients still connect to IP3, but never know whether there was an issue on SERVERA, other than a momentary delay as the service redirects traffic.
Lowell
March 15, 2010 at 11:49 am
Hi
What Lowell was telling is extract that matches my requirement
I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be on IP1 and IP2, but the Cluster Service runs on IP3; if the server on IP1 goes down, traffic is sent to IP2 ultil the service is back up. clients still connect to IP3, but never know whether there was an issue on SERVERA, other than a momentary delay as the service redirects traffic.
The 2 different Servers / Different IP s .. But on Same network ..
Can you please Please tell me How to Implement /Configure this .... Please ...
thanks a Bunch ..
March 15, 2010 at 12:01 pm
John Paul-702936 (3/15/2010)
HiWhat Lowell was telling is extract that matches my requirement
I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be on IP1 and IP2, but the Cluster Service runs on IP3; if the server on IP1 goes down, traffic is sent to IP2 ultil the service is back up. clients still connect to IP3, but never know whether there was an issue on SERVERA, other than a momentary delay as the service redirects traffic.
The 2 different Servers / Different IP s .. But on Same network ..
Can you please Please tell me How to Implement /Configure this .... Please ...
thanks a Bunch ..
So you are looking for a doc on how to implement clustering?
This doc assumes SQL 2008 but has a link in it if you are using SQL 2005
http://msdn.microsoft.com/en-us/library/ms179530.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:06 pm
there's some articles and webcasts here on SSC as well:
i remember reading an article "clustering in 15 minutes" but can't seem to find it.
Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000 [/url]
... spoke extensively about the theory behind clustering a Windows 2000 and SQL Server machine ... 2000 Enterprise to create an Active/Active cluster. These two software components are the minimum requirement in a 2000 environment to cluster SQL Server 2000. If you have not read my article on Clustering SQL Server 2000 from 500 ... do you do an Active/Passive cluster. Essentially, you can follow this guide to cluster your SQL Server but stop before ...
Webcast: 0 to Cluster in 60 Minutes-Clustering Windows and SQL Server [/url]
... we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment ... jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After ... enough information to build you own SQL Server that is highly available.
Lowell
March 15, 2010 at 1:59 pm
Jason and Lowell had already referred very good articles, here is few more for SQL 2008 cluster install though it SQL 2008 the concept is same for cluster.
http://www.mssqltips.com/tip.asp?tip=1687
http://www.mssqltips.com/tip.asp?tip=1698
http://www.mssqltips.com/tip.asp?tip=1709
http://www.mssqltips.com/tip.asp?tip=1721
March 15, 2010 at 2:04 pm
I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be on IP1 and IP2, but the Cluster Service runs on IP3; if the server on IP1 goes down, traffic is sent to IP2 ultil the service is back up. clients still connect to IP3, but never know whether there was an issue on SERVERA, other than a momentary delay as the service redirects traffic.
Yes, may be 15 - 30 seconds depending on the databases sizes, The time it takes to failover is the almost the time taken to recover the databases after failover services to other node.
March 15, 2010 at 4:59 pm
thanks all of you guys for reply .. Even i am new to Clustering Concept . I read some Articles posted by you people ..
I am confused .. that after installing the Cluster .. we need to install the SQL SERVER .. is that correct ..
If Yes .. I have already SQL SERVER running on the PRIMARY MACHINE
I am Confused a Lot today ...
the thing is like .... I have one SERVER name as 'A' ,,,which is Active running now .. and now I have new Server as 'B'..
a databse running on Server "A".. these database need to be Pointed in SERVER "B"
Like :- 2 Servers 1 Database ..
Server A , Server B need to Point to the Database which is in already Actively running on Server "A"
Please can anyone explain or some notes ...
Thanks
John ..
March 15, 2010 at 5:13 pm
With clustering, it will depend on your setup. Let's use an Active Passive setup as an example.
You install clustering services, and then you install SQL Server. SQL Server will see that clustering is enabled and give you the option to install as a clustered Server. During the install of SQL Server, it will install onto both nodes of the cluster (assuming two node cluster).
You will have two Servers, but they will be sharing the resources. The resources will be available to one server at a time. If ServerA fails, then the resources will switch over to ServerB. ServerB will not be able to see those resources until that time.
The Two servers will be accessible to the application via a "virtual" SQL Server Name. This name is how the cluster will see the two servers. One point of contact for the application so the application does not need to check for a heartbeat on ServerA first and then go to ServerB if it doesn't find that heartbeat.
This is not like load-balancing where all servers are available all the time. This is a high-availability solution.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 16, 2010 at 6:10 pm
thanks for reply ...
I Successfully Installed Cluster on the Primary Server "A".. I do check on Cluster Administration ... the Cluster i setup .. the status shows as Online .. which is very good ...
here i have a question : The IpAddress :which ip Addresss we need to use ...
like when i check "Cluster IP Address Properties " --> parameters Tab --> Address Section ???
and second thing is unable to add node : - the Error is .. Unable to add this machine (Operating System Version ) the node system has standard Edition ..
Is there any way to add node .or we need to use enterprise edition OS Only ..
Please...
thanks
John ..
March 16, 2010 at 6:26 pm
Windows Server Enterprise edition is a requirement.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply