MySQL into Elasticsearch via Logstash

bin/logstash-plugin install logstash-input-jdbc

That’s the command you’re probably looking for.

Then there’s the example and details at:
https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html

The install for Elasticsearch, Logstash, and Kibana in the 5.x release is wonderful. Getting Nginx working is normal, the /kibana/ attempt failed, might have another try at it later.

Further, to search, or use the Query DSL to search for text in a field, do this:

{
  "query": {
    "match_phrase": {
      "fieldname": "searchstring*"
    }
  }
}