Something unique to Cloudways is their free Elasticsearch. You just have to turn on the service, and it is available on locahost:9200, ready to use with your favorite Search plugin.
I helped https://www.cartochrome.com/ to solve their dead pages responses. After analysis, it appeared that their WordPress theme was not able to manage SQL queries with over 30M custom fields.
Elasticsearch nicely took care of the search, with the help of my plugin WPSOLR, and of the filters too. Plus, cherry on the cake, no server upgrade was required. Considering the free Elasticsearch hosting and the not-upgraded VPS plan, it was probably over a 100€/month less on their budget.