Recently I was visiting a customer in Korea and there was
this interesting topic on when to use Multidatasources
in WebLogic and why not use a single Datasource
with SCAN IP for the Oracle RAC Cluster behind.
Well there are 2 ways to look at it.
Do you need GRID capabilities of horizontal scaling up and
down??? You better go for a single
Datasource with SCANIP instead of
VIPs
Is your environment sized and future proof in terms of volume(well
almost…) and you don’t have more to spend on Databases??? You have the Multidatasource
Off course you need to also see the best practices on the
application you are running on WebLogic if they are COTS.
Still there are some advantages:
Weblogic
drivers for RAC enabled XA connectivity to Oracle DB is superb and by far the
best driver to use.
Weblogic
takes care of connection handling and liaising with multiple pools of
connections and it is a MAA architecture model
It
can do Load Balancing for you!!!
Comments,
if you have any…
