MySQL to ElasticSearch One DB multiple tables

Elastic Stack Logstash
1

Hello,

I've just started using Elasticsearch. I have installed the JDBC Input Plugin to transfer data from our MySQL database to Elasticsearch. However, we have 200 tables in our database. We were wondering if there was a way to transfer all this to Elasticsearch. However we wanted it so that each table would have its own Index. So table 1 would have the index 'table1' and so on. I was wondering if this was possible instead of us doing it one by one.

Thank you!

2

Moved to Logstash, to which the question is more relevant.

3

You need a separate jdbc input for each table you want to read from, but you could of course generate those configurations.