Would you recommend Solr or Elasticsearch for WPSOLR ? We are currently using Relevanssi and we’ve run into a bottleneck where the MYSQL is bloating with terms.
Personally, I’m more in Solr. Its visual admin dashboard is easier to understand (Elasticsearch’s admin Kibana is all about JSON commands).
But if you want WPSOLR to fully automate the Solr index creation, you will need to start Solr in cloud mode. Solr cloud provides all the apis to create and setup an index.