Sorry if this question is in the wrong forum. In my web application I have a page which shows categories and sub-categories. These categories are stored on the database and rarely change, so it makes sense to cache them instead of hitting the database every time they need to be displayed in a web page.
If I cache the categories, and there is a change to the categories (via an admin), then the cache needs to be updated.
I don't understand if I am caching the resultset how this cache could be updated in general, and more importantly, in a cluster.
Could someone shed some light? I read about tomcat clustering and some caching tools, but I can't see the high level design. Would each web server have a cache? How would they syncronize? Do I have to write this cache and syncronization using some servlet listenener?