I brought up single instance since you suggested using a SQL database most of which don't support a distributed deployment in the same way ElasticSearch does.

My point was merely that ElasticSearch scales from very small use cases to very large ones. You don't have to setup a cluster. And that using your SQL database isn't going to be significantly easier to manage.