5 ms·

(Disclaimer: Ozgun from Citus) I'm not a video person, but when I watched this one, I was quite impressed. I feel this may be one of those rare occasions where

by ozgune 10y ago

(Disclaimer: Ozgun from Citus) I'm not a video person, but when I watched this one, I was quite impressed. I feel this may be one of those rare occasions where the blog post title can't quite capture some of all parts in the video. https://youtu.be/JAPl4eNFxk4 https://youtu.be/JAPl4eNFxk4 I think the really impressive part is what happens for you behind the covers. MX sets up replication, auto-failover, backups, pgbouncer, monitoring dashboard, etc. for you through the click of a button.

merb 10y ago
this product seems interesting, especially for a small company with high demands (scale out), however it sucks that you don't write any prices for your cloud product on your page. I know that a lot of these prices will be created with your customers but still If I just want to use it in the cloud via my AWS Account it would be cool to have PPM shown anywhere. something like 1€ + AWS Node for a cluster of X. Having a price upfront for Cloud products is actually why we my company is using the cloud. It's just simple to get started without any sales person. Just click, deploy, automate.
- craigkerstiens 10y ago
  We have a few links to our pricing calculator in various places, but we'll work to do a better job surfacing. You can find the pricing at: https://console.citusdata.com/pricing https://console.citusdata.com/pricing
  - merb 10y ago
    there is one thing missing, if it excludes or includes machine prices (I just wondered cause I doubt that it includes them since I've never seen a per memory pricing), but it's great. Other things that are missing is, what happens if X goes down, but I guess that's found in your documentation. and there is no pricing for additional redundancy. Just from the video and the price toggler it seems that the data is there two times (primary/secondary on HA) or am I wrong? Edit: I forgot the price is amazing. Especially if everything is working like it does in your video. I basically never seen a solution that scales PG that easily and even outscales most other solutions and could reshard / rebalance with a query / click. Just amazing, really. Edit2: Pricing is: Extremly cheap.
    - craigkerstiens 10y ago
      Thanks for the feedback. This is fully inclusive of machine prices, backups, everything. For redundancy there's two things. First is for data durability, we archive all updates to S3 every 16 MB or 60 seconds whichever comes first, using WAL-E. Second, if you want higher availability you enable that. In that case, we run a streaming replica for all nodes in the cluster, those nodes receive updates as they happen. In the event of some failure (which we continuously monitor for) we automatically fail you over to the standby.
      - koolba 10y ago
        > In the event of some failure (which we continuously monitor for) we automatically fail you over to the standby. Is there a transparent load balancer in front of the servers to handle that or would the master endpoint host change in the case of a failover? I noticed in the video that the database URL connected to is a raw EC2 hostname. Can't tell if it's a load balancer or the raw server though. In either case I'm assuming any connections in a pool would have to be re-opened (new TCP sockets) but updating the host for the DB is a bit more involved (and would require an app reboot) v.s. just allowing the connection pool to auto recover.
        fdr 10y ago
        All network addresses of every node is kept the same for-ever, even as they are replaced, via AWS Elastic IPs. The burden on the client application is to timeout and re-connect only.
ddorian43 10y ago
Will this be open source ? This is the masterless citus?
- pwmtr 10y ago
  (Disclaimer: Burak from Citus) Yes and yes. For now, this is only for cloud but we are integrating it to our open source version. So yes, it will be open source. And yes it is masterless Citus. Changes to schema still have to go through a single node(coordinator node), but DML can now be run on any node.

by ozgune 10y ago

merb 10y ago

this product seems interesting, especially for a small company with high demands (scale out), however it sucks that you don't write any prices for your cloud product on your page. I know that a lot of these prices will be created with your customers but still If I just want to use it in the cloud via my AWS Account it would be cool to have PPM shown anywhere. something like 1€ + AWS Node for a cluster of X. Having a price upfront for Cloud products is actually why we my company is using the cloud. It's just simple to get started without any sales person. Just click, deploy, automate.

craigkerstiens 10y ago
We have a few links to our pricing calculator in various places, but we'll work to do a better job surfacing. You can find the pricing at: https://console.citusdata.com/pricing https://console.citusdata.com/pricing
- merb 10y ago
  there is one thing missing, if it excludes or includes machine prices (I just wondered cause I doubt that it includes them since I've never seen a per memory pricing), but it's great. Other things that are missing is, what happens if X goes down, but I guess that's found in your documentation. and there is no pricing for additional redundancy. Just from the video and the price toggler it seems that the data is there two times (primary/secondary on HA) or am I wrong? Edit: I forgot the price is amazing. Especially if everything is working like it does in your video. I basically never seen a solution that scales PG that easily and even outscales most other solutions and could reshard / rebalance with a query / click. Just amazing, really. Edit2: Pricing is: Extremly cheap.
  - craigkerstiens 10y ago
    Thanks for the feedback. This is fully inclusive of machine prices, backups, everything. For redundancy there's two things. First is for data durability, we archive all updates to S3 every 16 MB or 60 seconds whichever comes first, using WAL-E. Second, if you want higher availability you enable that. In that case, we run a streaming replica for all nodes in the cluster, those nodes receive updates as they happen. In the event of some failure (which we continuously monitor for) we automatically fail you over to the standby.
    - koolba 10y ago
      > In the event of some failure (which we continuously monitor for) we automatically fail you over to the standby. Is there a transparent load balancer in front of the servers to handle that or would the master endpoint host change in the case of a failover? I noticed in the video that the database URL connected to is a raw EC2 hostname. Can't tell if it's a load balancer or the raw server though. In either case I'm assuming any connections in a pool would have to be re-opened (new TCP sockets) but updating the host for the DB is a bit more involved (and would require an app reboot) v.s. just allowing the connection pool to auto recover.
      - fdr 10y ago
        All network addresses of every node is kept the same for-ever, even as they are replaced, via AWS Elastic IPs. The burden on the client application is to timeout and re-connect only.

ddorian43 10y ago

Will this be open source ? This is the masterless citus?

pwmtr 10y ago
(Disclaimer: Burak from Citus) Yes and yes. For now, this is only for cloud but we are integrating it to our open source version. So yes, it will be open source. And yes it is masterless Citus. Changes to schema still have to go through a single node(coordinator node), but DML can now be run on any node.