We are a database look up company. Meaning we A LOT of databases. However, when we first started we thought doing a query to MySQL would be enough. That wasn't the case so we have moved to Elasticsearch. In MySQL, we put all the databases into one database and separated them into tables. So database1 would have its own table and so on. We have imported around 3 tables at this time for testing. When searching all the indexes the speed is impressive but not enough. However, we have the option on our search engine to search for a "username", "email", and "ip". All of the tables has simliar columns. So if database1 has a username column is has "Username" and so on. The spelling is all the same due to this. However some indexes do not have the "Username" function. We were wondering when we send a search request to the API, if we could search all indexes in the "Username" column for a string. So if a user searches "Admin" it would search all indexes that has the column "Username", however we would like to do this by using "localhost:9300/_all/" instead of specifiying which indexes because we would have over 500.
Thank you! Any suggestions are welcome.