Choosing the "right" datastore?

Installation/Setup
1

I need recommendation on the datastore to use with Kong, I actually tested postgres and cassandra, but for HA production environment what would you recommend?

2

We typically see Cassandra used for such requirements, but you can also look into Amazon Aurora’s PostgreSQL.

3

I would probably decide like this:

Distributed multi-DC: Cassandra
Single DC: PosgreSQL (https://www.postgresql.org/docs/current/static/different-replication-solutions.html)

4

I have looked at it’s “extremely” expensive comparing we can run Kong on EC2 for US$36 a month with an amazing rate (t2.medium)…

problem with Aurora PostgreSQL is that the server starts at r4.large and there is nothing “smaller”

screenshot_663.png814×621 42.5 KB

That alone without counting with backups, it’s US$150+ monthly …