7 Replies Latest reply: Jul 11, 2012 6:31 AM by Gennady Sigalaev RSS

    Oracle Timesten Geo-redundent architecure deployment queries

    hitgon
      Hi,

      We have 6 sites and each site connect with lease line.

      There are 5 different physical Remote Site we want to deployed the active/standby timesten database on 5 sites
      We want to create the READ ONLY LOCAL CACHE GROUP for each 5 Sites which is auto refresh from single central database site(2-Node RAC)
      Data Modification always happen on Central Site.

      Oracle timesten active/standby is in local LAN on each site but each site is connect through WAN to the Central Local site where the Oracle RAC Database resides
      and configure the Cache Connect with each site for Auto refresh the Read Only Local Cache Group on each site.


      ARCHITECTURE OVERVIEW

      Remote Site Location-1 ==>(Read Only Local cache Group )Oracle TT A/S<<====== Auto Refresh <---------||
      ||
      Remote Site Location-2 ==>(Read Only Local cache Group )Oracle TT A/S<<====== Auto Refresh <---------|| (CENTRAL LOCATION SITE)
      ||
      Remote Site Location-3 ==>(Read Only Local cache Group )Oracle TT A/S<<====== Auto Refresh <---------|| (2-Node RAC Database)
      ||
      Remote Site Location-4 ==>(Read Only Local cache Group )Oracle TT A/S<<====== Auto Refresh <---------||
      ||
      Remote Site Location-5 ==>(Read Only Local cache Group )Oracle TT A/S<<====== Auto Refresh <---------||

      We have go through below Oracle Technical Paper.
      http://www.oracle.com/technetwork/database/performance/wp-imdb-cache-130299.pdf
      please check the Figure 7==>Incremental Autorefresh of Read-Only Local Cache Groups

      Please suggest your advice and suggestion for above architecture deployment

      Regards
      Hitgon

      Edited by: hitgon on Jul 10, 2012 6:44 PM

      Edited by: hitgon on Jul 10, 2012 6:46 PM
        • 1. Re: Oracle Timesten Geo-redundent architecure deployment queries
          hitgon
          Hi,

          We want to configure the read only local cache group between grid member nodes which is located on 5 different locations on WAN where the timesten A/S is deployed on local LAN Site and also want to configure the IMDB Cache Connect with RAC Database which is located on central site.

          We want to know that above configuration is physible?????.

          Please provide any documents or link for configure the above setup.

          We are waiting for suggestions and comments from Oracle Timesten Experts.

          Regards
          Hitgon
          • 2. Re: Oracle Timesten Geo-redundent architecure deployment queries
            Gennady Sigalaev
            Hi hitgon,

            I think your configuration could be realised.

            1. Install TimesTen on all 5 nodes.
            2. setting up the Cache connect feature on all nodes
            3. Create grid on any node and attach 4 nodes to the created grid
            4. create local cache groups (on each node)
            5. loading data
            6. setting up the A/S per each node

            I've done the similar configuration without 6 item (http://ggsig.blogspot.co.uk/2011/04/in-memory-database-cache-grid.html).

            By the way, there are a lot of information about creation an A/S replication:

            Official
            http://www.oracle.com/technetwork/products/timesten/overview/index.html
            http://www.oracle.com/technetwork/products/timesten/overview/timesten-tutorials-demos-1443972.html#demos - a lot of demos

            My notes (but Russian only, sorry)
            http://ggsig.blogspot.co.uk/2011/04/tech-in-memory-database-cache-11g.html
            http://ggsig.blogspot.co.uk/2011/04/in-memory-database-cache-grid.html

            Regards,
            Gennady
            • 3. Re: Oracle Timesten Geo-redundent architecure deployment queries
              Chrisjenkins-Oracle
              Can you please clarify something. You used the term 'grid membr' in your description but at the moment cache grid only supports global AWT cache groups not readonly cache groups. From the rest of your description you do not need cache grid here but just regular IMDB Cache. Apart from this anomaly this architecture looks fine to me.

              Chris
              • 4. Re: Oracle Timesten Geo-redundent architecure deployment queries
                Gennady Sigalaev
                I had the same question. Read only cache groups are always local, so I'd decided not to ask :)

                regards,
                Gennady
                • 5. Re: Oracle Timesten Geo-redundent architecure deployment queries
                  hitgon
                  Hi,

                  Many Many Thanks to ChrisJenkins and Gennady Sigalaev

                  What should be take care or remember points that have to be follow while deployed the same on below things.

                  Operating System-64bit RHEL
                  Oracle Timesten A/S on same LAN(NIC) on each sites
                  Each sites is connected through lease line on WAN with the Central Site
                  NTP (time synchronization between all sites)
                  Oracle Timesten A/S Configuration notes/docs/links
                  Oracle Timesten Cache Connect with Oracle RAC Database notes/docs/links

                  We are awesome to follow your advice and suggestions

                  Please provide any oracle docs or links or your suggestion based on your own experience

                  Regards
                  Hitgon
                  • 6. Re: Oracle Timesten Geo-redundent architecure deployment queries
                    Chrisjenkins-Oracle
                    There is a great deal of stuff you need to understand and bear in mind when implementing any complex system and this is n oexception. You should start by studying the TimesTen documentation. In particular you should familiarise yourself with the informaiton in the Cache User's Guide and the replication Guide. These contain lots of very important information regarding the setup/deployment and operation of A/S pairs and cache groups, configuring cache connect for RAC etc. You should also read through the troubleshooting guide to familiarise yourself with what things to look at if things do not seem to work as expected.

                    If you are not already very familiar with TimesTen I would also strongly recommed that you take the time to read the rest of the documentation. TimesTen is not Oracle Db and while it is very compatible with Oracle in many areas there are also a lot of significant differences which you need to take into account when developing applications, managing the system etc. if you are able to take an OU training course on Timesten then I would recommend that but if not then reading the documentation is a good second best.

                    We do not 'recommend' operating systems specifically but 64-bit Linux is certainly a good choice. You might like to consider Oracle Enterprise Linux instead of Redhat; it has some advantages.

                    Within each site both nodes in the TimesTen active/standby pair should be on the same LAN. I would recommend GigaBit ethernet as a minimum.

                    While it is possible to write your own scripts to handle deployment, monitoring, failover and recovery of A/S pairs it is much, much easier (and much more robust) if you deploy Oracle Clusterware at each site to provide fully automated management of the A/S pairs. That is our very strong recommendation and is also best practice.

                    From a TimesTen perspective, system clock synchronisation is only needed within each site (i.e. the system clocks on both nodes in an A?S pair need to be closely aligned). However, it may be desirable to have all the nodes in all the sites have their clocks aligned for other reasons.

                    You need to ensure that the bandwidth and latency of the WAN connections is adequate for the amount of refresh traffic that you will have. There is no easy way to estimate/calculate this; you will need to determine this empirically.

                    Those are probably the most important things. As you progress then you can of course ask questions in this forum and use Oracle Support.

                    Chris
                    • 7. Re: Oracle Timesten Geo-redundent architecure deployment queries
                      Gennady Sigalaev
                      We do not 'recommend' operating systems specifically but 64-bit Linux is certainly a good choice. You might like to consider Oracle Enterprise Linux instead of Redhat; it has some advantages.
                      Latest OEL - Oracle Linux 6.x is a free (you pay for support only if you need it of course) binary clone or RHEL 6.x., so advantages are obvious :) You can download it from http://edelivery.oracle.com/linux.
                      Additionally, there is no problem with support for ALL your configuration (OS+TimesTen and etc.) because all software from one vendor.

                      regards,
                      Gennady