You can use a distributed database like yugabytedb or crdb. They are horizontally scalable, support postgres (yugabytedb has much better postgres compatibility). Yugabytedb also supports the Cassandra API.