| Author |
Message
|
| paustin_ours |
 Posted: Mon May 29, 2017 5:48 pm Post subject: global cache complete vs sparse |
 |
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Mon May 29, 2017 10:48 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
I'd look at memory resident DB's as an alternative.
It can take some time to load all that data into the cache after startup. That can cause processing delays.
How are you handling updates to the DB and the replication of the changes to the cache data back into the DB itself?
Using a DB have has the ability to work in memory will save you all this "re-inventing of the wheel"
anyway, a decent POC would prove the usefulness (or not) of doing what you want to do.
I did one with IIB8 (or was it IIB9???) and found that it didn't give us much of an improvement if anything. IT also took us longer to fail over our HA environment because of the cache loading times. And we restricted using the cache to read only data so we didn't have any real time DB sync issues.
YMMV and probably will.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| paustin_ours |
| Posted: Tue May 30, 2017 7:39 am Post subject: |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
any suggestions on In memory databases that i can look at? There are a whole lot. Essentially i would like it to front our Oracle database and receive updates when there are db events on Oracle and update the in memory cache accordinly.
I see H2, ehcache and a lot others. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue May 30, 2017 7:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
websphere app server has an edition that comes with the previously separate eXtreme Scale, that is more or less the same as the broker global cache. This would allow you to have a separate thing that didn't need to restart when the broker did. But I forget if you can still create a configurable service for that.
In general, you may have difficulty mapping a relational database to something that's a document oriented/noSQL database... And as my esteemed colleague says, you have to think about how to do updates/etc.
It may be worth the time to discuss memory caching with your dbas, to see if they can do improvements on your lookup times...
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue May 30, 2017 11:05 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
There is a whole raft of information on the ORacle site about this sort of stuff.
Here's one to be going on with
https://docs.oracle.com/cd/E13085_01/timesten.1121/e14261/arch.htm
you really need to sit down with your Oracle team and work together on this. Otherwise just see my sig below for what will happen
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
