News for hackers. Stuff that matters.
Re:Timescale Announces New Database Cloud by eloff on Tuesday October 05, 2021 @03:40PM (#28764565)
This is quite interesting. Some of the features and upcoming features look really nice. One-click database forks would be really handy. VPC peering is nice, not just for security, but also so AWS doesn't fleece you with bandwidth charges ($0.01/GB on your side and timescale side in the same AZ, and worse if not. For big data systems that can be a lot.)

I wonder how the storage works: https://docs.timescale.com/cloud/latest/scaling-a-service/#p...

Seems like to scale it separately it would need to be EBS not local instance storage? I wonder if magnetic or SSD? That does constrain the performance, especially for queries.

Re:Timescale Announces New Database Cloud by clarkbw on Tuesday October 05, 2021 @05:38PM (#28765959)
Yes, we use EBS SSD on the backend so we can scale up storage separately from the instance. Our Cloud performance metrics are based on this backend so the short answer is no it doesn't constrain perf. The constraint I see right now is that we are currently mostly GP2 with a planned migration to GP3 which will allow for new independent controls of IOPS and throughput. There are certain, uncommon, situations where customers need to bump up performance beyond what the normal GP2 perf steps allow.

To tie GP2/3 back into the serverless vs. DBaaS concepts we are looking at auto-scale for IOPS/Throughput performance while also allowing more direct access such that a customer could control performance via APIs to manage on your own.

(timescaler here)

Re:Timescale Announces New Database Cloud by mfreed on Tuesday October 05, 2021 @06:14PM (#28766399)
And to follow up: Today your IOPS will automatically scale with storage, and you can set storage to autoscale with your usage. Under the covers, we continually look for ways we can optimize that for our users, without them having to think of this.

So for most users, they can "set it and forget it" (easy, scalable): Launch a default cloud database, which starts out small, autoscaling on by default. As they start inserting data, the system automatically detects when it starts to approach current capacity and automatically increases (without any downtime) to more capacity & IOPS.

But for the power user, they have greater control. What that means is that you can manually resize, and as mentioned above, we'll likely also give you independent control over IOPS (independent of capacity). That's the flexibility and control we think developers also want...or at least know is there is they need it.

(Timescaler & post author)

Re:Timescale Announces New Database Cloud by eloff on Wednesday October 06, 2021 @04:34PM (#28778081)
That makes sense to me. Are you saying you're not IO limited usually though?

Some kinds of database workloads would run more efficiently on the local NVMe storage. But that does come with lots of operational considerations.

Re:Timescale Announces New Database Cloud by jsjsossse on Tuesday October 05, 2021 @11:59PM (#28769036)
Bandwidth on vpc peering is free within the same AZ since may 2021