Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Understanding HA Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 4:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:21 PM
Points: 33,202, Visits: 15,350
Comments posted to this topic are about the item Understanding HA






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1455416
Posted Wednesday, May 22, 2013 6:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:14 AM
Points: 5,339, Visits: 3,042
One aspect that is often overlooked in DR is the restarting of applications. Certainly application reinstallation is often thought of but sometimes what is missed is that there will be data that was not processed as one subsystem or other was offline. Pipelines are often overlooked. When you have the SQL Server instance reinstated and the application(s) up and running along with all the expected and required systems will all the part processed data complete?

Are you certain?


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1455445
Posted Wednesday, May 22, 2013 10:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:21 PM
Points: 33,202, Visits: 15,350
Gary Varga (5/22/2013)
One aspect that is often overlooked in DR is the restarting of applications. Certainly application reinstallation is often thought of but sometimes what is missed is that there will be data that was not processed as one subsystem or other was offline. Pipelines are often overlooked. When you have the SQL Server instance reinstated and the application(s) up and running along with all the expected and required systems will all the part processed data complete?

Are you certain?


Great point. Re-startability is certainly something the good SSIS developers look at, but I'm sure there are all sorts of places (replication, data file xfers, linked servers, etc) that might have problems in some configurations.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1455594
Posted Wednesday, May 22, 2013 10:57 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 25, 2014 8:36 AM
Points: 775, Visits: 243
MY worst DR story was from 15+ years ago. Had a server failure at about 5 pm at night before the backups occured. All data changes for that day were lost. My boss and I literially dumpster dived to retrive all the "Red Marked" paperwork that was entered that day.
Post #1455616
Posted Wednesday, May 22, 2013 12:08 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 1:31 PM
Points: 93, Visits: 741
I'm always having issues with project managers asking for HA technologies and trying to pit mirroring vs clustering. My question is always what do you want to protect against?... "Well.. I dunno... I just want ha"
Aaaarrgggg
Post #1455635
Posted Wednesday, May 22, 2013 7:10 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 627, Visits: 2,168
My last company had a yearly requirement to do a "full" DR test. Luckily we had our own offsite DR location so we could do unofficial testing. We also replicated our drives and did our tape backups off the replicated drives. So we had to mount them up every Friday, but didn't attach the databases.

So I could get the databases attached and ready to go in about two hours. (Other non-DBA IT staff took about 4-6 hours off my checklist.)

As far as applications --the hardest one was actually MS's Great Plains to get going. We had to reset every test user's password by hand.

And luckily my managers understood the HA/DR difference. Our primary site were sets of two node clusters where we could do it.

The ability scale out, or spread load are a possibility with a few of these features.


My question is still how to scale out SQL. It never seemed that MS designed the system for multiple access to a DB. So while you can scale up the web servers or number of clients, you are restricted by the controlling instance. I admit I've been out of touch with mainline general production support as I have been supporting my companies SW product which doesn't do well with advanced SQL options.




----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Post #1455778
Posted Thursday, May 23, 2013 2:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 1,664, Visits: 1,093
Bring out the Chaos Monkey!

http://thenextweb.com/insider/2013/03/03/how-your-business-could-learn-from-chaos-monkey/

I'm sure you all know about him, but I just love the name.
Post #1455881
Posted Thursday, May 23, 2013 4:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 1,390, Visits: 6,341
Great article, Chaos Monkey went opensource
Post #1455923
Posted Thursday, May 23, 2013 5:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:14 AM
Points: 5,339, Visits: 3,042
ssimmons 2102 (5/22/2013)
MY worst DR story was from 15+ years ago. Had a server failure at about 5 pm at night before the backups occured. All data changes for that day were lost. My boss and I literially dumpster dived to retrive all the "Red Marked" paperwork that was entered that day.


Major mismatch between IT and manual processes. I bet it was only realised how obvious a gap there was with the ol' 20-20 hindsight.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1455961
Posted Thursday, May 23, 2013 10:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:21 PM
Points: 33,202, Visits: 15,350
Jim P. (5/22/2013)

My question is still how to scale out SQL. It never seemed that MS designed the system for multiple access to a DB. So while you can scale up the web servers or number of clients, you are restricted by the controlling instance. I admit I've been out of touch with mainline general production support as I have been supporting my companies SW product which doesn't do well with advanced SQL options.


It has to do with architecture. SQL Server was never built to scale out, with a few exceptions. Distributed Partitioned Views can scale out, but not with redundancy. AlwaysOn is a start as well, though with a single write area.

Some of the Azure technologies are looking at scaling out, essentially by putting multiple databases to work for an application.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1456106
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse