Re: steps to follow to develop applications with target db on RAC
Date: Mon, 07 Jan 2008 21:25:02 +0100
Message-ID: <4d25o35ra9r2repqktebklpgi106btar76@4ax.com>
On Mon, 7 Jan 2008 20:31:17 +0100, "KCS" <KCS_at_hotmail.it> wrote:
>Developers asked us a simple checklist to follow to build good applications
>where the target database is a 10g RAC (2 or 3 nodes).
>I remember a pair of links on this forum about this argument, but we do not
>succeed in finding them.
>
>Would it be possible for you to give us some information, about developing
>application for ?
>
>Thanx
>
>Mastino (KCS Srl)
>
RAC is ill-suited for non-OLTP applications (according to the 10g RAC
course).
RAC is also very sensitive to unscalable applications. If the
application is unscalable in a single instance situation, results in a
RAC configuration will be even worse. (Again according to the
aforementioned course).
The best you can do is build a scalable app for a single instance.
The one thing you might take into account, is splitting up your application in several services (modules). You can decide to run a service on 1 node or multiple nodes, have it fail-over, or have it crash etc.
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Jan 07 2008 - 14:25:02 CST