After switching "cache-mode" to "cluster" (JDBCStore with MySqlRDBMSAdapter) my application experienced a 10-fold performance degration. Now I'm considering alternative clustering options :-) like having the primary server's "cache-mode" set to "full" and (at least) one secondary server's "cache-mode" set to "cluster". All modifications go through the primary and the secondary picks up all changes so that both servers always deliver uptodate query results. Does that work at all?

Now the secondary server should take the DASL load. It must cover queries on properties and full text queries as well.

I think there are 2 possible solutions:

*leveraging the database's (like MySQL's for instance) full text indexing capabilities. For this a special version of MySqlRDBMSAdapter would have to be written, overwriting storeRevisionContent etc. to put certain resourcetypes (text/*) into LONGTEXT columns instead of LONGBLOB. And create a corresponding RDBMSTextContainsExpression.

*sharing a Lucene index between instances of Slide

I'm asking for opinions if and how doable either of these is and if I'm overlooking something for the first option.

Thanks
Guido

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to