Hi, Please consider Elasticsearch

"It provides scalable search, has near real-time search, and supports multitenancy"

Joomlageek have already created a very mature integration.
https://www.joomlageek.com/product/component-geek-elasticsearch

All that is required is a tiny interface plugin.

https://en.wikipedia.org/wiki/elasticsearch