full text with JSF and Mysql

Hi Folks,

I need to implement a full text search.

Searching for the GUJ right here, seen as alternatives: hibernate search, lucene, the actual mysql 5.6 (although still in testing, this version supports Norva on InnoDB fulltext)

But there is no conclusion reached. My reality is, JSP, MySQL, JSF

Do you have any suggestions for reading, or something similar article covering this my reality? so I can understand ..

Thankfully

Lucene is probably the most popular full-text indexing and search system in the Java universe. We use it on the JavaRanch.

Hibernate Search uses the Lucene engine. I've used it with the PostgreSQL database as part of a JPA-architecture webapp.

There's really nothing JSF-specific about any of these search components, though.

One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.

Brendan Healey wrote:One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.

So.

In fact, accepts full text mysql 5.6 innodb tables .. but is still in beta testing

Regards,
Juliano