We need 11 tables to join together to generate the search result in MySQL database.
We use Elasticsearch as our full-text search engine. There is no join operation in ES.
- write join query in logstash to create the super table index.
- create individual index for each table then do the join at application side.(i do not want this way)
- to use other software?
when i try to use solution 1, the issues are 1) what should be the tracking-column, what should be the where cause in the query so that the index can be incrementally increased.
Is there any good suggestion?