Have anyone tried sharded PostgreSQL on TierHive?

pmasta

It offers great value and the fact that you can choose the exact cpu and ram you get per server is incredibly valuable for different types of loads. But not sure about stability. Have anyone tried running a real sharded postgresql server either in one geographic location with read replicas or globally (horizontally)?

dbadude

Databases are the most critical part of your infra. Never run this on a 14 cent vm. There are some free postgress providers. Like neon, they know how to run this stable.

skorous

I can't be the only one whose inner voice read that as, "sharted PostgreSQL" and giggled.

pmasta

@dbadude said:
Databases are the most critical part of your infra. Never run this on a 14 cent vm. There are some free postgress providers. Like neon, they know how to run this stable.

I was thinking more of something like this, 2 GB RAM + 1.75 vCPU to psql, multiplied by 3 per region, 3 regions (eu, us, asia) for high availability. The status page is promising. But I'm just not quite sure.

This setup would cost roughly ~$30 per month. If you were to use planetscale or something like that, this setup can easily cost $200+ with less than 1vCPU per psql node.

ehab

@pmasta what is your load?

dbadude

@pmasta said:

@dbadude said:
Databases are the most critical part of your infra. Never run this on a 14 cent vm. There are some free postgress providers. Like neon, they know how to run this stable.

I was thinking more of something like this, 2 GB RAM + 1.75 vCPU to psql, multiplied by 3 per region, 3 regions (eu, us, asia) for high availability. The status page is promising. But I'm just not quite sure.

This setup would cost roughly ~$30 per month. If you were to use planetscale or something like that, this setup can easily cost $200+ with less than 1vCPU per psql node.

i would select the nodes with an additional HDD next to nvme, as these hdd discs retain your data after a reinstall of your node. Very handy when you want to rebuild a server.

pmasta

@ehab said:
@pmasta what is your load?

200 sql statements/s peak, usually around 80 though. On an 8GB ovh vps, this consumes around 1gb memory.

AnthonySmith

It's an interesting idea; my advice would be to try it and see, but remember the whole point of TierHive is that it's cheap and hobby-grade. Build your own redundancy. If you are willing to do a fairly detailed guide/write up and details on your experience, positive or negative, I am happy to cover the first month of tokens or so for you to test it to remove any financial risk of trying.

ehab

@pmasta said:

@ehab said:
@pmasta what is your load?

200 sql statements/s peak, usually around 80 though. On an 8GB ovh vps, this consumes around 1gb memory.

best way to select one and load test it.... see if Ant throws pants at you.