This discussion is archived
9 Replies Latest reply: Jul 10, 2012 9:56 PM by hitgon RSS

Oracle Timesten Architecture Queries

hitgon Expert
Currently Being Moderated
Hi Gurus

We have six number of different physical locations and so want to deploy the telecom application on each locations which using the same data.

each Locations is connected with lease lines

We want to deploy the Oracle IMDB Solution
Oracle Timesten
Oracle Timesten Cache Connect
Oracle Database (Enterprise Edition)

We may have two RHEL server boxes on each sites

Constraint:
one location installation of Oracle Database (Enterprise Edition)

Please suggest the different possible architecture scenarios.

Regards
Hitgon
  • 1. Re: Oracle Timesten Architecture Queries
    hitgon Expert
    Currently Being Moderated
    We are waiting for response
    I hope that expert give us the suggestions

    Edited by: hitgon on Jun 30, 2012 6:12 PM
  • 2. Re: Oracle Timesten Architecture Queries
    ChrisJenkins Guru
    Currently Being Moderated
    Hi Hitgon,

    We really need to know a lot more about the use case in order to make useful suggestions as there are many permutations which may radically affect the solution. For example:

    Is data updated only in TimesTen (TimesTen masters the data) or only in Oracle (Oracle masters the data, TiemsTen data is query only)?

    Is the same data present at each location or is the data set at each location disjoint (nothing in common with other locations)?

    If data is updateable in TimesTen, do you need updates made at one location to be visible in other locations or just at location where they were made and Oracle?

    What kind of network connectivity (round trip latency, bandwidth, reliability) exists between the locations and the central Oracle DB? Between the different locations?

    Do you need any kind of HA? If so, what are the details?

    Etc. etc.

    It's really not possible to make any meaningful suggestion without this kind of detail.

    Regards,

    Chris
  • 3. Re: Oracle Timesten Architecture Queries
    hitgon Expert
    Currently Being Moderated
    Hi, ChrisJenkins      

    Thanks a lots for your valuable response


    Giving answers for following questions:
    Is data updated only in TimesTen (TimesTen masters the data) or only in Oracle (Oracle masters the data, TiemsTen data is query only)?
    Ans: Data will get updated in only oracle.


    Is the same data present at each location or is the data set at each location disjoint (nothing in common with other locations)?
    Ans: same data present at each location


    If data is updateable in TimesTen, do you need updates made at one location to be visible in other locations or just at location where they were made and Oracle?
    Ans: Data will not be updateable in TimesTen.  Data will get updated in only oracle.  All TimesTen instance should get synchronized automatically.

    What kind of network connectivity (round trip latency, bandwidth, reliability) exists between the locations and the central Oracle DB? Between the different locations?
    Ans:  There will be dedicated line for network connectivity(as per bandwidth requirement)

    Do you need any kind of HA? If so, what are the details?
    Ans: No.

    We are looking forward your further suggestions

    Regards
    Hitgon
  • 4. Re: Oracle Timesten Architecture Queries
    ChrisJenkins Guru
    Currently Being Moderated
    On the basis of what you have described it sounds like you will want READONLY cache groups in a TimesTen database deployed at each of the 6 sites. These cache groups will use the AUTOREFRESH feature to capture data changes made in the Oracle database and to synchronise them up to the TimesTen caches.

    Applications running at the 6 sites can connect to the TT caches to query cached data. To access/update Oracle data there are two options:

    1. The applications can perform this through the TimesTen connection using the PassThrough featire. This may be a good choice if the amount of direct application interaction with Oracle is low and not performance critical.

    2. The applications maintain a separate connection directly to Oracle and use this for all access to Oracle tables. This is the bets choice if there will be heavy interaction directly with Oracle and/or these interactions are performance critical.

    You will need to ensure that:

    1. The latency and bandwidth of the connections from the 6 sites to the Oracle DB are sufficient to cope with all traffic (direct application access to Oracle, autorefresh for cache groups data).

    2. You will need to consider the volume/rate of changes that are made to tables in oracle which are cached in TimesTen to ensure you are not exceedign the capabilities of the AUTOREFRESH mechanism.

    I suspect that you will need to do some kind of PoC to validate these various aspects.

    Chris
  • 5. Re: Oracle Timesten Architecture Queries
    hitgon Expert
    Currently Being Moderated
    Thanks again ChrisJenkins

    We should install the Oracle Timesten on 5 different sites locations and install the Oracle Database on primary site(one location)

    for Data Sync We should configure the Oracle Timesten Cache Connect with Oracle Database on primary site(one location)

    L1-Application<----Read Only-------TimesTen1 |
    L2-Application<----Read Only-------TimesTen2 |
    L3-Application<----Read Only-------TimesTen3 | <---------------Auto Refresh------Timesten Cache Connect --------------------------Oracle Database <====Data changes
    L4-Application<----Read Only-------TimesTen4 |
    L5-Application<----Read Only-------TimesTen5 |

    How to configure and install the Oracle Timesten Cache Connect with provide the above behaviors

    Above solution cover inside the Oracle documentation!!!
    We have metalink and oracle documentation access but It's pleasure to share the usefully links/documents for deploy the above solution

    Regards
    Hitgon
  • 6. Re: Oracle Timesten Architecture Queries
    ChrisJenkins Guru
    Currently Being Moderated
    The architecture you propose is a good one because:

    1. It has the TimesTen database/cache that is being refreshed from Oracle located at the same siet as Oracle (and hence on the same LAN, not over a WAN).

    2. Having just one autorefresh stream in Oracle maximises performance and minimises resource usage.

    For this architecture to work you need to make one change. The TimesTen deployment at the main Oracle DB site must be a replicated pair of TT caches (using TimesTen active/standby pair replication) not a single TT cache. The remote sites will then be 'subscribers' driven from the central A/S pair. You should consider using Oracle CLusterware to manage the central A/S pair as it will be much simpler than writing your own scripts etc.

    Chris
  • 7. Re: Oracle Timesten Architecture Queries
    hitgon Expert
    Currently Being Moderated
    Hi........

    We really apologize.

    We only want to deploy the Oracle Database on single primary site

    so may be it's over the WAN not over the LAN

    Remote Location1-Application<----Read Only-------TimesTen1 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|

    Remote Location2-Application<----Read Only-------TimesTen2 | <---------------Auto Refresh------Timesten Cache Connect --------------------------| (Remote Primary Site)

    Remote Location3-Application<----Read Only-------TimesTen3 | <---------------Auto Refresh------Timesten Cache Connect --------------------------| Oracle Database

    Remote Location4-Application<----Read Only-------TimesTen4 | <---------------Auto Refresh------Timesten Cache Connect --------------------------| (Data changes)

    Remote Location5-Application<----Read Only-------TimesTen5 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|


    Waiting for your suggestions

    Regards
    Hitgon
  • 8. Re: Oracle Timesten Architecture Queries
    ChrisJenkins Guru
    Currently Being Moderated
    My reply was only assuming Oracle at a single primary site. The architecture I was suggesting is:

    Remote Location1-Application<----Read Only-------TimesTen1 | <------TimesTen Replication--------|

    Remote Location2-Application<----Read Only-------TimesTen2 | <------TimesTen Replication--------|

    Remote Location3-Application<----Read Only-------TimesTen3 | <------TimesTen Replication--------| <-----TimesTen A/S Pair <--- Autorefresh <----- | Oracle Database
    (2 machines)
    Remote Location4-Application<----Read Only-------TimesTen4 | <------TimesTen Replication--------|

    Remote Location5-Application<----Read Only-------TimesTen5 | <------TimesTen Replication--------|

    This is by far the best architecture for performance, resilience etc.

    If the volume/rate of data changes that must be refreshed to the caches is very low then you could consider this architecture but it will impose significantly more load on the Oracle DB.

    Remote Location1-Application<----Read Only-------TimesTen1 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|

    Remote Location2-Application<----Read Only-------TimesTen2 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|

    Remote Location3-Application<----Read Only-------TimesTen3 | <---------------Auto Refresh------Timesten Cache Connect --------------------------| Oracle Database

    Remote Location4-Application<----Read Only-------TimesTen4 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|

    Remote Location5-Application<----Read Only-------TimesTen5 | <---------------Auto Refresh------Timesten Cache Connect --------------------------|

    Chris

    Edited by: ChrisJenkins on Jul 2, 2012 11:15 AM

    Edited by: ChrisJenkins on Jul 2, 2012 11:16 AM

    Edited by: ChrisJenkins on Jul 2, 2012 11:17 AM
  • 9. Re: Oracle Timesten Architecture Queries
    hitgon Expert
    Currently Being Moderated
    Hi ChrisJenkins      


    We have create the other thread for Oracle Timesten related queries to this thread

    Oracle Timesten Geo-redundent architecure deployment queries

    We are awesome waiting for your suggestions and advices.


    Regards
    Hitgon

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points