Hi! I'm a newbie at Hibernate and have a question about the architecture of my app.

I have a backend (BE) where all new entries are made through Hibernate to mySql.

I want to present the data at multiple frontends (FE) using Lucene for searches and Hibernate with their own mysql installation.

My problem is how I'm going to keep all parts of FE up to date. The ideal solution would be if Hibernate could, through TreeCache, update Hibernate and mySql at FE and through an event make it possible for
me to update lucene. Is this possible?

I have a backup plan where I replicate mySql and only use treecache to update the hibernate cache, I then check for modifications in mySql on time interval to update lucene. This should work but I would prefer
the ideal solution.

Another issue is how to handle initialstate in mysql when setting upp a new FE, any thoughts on how to handle this with Hibernate?

Hibernate version: 3.0.3

Name and version of the database you are using: MySQL Server 4.1

Thx in advance!