Which database to choose for indexing/caching data?

Question

Yii

A large number of data are stored in a cassander cluster. I am looking for a persistent database into which it would be possible to pull a part of the data (by key) and provide it to the client, where he could search by any attributes (the simplest, such as name=Vasya&age=18 etc) and sort (also by any set of attributes ). With the ability to store in a pre-sorted form according to a specific set of attributes (each set may have its own).

Answer 1

Create a scripts folder, create a file there:

#!/bin/bash

/ПУТЬ ДО ПРОЕКТА/yii test/index

Then in the cron:

* * * * * /bin/bash /ПУТЬ ДО ПРОЕКТА/scripts/НАЗВАНИЕ ФАЙЛА

Answer 2

In the crone, do this:
cd / let / yii; /usr/bin/php -q /let/yii test/index

Answer 3

For caching?
Tarantool

Answer 4

elasticsearch!

Answer 5

Aerospike