I would use this to replace MySQL or PostgreSQL and I would use it over MongoDB or Cassandra because it is high-quality software, built on top of Erlang (highly concurrent and fault tolerant language, great foundation to start with), and implements really great features.