# Choosing the "right" datastore?

**URL:** <https://discuss.konghq.com/t/choosing-the-right-datastore/680>\
**Category:** Questions\
**Created:** [March 13, 2018, 1:46pm UTC](https://discuss.konghq.com/t/choosing-the-right-datastore/680 "2018-03-13T13:46:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ma.hizaoui](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@ma.hizaoui](https://discuss.konghq.com/u/ma.hizaoui)\
**Post date:** [March 13, 2018, 1:46pm UTC](https://discuss.konghq.com/t/choosing-the-right-datastore/680/1 "2018-03-13T13:46:26Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Aaron\_Miller](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/aaron_miller/32/35_2.png) [@Aaron\_Miller](https://discuss.konghq.com/u/Aaron_Miller)\
**Post date:** [March 18, 2018, 9:56pm UTC](https://discuss.konghq.com/t/choosing-the-right-datastore/680/2 "2018-03-18T21:56:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bungle](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/bungle/32/13_2.png) [@bungle](https://discuss.konghq.com/u/bungle)\
**Post date:** [March 19, 2018, 11:57pm UTC](https://discuss.konghq.com/t/choosing-the-right-datastore/680/3 "2018-03-19T23:57:27Z")

</div>

I would probably decide like this:

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

---

<div class="post-metadata">

**Author:** ![balexandre](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/balexandre/32/234_2.png) [@balexandre](https://discuss.konghq.com/u/balexandre)\
**Post date:** [March 20, 2018, 12:55am UTC](https://discuss.konghq.com/t/choosing-the-right-datastore/680/4 "2018-03-20T00:55:44Z")

</div>

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”

 ![](https://yyz2.discourse-cdn.com/flex036/uploads/konghq/original/1X/7549b1242428681d9ee1ff819585ac139b484616.png)

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