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?
We typically see Cassandra used for such requirements, but you can also look into Amazon Aurora’s PostgreSQL.
I would probably decide like this:
Distributed multi-DC: Cassandra
Single DC: PosgreSQL (https://www.postgresql.org/docs/current/static/different-replication-solutions.html)