This content has been marked as final. Show 7 replies
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.
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:
http://www.oracle.com/technetwork/products/timesten/overview/timesten-tutorials-demos-1443972.html#demos - a lot of demos
My notes (but Russian only, sorry)
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.
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
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.
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.