What are fast databases?

Question

PHP

I want it to be fast.
Here I found one MemSQL (it has a high speed due to the fact that it stores everything in RAM).
Is there something faster? For the sake of this, I’ll even buy SDD (although against sas, sdd is not faster), the server is not weak, it will pull everything) resources are also not limited.
There is also one but .. it should not interfere with the work of Sphinx.
Also used by HHVM.
And in mysqli there are such tables that are stored in RAM.. Isn't that the same as MemSQL?

Answer 1

You just need to set up MySQL.
Even without a cache, it works not bad.

Answer 2

1. SSD is faster than SAS if you put a couple in RAID.
2. mysql on hdd and ssd shows about the same performance.
3. in mysql it is possible to store in-memory tables
4. You need not so much a fast base as you need to correctly configure the base. The same MySQL can be given enough memory for the cache, it stores indexes in memory + reliability that neither Redis nor MemSQL can give.
5. Use Redis/Memcached to store sessions (they also provide their own footprint)
6. As an alternative to MySQL - use Postgress, it's still a little faster and gives more options for building indexes. As far as I remember, in the 3rd version of HHVM, the driver for it was finished.

Answer 3

Perhaps MongoDB is also worth mentioning. It also works with the RAM, so it should be quite good in speed. And unlike the same Redis, it looks like a database. Still, I can’t call a radish a database
) I have never seen MySQL tables of the Memory type (which are stored in memory) in practice. Those. if you need a table for quick access, then use Memkesh, Radish, etc. Postgress is probably almost unanimously recognized by everyone as better than MySQL, but I have not worked with it, so I won’t say much. The only thing is that you need to be able to set it up.

Answer 4

Redis

Answer 5

CouchDB seems to me to be faster