We have a single database that drives a number of applications. Each application uses the same database and the same NHibernate Mappings.
I have recently implemented Nhibernate.Search in one of our applications. With a view to adding it to the others over time. If this happens I could potentially have a number of app servers updating one index. What is the best way of doing this? I know that Hibernate search can store its indexes in a database and I guess that would be the easiest route for me to take, but this doesn't look like it is available for the .Net variety yet.
What strategies can be used to get this to work?