Feb 22 2009

HA Is It High Availability or High Anxiety?

Posted by Mike Brunt at 10:30 AM ColdFusion | JRun-J2EE

It interests me that I still encounter business critical web sites with no or only partial redundancy. I was thinking about these issues at the same time as recalling a very amusing film produced by Mel Brooks; High Anxiety; I thoroughly recommend it particularly if you ever liked Alfred Hitchcock, you will note many spoofs on his work in High Anxiety. So what does High Anxiety have to do with web site redundancy? HA!, High availability.

In my experience, over the years, I often encounter web sites with two or more web-CF servers but only one database server, this is not HA nor does it even approach HA. In fact it would be better if things were the opposite, in my opinion. In other words that there were two or more databases and one web-CF server. The main reason I say this is that provisioning a replacement web-CF box, should that single box fail, will be significantly faster than provisioning a replacement database. If you are in the position of having only one database server then I feel you should have very High Anxiety until you have a second database in place, Even if you have active-passive as the format and the license costs can be mitigated. For instance, Microsoft allows a single SQL Server license to be used on two servers providing that only one of those two servers is serving production at any given time, which is exactly what active-passive is. So why is it significantly more difficult to provision a replacement database server; here are some reasons.

  • Software Installation/Set Up: Installing SQL Server (for instance) correctly, takes significantly longer than installing ColdFusion (every minute matters when you are down with no service).
  • Restoring/Backups: Sadly most back-up regimes I have seen, where no DBA is present or has been present, are inadequate. Configuring database back-up and restore correctly, is a significant task; significantly more difficult than what is required for an adequate regime for web-CF servers. One more point on restores, I strongly recommend they be tested at the very least, monthly so that we are sure it will work if needed. When we back-up a database it is not just the data we need to pay attention to but also the database objects; stored procedures-views etc. Transaction logs are also a key item in backup/restore, they will get back the most recent changes since the last full-incremental back up. With web-CF servers we are typically interested only in what is on the file system along with settings in the web server and ColdFusion server all of which are fairly easy to backup and restore.

For the cost of a few hours expert DBA review relating to the state of your HA infrastructure (and I do mean High Availability here) you could easily save thousands of dollars in lost business or goodwill should your database fail and cost many hours or worse days of downtime.  It is money well spent, believe me.  

This article was written with the assistance of Clement Huge, whom I have worked with many times and who is truly an entrepreneurial and very talented DBA.

Comments

O?uz Demirkap?

O?uz Demirkap? wrote on 02/22/09 12:03 PM

I do not know why but I have never trusted any MS clustering or any other software based clusters.

Having a realtime replacement box sounds enough for me when I consider that we had not any single issue on DB server for last 3 years.

May be old habits.
Mike Brunt

Mike Brunt wrote on 02/22/09 12:50 PM

@Oguz, nothing beats long-term experience in what has actually happened. Your point about software level clustering has merits with one thought point. If the route taken is hardware clustering then there need to be two devices or you have a single point of failure again. With peer-to-peer software clustering there is no real single point of failure at the server level.
isabel marant sneakers

isabel marant sneakers wrote on 10/21/13 8:08 AM

visited this valuable weblog previously still right after shopping by way of lots of the post I just well known it is interested in you and me. http://www.isabelmarantbekett.com
Andrei

Andrei wrote on 06/22/15 9:16 AM

for me is high anxiety because is so frustrating when it doesn't work.. <a href="http://onecall.ro">Andrei</a>;
Connor

Connor wrote on 06/24/15 4:50 AM

I believe Ha stands for high availability, not high anxiety. I am the kind of man that sees the glass half full so in this case i chose to see only the advantages, not the disadvantages because they are insignificant to me.
Jacke Martine

Jacke Martine wrote on 04/05/16 12:39 AM

According to my thought Mike Brunt! This article has given me superlative knowledge what each time desire to get. Because of your content could enhance my skill level. I wish in the future will not do any mistake if keep in touch with this platform. http://www.mindaqua.com/online-marketing/search-engine-optimization
Steven N Lockey

Steven N Lockey wrote on 06/09/16 7:10 AM

Howdy, it was a truly wonderful experience to have dropped by at your website. I hope you don't mind if I praise you on the high quality of your work and to send you bon chance with it as you advance from now on. It was nice to surf your website and I will surely be dropping by again soon to see how you're faring. Thanks a lot and I shall see you back here very soon - Steven N Lockey
Blanca Costa

Blanca Costa wrote on 08/03/16 9:42 AM

Hi, with the weather being dreadful this morning so I opted to stay home and browse the web instead, it turned out to be the most nice experience for me as I checked out your website. I hope you don't mind if I compliment you for the quality of the work and to send you all the best with it as you advance in the future. It was a hoot to surf your site and I will without a doubt be calling back again soon to find exactly how you're doing. All the best and I shall definitely see you here soon - Blanca Costa
replique montre

replique montre wrote on 10/27/16 11:18 PM

HA Is It High Availability or High Anxiety?