Doddy Christiana Saputra

Hi Folks,

Nice to see you again, in this session i would like to share something nice about practically of high availibility strategies based on my experiences. As we known that all of a IT elements, i mean as a Software architect in application or in Database application had agree about one principle about how to get the goal of application process, especially in data transaction process. The rule is ACID test (Atomicity,Consistency,Isolation and Durability), i wouldn’t talked too much about the detail of these rules due to you can grab the knowledge from many theoritical database book in any where but the things that we should understand is ,between application domain and database should have mutual cooperation to gain this goal in practically, you might take care this rule in transaction process in application by using smart transaction method using ADO.NET or handling smart transaction by using stored procedure in the database. But in in these session, i wouldn’t discuss with you about those things probabaly next session pale , i would like to emphasize the discussion to maintain high availibility in database infrastructure in YUKON or as we known is SQL Server 2005.

Let say i have a scenario mirroring design like this following picture :

(more…)