I have run in to the same problem I want to search multiple entities using the keyword like amazon and macy.com let you search the products database and different attributes like size, color etc are stored in different tables. I ran into a video on FTS in MYSql and it can accomplish what I want and integrates well with java as I'm using spring boot jpa for my implementation but I'm concerned about the performance. I want to follow up on the authors of this question and want to know is solr a better solution, if so can I keep my data in MYSQL database and somehow link it to solr and only use solr for search purposes.How do I do that as I don't fine much information on it on internet. Is solr better? is it easy to search solr using JPA or Java? and what about the author of this question what did you end up using and how is it working for you?