You make a good point, let's say that the disk fails, or you lose power..
or worse.. the SAN is unavailable. Anyway, unless you reduce the risk of
the single point of failure, it doesn't really matter what type of
failover you implement.
Let's say I put the data on the SAN, then cluster the O/S.
I have seen implementations where only the O/S and application is
clustered and the SQL is on a separate DB server that is running a home
grown version of logshipping, cutting logs and copying every 5 mins. Not
to a remote site, but right beside the primary, in order to address just
that type of failure mentioned below. I still believe that SQL2005
solutions would better suit my needs. I have an inkling that they will
need Data Warehousing and On-Demand reporting services. That changes it up
a bit also.
I just don't like being bleeding edge if I can help it.
Lisa A. Hale
Database Administrator
"Craig Jones " <mssqldba-ezmlmshield-x86988621.[Email address protected]
01/30/2006 11:35 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Clustering
Before acting on this e-mail or opening any attachments you are advised to
read
The Caudwell Holdings group of companies' disclaimer at the end of this
e-mail.
=======================================================
I think you need to think out of the box.....the big what if question....
Scenario : You have a 30Gb database (primary) this is log shipped to a
remote
server via log shipping - great.....
You have a severe OS error on the primary, you need to failover,mmm thats
going to take
time and effort to get things right....the business start shouting after
30 mins downtime,
your losing £$£$1000's a second.....
Now think....
You have a second SQL cluster local....mmm, let's simply fail over to the
second node,
your up and running in seconds....get the OS team on the first node to fix
the OS. No need
to do the big failover to the remote, slow link server !!
I believe this paints a very pretty picture....
> Cheers
> __________________________________________________
>
> Craig Jones
> SQL DBA
>
> Phones 4u Limited
> Phones 4u House
> Ore Close
> Lymedale Business Park
> Newcastle-under-Lyme
> Staffordshire ST5 9QD
>
> T: 01782 677 818
> F: 01782 677 709
> M:07917 751 183
> E: craig.[Email address protected]
> W: http://www.phones4u.co.uk
-----Original Message-----
From: Davis Ralph
[mailto:mssqldba-ezmlmshield-x93313400.[Email address protected]
Sent: 30 January 2006 16:25
To: LazyDBA Discussion
Subject: RE: Clustering
I'll say this. Our 2 clusters(IBM 445 8ways - Compaq 8ways before that)
on SQL 2000 and W2K have been running since 2000 and NOT ONCE have they
failed over automatically. Even on the few occasions when the server
was unresponsive, and users could not login, we had to manually push
them over. Seems like a waste of hardware and $$ to me(notwithstanding
the political issues).
I prefer hot standby servers and applying logs. Clusters seem to be a
great thing for COM servers, web servers, etc., but I just don't see it
for database servers. Just my 2 cents.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: LHale
[mailto:mssqldba-ezmlmshield-x6734700.[Email address protected]
Sent: Monday, January 30, 2006 10:13 AM
To: LazyDBA Discussion
Subject: RE: Clustering
Ralph,
What you are telling me is no surprise! It sounds like you don't trust
the
clustering either and that you have taken some steps to ensure that your
are fully redundant. I don't relish setting up a clustered environment
at
this juncture in the life cycle of SQL2000.
Thanks for your input.
Lisa A. Hale
Database Administrator
"Davis Ralph " <mssqldba-ezmlmshield-x17807559.[Email address
protected]
01/30/2006 11:09 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Clustering
I'm not a big fan of clustering because it still has a single point of
failure(disk) and it never seems to fail over when you think it should.
That being said we have 2 clustered SQL servers(Politics!) and about 50
non-clustered. Even with our large web-cluster SQL box we still drop
and apply logs to a failover and BR server for safety.
I favor some form of log shipping.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: LHale
[mailto:mssqldba-ezmlmshield-x18338504.[Email address protected]
Sent: Monday, January 30, 2006 10:05 AM
To: LazyDBA Discussion
Subject: Clustering
I would like to pick the brains of anyone that is successfully running
SQL
in a Clustered environment. What were the hitches? Would you recommend
doing this? Is the SQL2005 Mirroring option or logshipping a better
option?
As I stated, I just want opinions at this point. Some discussion has
come
up regarding this possibility and I wanted to have some dba input. My
personal input is biased and I wanted to see how the rest of the DBA's
out
there felt.
Thanks
Lisa Hale
SQL DBA
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon
this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
delete
the material from any computer.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon
this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
delete
the material from any computer.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
=======================================================
Confidentiality Notice
This e-mail is confidential and intended for the use of the named
recipient only. If you are not the intended recipient please notify us by
telephone immediately on +44(0)1782 600600 or return it to us by e-mail.
Please then delete it from your system and note that any use,
dissemination, forwarding, printing or copying is strictly prohibited. Any
views or opinions are solely those of the author and do not necessarily
represent those of The Caudwell Holdings group of companies.
Encryptions and Viruses
Please note that this e-mail and any attachments have not been encrypted.
They may therefore be liable to be compromised. Please also note that it
is your responsibility to scan this e-mail and any attachments for
viruses. We do not, to the extent permitted by law, accept any liability
(whether in contract, negligence or otherwise) for any virus infection
and/or external compromise of security and/or confidentiality in relation
to transmissions sent by e-mail.
Monitoring
Activity and use of The Caudwell Holdings group of companies' systems is
monitored to secure its effective use and operation and for other lawful
business purposes. Communications using these systems will also be
monitored and may be recorded to secure effective use and operation and
for other lawful business purposes.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page