I used Elasticsearch. But I didn't use it as a primary datastore, more just a mirror of the MySQL data. It comes out of the box with a way to find "More Like T

I used Elasticsearch. But I didn't use it as a primary datastore, more just a mirror of the MySQL data. It comes out of the box with a way to find "More Like This" https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-mlt-query.html https://www.elastic.co/guide/en/elasticsearch/reference/curr... For trending topics I believe I used something related to this: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-significantterms-aggregation.html https://www.elastic.co/guide/en/elasticsearch/reference/curr... An interesting article on using ES: https://auth0.engineering/from-slow-queries-to-over-the-top-performance-how-elasticsearch-helped-us-scale-4fe72ffcb823 https://auth0.engineering/from-slow-queries-to-over-the-top-...