While everything is fast moving and customer demand is so high touching to sky now a days everyone wants to run business 24×7 without any down time. Yes that?s true, and for this there are service uptime is required, for the human resources companies has taken a step and started 24×7 operation. Similarly they need this for the machines as well. So let?s discuss few questions here about the high availability:

  • What are different 9?s
  • Why to chase them
  • What is appropriate and for whom
  • Is this actually achievable or it is only dream
  • What is business reason
  • What is payback
  • It is requirement or goal for which we strive with or reach to 6 nines.

What are Different Nines Here is table, which tells us about different nines

Uptime Uptime Down time (max)
One nine 90.00 36 days 12 hours
Two nines 99.00 87 hours 36 minutes
Three nines 99.90 8 hours 46 minutes
Four nines 99.99 52 minutes 33 seconds
Five nines 99.999 5 minutes 35 seconds
Six nines 99.9999 31.5 seconds

When it comes to few days of unplanned service down time in a year, then none of industry or business survives for longer duration, so point of one nine and two nine is really does not hold true in the era of advance technology. Home based industry can service for one nine or two nine downtime and at the same time good computer/services can solve the problem and reduce the unplanned downtime. Now a days good configuration laptop can also work well. In late 90?s when getting spares were problem and transportation were issue, in that case one can understand one nine and two nines but in modern era when everything is within reach in such situation one nine and two nines are almost eliminating from the IT industry. In cyber world most of the industries are working on three nines and four nines concepts where maximum of 9(-) hours of downtime does not impact them, let?s take some of the industries where it works like, garment industry, fashion, small scale industries but that to only IT infrastructure. At the same time some of the industries are heavily dependent on IT infrastructure like media, banking, telecommunication, e-commerce, aviation, etc. In these industries high availability is very important and everyone is striving to have maximum availability. Question comes why, answer depends on how critical and valuable resource is at stake. For example Aviation, one can not say any nine it has to be 100% cause human life is at stake. Now let?s lower it down to banking and telecommunication there 4,5,6 nines are requires 3 nines may work. Size of business and high value is directly proportional to availability. Higher the business value need more availability let?s talk the any business for year 2013-14 it is approx 1 billion USD and for one hour down time approx. 120K USD is loss along with the band value. Now industry has to decide that how much they can invest to go for 5 nines. If cost of five nines is very high let?s assume 2-3 million then decision can go for four nines. Also it can be thought that how one can distribute the processing to reduce the complete system downtime. ha-cost-vs-nines Yes alternate method is very important. Everyone is talking cloud, high availability but can we distribute the computing and processing to minimize the loss during the failure cases. We need to work on this direction and see what can we do in this direction. In the next blog I will discuss more on distributed processing ? share your thoughts as well?


What is best way of processing the large volume of data in OLTP application? Weather it should be”Near Data Processing” or “Far data Processing”? Process Near the data (database procedures, PLSQL, ETL, ELT, OOD etc) – Process away from the data ( Java coding, C++ coding, etc.) Both the systems has some pros and cons:

Processing Near Data

Generally two type of processing occur one is batch processing and other is real time processing. Batch processing where a group of data is being processed and entire processing is very similar, like salary calculation and disbursement, loyalty calculation, interest calculation and posting trading day end processing, settlement of bills, bill generation etc. Real time processing are those processing which occurs realtime like online fund transfer, money withdrawal, purchase of any item and it’s payment. Batch processing should be carried out near the data and real time should be carried out near the objects. While certain systems perform batch processing far from the data(like social networking sites) but those systems have some valid reasons of distributed processing and time does not matter to those systems like but there we time is crucial factor and window is very small it is preferred to move the processing near the data. Overhead of network, chances of data loss, disconnection of process, and availability of systems are main reasons to move the processing near data.

Processing Far Data

Far Large Volume of data processing is not very encouraging in the data analytical world. There are some cases where far data processing is beneficial like form processing, bulk entry(offline) processing, social networking sites data analysis for the presentation to users. It is also essential when system is processing individual transaction based out of bulk transaction processing far data processing is really good to have.