"MySQL + Redis"
I think this would be 10x more expensive to set up, manage, maintain and use than something like Riak.
I think this would be 10x more expensive to set up, manage, maintain and use than something like Riak.
But then again, I could be super mistaken. I'm interested in seeing another side of it.
I am sure that for certain use cases, there are more tailored solutions, but "SQL + keystore" seems like a fairly universal, affordable and versatile stack.
Ignoring the difference for a minute. If you can fit data in Redis, chances are that they can fit in riak and a RDBMS is not needed at all.
Why Riak only then?
It is one of the very few databases that can be clustered. It is sharded, multi-master, highly available, to talk in buzzwords. It is very reliable and very robust, you can add/remove nodes as you wish, replication is highly configurable, etc...
Postgre/Mysql/MariaDB + Redis have no HA. They are both the disaster in disaster recovery.
Riak looks like it would be overpowered by my needs - but then again, I learn something new every day.