Hi
I need some hints about implementing a cluster cache, to be more precise, simply duplicate ny app server and be able to use some 2nd level cache. Below is my configuration, i'd like to find the easiest working solution (cause i'm newbie), so any suggestion would be great for me!
My app : Hibernate3 through connection Pool in ApacheCocoon, in tomcat5, MySQL database. No other application is accessing the database, no Jboss. So it is a non-managed environment. Session-per-request-with-detached-objects pattern + i always explicitly use transactions. Read/Write ratio would be let say 70% read. I use several HQL queries.
The possibilities are :
- OSCache : (invalidation) In some old posts i red this is not intended for a cluster cache, it is still related like this in the docs, but some did and reported on it right?
- Jboss Tree Cache : Full replication, Seems to be the one suggested by Hibernate team. It looks more complicated as it is some full replication, and seem to imply some changes to my actual configuration right? Maybe mean i should use JTA?
- I let apart SwarmCache &Tangosol Coherence at the moment..
- Not use 2nd level cache may be an option!!
Regards,
Phil