| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-08-16 : 14:08:22
|
| GurusI am just learning how to set up failover clustering,And i know log shipping also.Client has given me the request to implement failover clustering.What are the beneffits or disadvantages between logshipping and failover clustering?Plz explainRegardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 14:21:24
|
| We use both on our cluster. We use clustering for failovers and maintenance at our primary site. We then use log shipping to copy the data out to our disaster recovery site where we have a duplicate cluster setup out there. Clustering is more for hardware failures on one server and the ability to install patches/security patches/etc... with minimal downtime on the database server. Log shipping is more for disastery recovery purposes. So it depends on what you want and neeed.Tara Kizer |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-16 : 14:35:21
|
| Yes tara Got it,Tara Client has asked baout failover clustering.Can you please explain what do we exac do in this?I am gathering info from the google but not able to understand what exactly is clustering.We have two servers with us.Configurations:Power edge 1850,Dual Xeon Processors2 HDs of 43gb and 24gb2.79ghz4gb ram2nd server1 HD of 24.9gb2.79ghz4gb ramPlease advice how do i go about thisRegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 14:36:40
|
| Clustering is way too complex to explain on a forum. It would take quite a bit of time to explain it. I'd highly recommend hiring a consultant to help you with this as it is not something that you can easily learn.Tara Kizer |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-16 : 14:39:05
|
| Can i speak to you in someway?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 14:43:12
|
| No. I'm only available via the forums.Tara Kizer |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-16 : 14:48:50
|
| Ohh..Thanks Tara,but if you can write to me at nitin1353@gmail.com it will be great.RegardsNitin |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-08-16 : 15:04:20
|
| With clustering, I highly reccomend getting a vendor to come in and install your cluster for you.The key to clustering is shared storage. There must be a set of disks that can be see by both servers at the same time. So, that's where you start getting into SAN's or some smart Direct Attached Storage (DAS).I highly reccomend getting a consultant to come in and setup, install, and test the cluster.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-08-16 : 18:43:13
|
| For what its worth I have the same type of setup to yours ntini, we have two similar servers to yours holding a semi-critical product maintenance database, initially I was thinking of failover clustering and log shippiing but as the goddess says it seemed quiet intense for me to do without a consulstant at hand, I created a job to do a automated backup to the second server with 1 hard drive / restore after backup finishes and have a one hour old semi-live version running on the 2nd srv.not the most glamerous setup but really you have only got 2 servers similar to myself...........but we do have logshipping into a business continuity suite which is good peace of mind. |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-16 : 20:49:36
|
| Hey Jimi understand but i have got plenty of time and i have a dedicated network team with me,so i will go ahead with this.Thanks for your valuable suggestionsRegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 21:20:29
|
Good luck with that. Let us know when you've got it working. It would be interesting to see how many weeks have passed.I've been working on our test cluster for the past 8 hours now and still haven't got SQL Server installed (well I've got one instance installed now, now need 5 more to be completed). I've been working with both our production and test server administrators plus Microsoft.  Tara Kizer |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-17 : 00:08:06
|
No help here, just a rant.  I really hate that Microsoft had the nerve to call it “clustering”. A better name would be “hot standby server with shared storage that kind-of works”.Digital introduced clusters in 1983, and a cluster-aware relational database, Rdb, in 1984, so it is hardly a new idea. You could have a 16 node cluster with the database active on all nodes, and database object locks honored across all nodes in the cluster. The same file could be opened with shared locks visible to all nodes in the cluster. By 1986, they could be clustered on a LAN without physically shared storage. VMS now supports disaster-tolerant clusters with nodes up to 500 miles apart and up to 96 nodes in the cluster. The best part is that VMS clusters work, usually with no trouble.If you have any interest in reading about what we are missing:http://h71000.www7.hp.com/openvms/products/clusters/index.htmlSo now it’s 20 years later, and Microsoft still hasn’t even come close to matching 20 year old technology. I wouldn’t really mind, but the fact that they call it “clustering” really sets me off.CODO ERGO SUM |
|
|
|
|
failover clustering and log shipping