is there a way other than using logstash to convert mysql to Elasticsearch. I just got a new task, to create a generic processor to convert mysql to Elasticsearch
You may find this blog helpful if you are using Logstash: How to keep Elasticsearch synced with a RDBMS using Logstash and JDBC | Elastic Blog
Alternatively, you could write custom code to read from the database and write into Elasticsearch.